Hacker News
- I Migrated from a Postgres Cluster to Distributed SQLite with LiteFS https://kentcdodds.com/blog/i-migrated-from-a-postgres-cluster-to-distributed-sqlite-with-litefs 59 comments
- Instant Realtime APIs Using PostgreSQL, MySQL, SQLite, SQLServer and Planetscale https://wundergraph.com/blog/instant_realtime_apis_using_postgresql_mysql_sqlite_sqlserver_planetscale 2 comments
- ArrestDB: A RESTful PHP API for SQLite, MySQL and PostgreSQL Databases https://github.com/alixaxel/ArrestDB/ 2 comments
- SQLedge: Replicate Postgres to SQLite on the Edge https://github.com/zknill/sqledge 79 comments
- Nocodb: Turns Any MySQL, Postgres, SQLite into a Spreadsheet with REST APIs https://github.com/nocodb/nocodb 36 comments
Lobsters
- SQLite-based databases on the postgres protocol? Yes we can https://blog.chiselstrike.com/sqlite-based-databases-on-the-postgres-protocol-yes-we-can-358e61171d65 2 comments databases
- Database Performance: PostgreSQL vs MySQL vs SQLite for 1000 Row Inserts https://blog.probirsarkar.com/database-performance-benchmark-postgresql-vs-mysql-vs-sqlite-which-is-the-fastest-ae7f02de88e0?sk=621e9b13009d377e50f86af0ae170c43 15 comments postgresql
- smyrgeorge/sqlx4k: A high-performance Kotlin Native database driver for PostgreSQL, MySQL, and SQLite. https://github.com/smyrgeorge/sqlx4k 2 comments rust
- Sqlx4k: A non-blocking database driver for PostgreSQL, MySQL and SQLite, written in Kotlin for the Native Platform. I just published the new version that adds support for windows. https://github.com/smyrgeorge/sqlx4k 4 comments kotlin
- Benchmarking SQLite Performance in Go. Using Go's awesome built-in simple benchmarking tools to investigate SQLite database performance in a couple of different benchmarks, plus a comparison to Postgres. https://www.golang.dk/articles/benchmarking-sqlite-performance-in-go 63 comments golang
- 🔗 Using MySQL and Postgres functions inside SQLite https://bannister.me/blog/using-mysql-and-postgres-functions-in-sqlite 6 comments laravel
- SQLite or PostgreSQL? It's Complicated! https://www.twilio.com/blog/sqlite-postgresql-complicated 2 comments postgresql
- SQLite or PostgreSQL? It's complicated! https://www.twilio.com/blog/sqlite-postgresql-complicated 57 comments programming
- Django - growing up from SQLite to PostgreSQL https://tinystruggles.com/posts/django_db_change/ 7 comments django
- DuckDB – An embeddable SQL database like SQLite, but supports Postgres features https://duckdb.org/ 82 comments programming
- Detecting Optimization Bugs in Database Engines via Non-Optimizing Reference Engine Construction [PDF]: "We found 159 bugs in SQLite, MariaDB, PostgreSQL, and CockroachDB, 141 of which have been fixed" https://www.manuelrigger.at/preprints/norec.pdf 32 comments programming
- Failing my way through switching from sqlite to postgres, part 2. An error. Help? https://www.reddit.com/r/django/comments/a42jgb/failing_my_way_through_switching_from_sqlite_to/ 16 comments django
- Would Postgres be faster/better than SQLite for my project? https://www.reddit.com/r/webdev/comments/6s0hzu/would_postgres_be_fasterbetter_than_sqlite_for_my/ 4 comments webdev
- [Ask Flask] Moving database from sqlite to postgres causes a 400 Bad Request error https://www.reddit.com/r/flask/comments/694vki/ask_flask_moving_database_from_sqlite_to_postgres/ 10 comments flask
- PostgreSQL, MySQL, SQLite syntax comparsion http://hyperpolyglot.org/db 5 comments programming
- Database views in ActiveRecord: Spectacles (PostgreSQL, MySQL, SQLite) https://github.com/liveh2o/spectacles 6 comments ruby
- What I learned about SQLite…at a PostgreSQL conference http://use-the-index-luke.com/blog/2014-05/what-i-learned-about-sqlite-at-a-postgresql-conference 221 comments programming
- SQLite vs MySQL vs PostgreSQL https://www.digitalocean.com/community/articles/sqlite-vs-mysql-vs-postgresql-a-comparison-of-relational-database-management-systems 16 comments webdev
- Try Valentina Studio - a new FREE GUI Manager for PostgreSQL, mySQL, mariaDB, SQLite. It works native on Mac, Linux, Windows. http://www.valentina-db.com/valentina-studio-overview 92 comments webdev
- Porting SQLite code to Postgres [x-post /r/postgresql] http://icculus.org/~chunky/stuff/sqlite3_example/sqlite_to_pgsql.html 8 comments programming
- Sqlx4k: A high-performance Kotlin Native database driver for PostgreSQL, MySQL, and SQLite. Just released version 0.18.0 that adds support for SQLDelight. https://github.com/smyrgeorge/sqlx4k 11 comments kotlin
- Introducing pgsqlite, a pure python module for import sqlite into postgres https://innerjoin.bit.io/introducing-pgsqlite-a-pure-python-module-to-import-sqlite-databases-into-postgres-bf3940cfa19f 4 comments postgresql
- Batch and Bulk Inserts with 2 Lines of Code (MySQL, SQLite, SQL Server, PostgreSQL) https://tortugatech.wordpress.com/2019/12/26/batch-and-bulk-inserts-with-2-lines-of-code/ 14 comments dotnet
- TypeORM - data-mapper ORM for TypeScript and JavaScript (ES7, ES6, ES5). Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, WebSQL databases. Works in Node.js and Browser. https://github.com/typeorm/typeorm 11 comments javascript
- TypeORM - data-mapper ORM for TypeScript and JavaScript (ES7, ES6, ES5). Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, WebSQL databases. Works in Node.js and Browser. https://github.com/typeorm/typeorm 28 comments programming
- Data-Mapper ORM for TypeScript and JavaScript (ES7, ES6, ES5). Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, WebSQL databases. Works in Node.js and Browser. https://github.com/typeorm/typeorm 16 comments dotnet
- Data-Mapper ORM for TypeScript and JavaScript (ES7, ES6, ES5). Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, WebSQL databases. Works in Node.js and Browser. https://github.com/typeorm/typeorm 9 comments node
- Kexi - open-source alternative to Microsoft Access and Filemaker Pro supporting PostgreSQL, MySQL, SQLite back-ends http://www.kexi-project.org/ 14 comments programming
- Easy migrations for relational databases with rollback on failure (works with at least Postgres and SQLite, but probably not MySQL) https://github.com/burntsushi/migration 5 comments golang
- ODB C++ ORM updated benchmark results (MySQL, PostgreSQL, SQL Server, SQLite) http://www.codesynthesis.com/~boris/blog/2012/02/02/updated-odb-benchmark-results/ 4 comments cpp
- Hey Django Reddit -- This is my very first ever open source code released to the wild. It's an app that will backup your Postgres, MySQL, or SQLite database to Dropbox. https://bitbucket.org/mjs7231/django-dbbackup 5 comments django
- ruby program to output docs in: plaintext, html, XHTML, XML, ODF (OpenDocument), LaTeX, PDF, SQL (PostgreSQL and SQLite) http://www.jus.uio.no/sisu/ 5 comments programming
- Bun reaches v1: SQL-first DB client for PostgreSQL, MySQL, and SQLite https://bun.uptrace.dev/ 6 comments golang
- TypeORM 0.1.0 is released. Besides MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, WebSQL databases now supports MongoDB, added Ionic/Cordova platform support and lot of other new features. The most feature-rich NodeJS ORM with amazing developer experience for small and enterprise applications. http://typeorm.io/ 16 comments typescript
- SQLite vs. MySQL vs. PostGreSQL: What's best for my project? (small-medium sized database, few users, tons of queries) https://www.reddit.com/r/django/comments/4vmyrm/sqlite_vs_mysql_vs_postgresql_whats_best_for_my/ 25 comments django