Hacker News
- SQLite-based databases on the Postgres protocol? Yes we can https://blog.turso.tech/sqlite-based-databases-on-the-postgres-protocol-yes-we-can-358e61171d65?gi=b00cf93b1837 42 comments
- Postgresqlite: Use Postgres Like SQLite https://github.com/fdietze/postgresqlite 2 comments
- Show HN: Bi-directional sync between Postgres and SQLite https://powersync.com 105 comments
- PostgreSQL foreign data wrapper for SQLite databases https://pgxn.org/dist/sqlite_fdw/1.1.0/ 2 comments
- Don't test with SQLite when you use Postgres in Production http://michael.robellard.com/2015/07/dont-test-with-sqllite-when-you-use.html 105 comments
- Liya – Mac client for MySQL, SQLite and Postgres http://www.cutedgesystems.com/software/Liya/ 2 comments
- SQLite vs MySQL vs PostgreSQL https://www.digitalocean.com/community/articles/sqlite-vs-mysql-vs-postgresql-a-comparison-of-relational-database-management-systems 79 comments
- ArrestDB: A RESTful PHP API for SQLite, MySQL and PostgreSQL Databases https://github.com/alixaxel/ArrestDB/ 2 comments
- Migrating an SQLite based django app to PostgreSQL http://stevelord.tumblr.com/post/86674737/migrating-an-sqlite-based-django-app-to-postgresql 13 comments
- SQLedge: Replicate Postgres to SQLite on the Edge https://github.com/zknill/sqledge 79 comments
- Replacing Postgres with rqlite, the lightweight, distributed DB built on SQLite https://www.philipotoole.com/replicated-postgres-to-rqlite/ 2 comments
- 🔗 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
- GitHub - benbjohnson/postlite: Postgres wire compatible SQLite proxy. https://github.com/benbjohnson/postlite 2 comments postgresql
- Django - growing up from SQLite to PostgreSQL https://tinystruggles.com/posts/django_db_change/ 7 comments django
- Type-safe database client for Postgres, MySQL & SQLite https://github.com/prisma/prisma-client-go 13 comments golang
- 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
- a command-line, n-curses (-ish?) database management tool for mysql, sqlite, postgresql, maybe more https://github.com/coffeeandscripts/sqlcrush 16 comments sysadmin
- PostgreSQL, MySQL, SQLite syntax comparsion http://hyperpolyglot.org/db 5 comments programming
- 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
- pgsqlite: a pure python module to import sqlite databases into postgres https://github.com/bitdotioinc/pgsqlite 7 comments programming
- 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
- SQLx 0.3 released! Now with support for SQLite, zero-copy/amortized-allocation row decoding, nullable columns, user-defined types and LISTEN/NOTIFY in Postgres, plus a bunch more data types! https://github.com/launchbadge/sqlx/blob/master/changelog.md#030---2020-03-29 25 comments rust
- 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
- SQLcrush now lets you make your own queries to view as a table right there in the console (MySQL, SQLite, postgreSQL) https://github.com/coffeeandscripts/sqlcrush 3 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
- 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
- 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