{"id":10679,"date":"2023-08-09T16:54:45","date_gmt":"2023-08-09T14:54:45","guid":{"rendered":"https:\/\/monodes.com\/predaelli\/?p=10679"},"modified":"2023-08-09T16:54:49","modified_gmt":"2023-08-09T14:54:49","slug":"sqledge","status":"publish","type":"post","link":"https:\/\/monodes.com\/predaelli\/2023\/08\/09\/sqledge\/","title":{"rendered":"SQLedge"},"content":{"rendered":"\n

SQLedge: Replicate Postgres to SQLite on the Edge – https:\/\/github.com\/zknill\/sqledge<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

SQLedge: Replicate Postgres to SQLite on the Edge – https:\/\/github.com\/zknill\/sqledge<\/p>\n

Read more →<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"link","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":[52,14],"tags":[303,349],"class_list":["post-10679","post","type-post","status-publish","format-link","hentry","category-software","category-software-libero","tag-postgresql","tag-sqlite","post_format-post-format-link"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/s6daft-sqledge","jetpack-related-posts":[{"id":9404,"url":"https:\/\/monodes.com\/predaelli\/2022\/05\/30\/in-a-single-file\/","url_meta":{"origin":10679,"position":0},"title":"In a single file!","author":"Paolo Redaelli","date":"2022-05-30","format":false,"excerpt":"Adminer \u00ad A full-featured database management tool written in PHP, in a single PHP file Adminer is available for MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, Elasticsearch, MongoDB and others via plugin.","rel":"","context":"In "PHP"","block_context":{"text":"PHP","link":"https:\/\/monodes.com\/predaelli\/category\/php\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":9720,"url":"https:\/\/monodes.com\/predaelli\/2022\/10\/15\/uniform-exchange-format-uxf\/","url_meta":{"origin":10679,"position":1},"title":"Uniform eXchange Format (uxf)","author":"Paolo Redaelli","date":"2022-10-15","format":false,"excerpt":"Uniform eXchange Format (uxf) is a plain text human readable optionally typed storage format that supports custom types. It may serve as a convenient alternative to csv, ini, json, sqlite, toml, xml, or yaml. https:\/\/github.com\/mark-summerfield\/uxf Looks smart and interesting! Expecially this part: Implmenting a UXF pretty printer whould be doable\u2026","rel":"","context":"In "Software"","block_context":{"text":"Software","link":"https:\/\/monodes.com\/predaelli\/category\/software\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3778,"url":"https:\/\/monodes.com\/predaelli\/2018\/02\/10\/3778\/","url_meta":{"origin":10679,"position":2},"title":"OpenSC2K","author":"Paolo Redaelli","date":"2018-02-10","format":false,"excerpt":"OpenSC2K OpenSC2K - An Open Source remake of SimCity 2000 written in JavaScript using HTML5 Canvas API, SQLite and built on Electron.","rel":"","context":"In "Fun"","block_context":{"text":"Fun","link":"https:\/\/monodes.com\/predaelli\/category\/fun\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/monodes.com\/predaelli\/wp-content\/uploads\/sites\/4\/2018\/02\/OpenSC2K.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/monodes.com\/predaelli\/wp-content\/uploads\/sites\/4\/2018\/02\/OpenSC2K.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/monodes.com\/predaelli\/wp-content\/uploads\/sites\/4\/2018\/02\/OpenSC2K.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/monodes.com\/predaelli\/wp-content\/uploads\/sites\/4\/2018\/02\/OpenSC2K.png?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/monodes.com\/predaelli\/wp-content\/uploads\/sites\/4\/2018\/02\/OpenSC2K.png?resize=1050%2C600&ssl=1 3x, https:\/\/i0.wp.com\/monodes.com\/predaelli\/wp-content\/uploads\/sites\/4\/2018\/02\/OpenSC2K.png?resize=1400%2C800&ssl=1 4x"},"classes":[]},{"id":4883,"url":"https:\/\/monodes.com\/predaelli\/2018\/11\/07\/unqlite-an-embeddable-nosql-database-engine\/","url_meta":{"origin":10679,"position":3},"title":"UnQLite – An Embeddable NoSQL Database Engine","author":"Paolo Redaelli","date":"2018-11-07","format":false,"excerpt":"UnQLite - An Embeddable NoSQL Database Engine UnQLite is a in-process software library which implements a self-contained, serverless, zero-configuration, transactional NoSQL database engine. UnQLite is a document store database similar to MongoDB, Redis, CouchDB etc. as well a standard Key\/Value store similar to BerkeleyDB, LevelDB, etc. A cousin of the\u2026","rel":"","context":"In "Software Libero"","block_context":{"text":"Software Libero","link":"https:\/\/monodes.com\/predaelli\/category\/software\/software-libero\/"},"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":10679,"position":4},"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 "Software Libero"","block_context":{"text":"Software Libero","link":"https:\/\/monodes.com\/predaelli\/category\/software\/software-libero\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":8190,"url":"https:\/\/monodes.com\/predaelli\/2021\/02\/21\/typeorm\/","url_meta":{"origin":10679,"position":5},"title":"Typeorm","author":"Paolo Redaelli","date":"2021-02-21","format":"link","excerpt":"typeorm.io is Object\u2013relational mapping for TypeScript and JavaScript (ES7, ES6, ES5). Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.","rel":"","context":"In "Javascript"","block_context":{"text":"Javascript","link":"https:\/\/monodes.com\/predaelli\/category\/javascript\/"},"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\/10679","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=10679"}],"version-history":[{"count":0,"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/posts\/10679\/revisions"}],"wp:attachment":[{"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/media?parent=10679"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/categories?post=10679"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/monodes.com\/predaelli\/wp-json\/wp\/v2\/tags?post=10679"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}