News for hackers. Stuff that matters.

A comment on We’re pretty happy with SQLite and not urgently interested in a fancier DBMS. Parent comment

Re:We’re pretty happy with SQLite and not urgently intereste... by ben_jones on Sunday June 19, 2016 @06:31PM (#11935028)
Two questions:

Wouldn't a "full" RDBMS like Mysql/Postgres offer a ton of benefits over SQLite (like the features to handle edge cases as they arise) to the point where, even if SQLite would work, SQLite still wouldn't be the ideal choice?

Does wordpress completely abstract the database or do third-party plugins use their own interfaces to the database, in which case a migration to SQLite would break a lot of them?

[ Parent | on HN ]
Re:We’re pretty happy with SQLite and not urgently intereste... by dietrichepp on Sunday June 19, 2016 @06:49PM (#11935107)
Wordpress does not abstract the database, so migration to SQLite would break tons of plugins.

Wordpress is also a PHP application, and it's common to have multiple PHP processes running in parallel, which makes it much harder to use SQLite.

[ Parent | on HN ]
Re:We’re pretty happy with SQLite and not urgently intereste... by spilk on Sunday June 19, 2016 @07:58PM (#11935362)
Wordpress does attempt some abstraction of the database via its various wrapper classes/functions like wpdb, WP_Query, etc. It's definitely not ORM-level abstraction by any stretch of the imagination, though.
[ Parent | on HN ]