{"id":1165,"date":"2016-03-15T18:26:52","date_gmt":"2016-03-15T17:26:52","guid":{"rendered":"http:\/\/monodes.com\/predaelli\/?p=1165"},"modified":"2016-03-15T11:34:15","modified_gmt":"2016-03-15T10:34:15","slug":"ise-eiffel-sqlite","status":"publish","type":"post","link":"https:\/\/monodes.com\/predaelli\/2016\/03\/15\/ise-eiffel-sqlite\/","title":{"rendered":"(ISE) Eiffel SQLite"},"content":{"rendered":"<p>According to <em><a href=\"https:\/\/room.eiffel.com\/library\/eiffel_sqlite\">eiffelroom ISE has SQLite wrappers.<\/a> <\/em>Ok, the linked website (http:\/\/esqlite.origo.ethz.ch\/) is down but it must be noted that <span class=\"submitted\">Jocelyn Fiat<\/span> wrote it almost seven years ago.<\/p>\n<p><!--more--><\/p>\n<p>Meanwhile Eiffel Studio got some SQLite wrappers: <a href=\"https:\/\/svn.eiffel.com\/eiffelstudio\/trunk\/Src\/unstable\/library\/persistency\/database\/sqlite3\/sqlite_statement.e\">https:\/\/svn.eiffel.com\/eiffelstudio\/trunk\/Src\/unstable\/library\/persistency\/database\/sqlite3\/sqlite_statement.e <\/a><\/p>\n<p>I do like those copyright notes at the end: they released under GPLv2!<\/p>\n<p>And Liberty still don&#8217;t have them. Working with the current compiler I mean. I&#8217;ve got work to do&#8230;<\/p>\n<p><a href=\"https:\/\/github.com\/ynh\/eiffel-sqlite3\">ynh in his eiffel-sqlite3 Github repo<\/a><\/p>\n<p>kindly informs us that there are several tools to\u00a0 edit an sqlite database, for example<\/p>\n<ul>\n<li><a href=\"https:\/\/addons.mozilla.org\/en-US\/firefox\/addon\/5817\">https:\/\/addons.mozilla.org\/en-US\/firefox\/addon\/5817<\/a> for a Firefox SQLite database manager.<\/li>\n<li>or <a href=\"http:\/\/sqlitestudio.pl\/\">http:\/\/sqlitestudio.pl\/ <\/a>a nice tool that I promptly downloaded in sources and binaries<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p class=\"excerpt\">According to eiffelroom ISE has SQLite wrappers. Ok, the linked website (http:\/\/esqlite.origo.ethz.ch\/) is down but it must be noted that Jocelyn Fiat wrote it almost seven years ago.<\/p>\n<p class=\"more-link-p\"><a class=\"more-link\" href=\"https:\/\/monodes.com\/predaelli\/2016\/03\/15\/ise-eiffel-sqlite\/\">Read more &rarr;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"activitypub_content_warning":"","activitypub_content_visibility":"","activitypub_max_image_attachments":4,"activitypub_interaction_policy_quote":"anyone","activitypub_status":"","footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[34],"tags":[],"class_list":["post-1165","post","type-post","status-publish","format-standard","hentry","category-eiffel"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p6daft-iN","jetpack-related-posts":[{"id":1057,"url":"https:\/\/monodes.com\/predaelli\/2016\/03\/01\/1057\/","url_meta":{"origin":1165,"position":0},"title":"I can't believe I started\u2026","author":"Paolo Redaelli","date":"2016-03-01","format":"status","excerpt":"I can't believe I started Sqlite wrappers TEN years ago.... Tempus fugit","rel":"","context":"In &quot;Eiffel&quot;","block_context":{"text":"Eiffel","link":"https:\/\/monodes.com\/predaelli\/category\/eiffel\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":4760,"url":"https:\/\/monodes.com\/predaelli\/2018\/10\/23\/a-masterpiece\/","url_meta":{"origin":1165,"position":1},"title":"A masterpiece","author":"Paolo Redaelli","date":"2018-10-23","format":false,"excerpt":"SQLIte new Code Of Conduct is a masterpiece. Code Of Conduct 1. Overview Having been encouraged by clients to adopt a written code of conduct, the SQLite developers elected to govern their interactions with each other, with their clients, and with the larger SQLite user community in accordance with the\u2026","rel":"","context":"In &quot;Ethics&quot;","block_context":{"text":"Ethics","link":"https:\/\/monodes.com\/predaelli\/category\/ethics\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":10679,"url":"https:\/\/monodes.com\/predaelli\/2023\/08\/09\/sqledge\/","url_meta":{"origin":1165,"position":2},"title":"SQLedge","author":"Paolo Redaelli","date":"2023-08-09","format":"link","excerpt":"SQLedge: Replicate Postgres to SQLite on the Edge - https:\/\/github.com\/zknill\/sqledge","rel":"","context":"In &quot;Software&quot;","block_context":{"text":"Software","link":"https:\/\/monodes.com\/predaelli\/category\/software\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":8332,"url":"https:\/\/monodes.com\/predaelli\/2021\/04\/06\/its-still-a-masterpiece\/","url_meta":{"origin":1165,"position":3},"title":"It&#8217;s still a masterpiece","author":"Paolo Redaelli","date":"2021-04-06","format":false,"excerpt":"I confirm what I wrote in 2018: I still think that the document once known as SQLIte Code Of Conduct is a masterpiece. These days at the original address you can read this notice: Code of Conduct Due to concerns raised by readers, this document has been removed. The separate\u2026","rel":"","context":"In &quot;Senza categoria&quot;","block_context":{"text":"Senza categoria","link":"https:\/\/monodes.com\/predaelli\/category\/senza-categoria\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":9649,"url":"https:\/\/monodes.com\/predaelli\/2022\/09\/22\/sqlite-code-of-ethics-is-a-masterpiece\/","url_meta":{"origin":1165,"position":4},"title":"SQLite Code of Ethics is a masterpiece","author":"Paolo Redaelli","date":"2022-09-22","format":false,"excerpt":"Everyone love SQLite the small, efficient, embeddable SQL server that has been used everywhere. It is truly a masterpiece. Yet the real gem is its Code of Ethics Here I confirm what I wrote in 2018 and in 2021: I still think it is a code I can try to\u2026","rel":"","context":"In &quot;Ethics&quot;","block_context":{"text":"Ethics","link":"https:\/\/monodes.com\/predaelli\/category\/ethics\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":11513,"url":"https:\/\/monodes.com\/predaelli\/2024\/03\/24\/duckdb-as-the-new-jq\/","url_meta":{"origin":1165,"position":5},"title":"DuckDB as the New jq","author":"Paolo Redaelli","date":"2024-03-24","format":"quote","excerpt":"Recently, I\u2019ve been interested in the DuckDB project (like a SQLite geared towards data applications). And one of the amazing features is that it has many data importers included without requiring extra dependencies. This means it can natively read and parse JSON as a database table, among many other formats.\u2026","rel":"","context":"In &quot;Software Libero&quot;","block_context":{"text":"Software Libero","link":"https:\/\/monodes.com\/predaelli\/category\/software\/software-libero\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/posts\/1165","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/comments?post=1165"}],"version-history":[{"count":0,"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/posts\/1165\/revisions"}],"wp:attachment":[{"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/media?parent=1165"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/categories?post=1165"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/tags?post=1165"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}