4 ms·
> For some reason, IME, SQLite feels the hardest to use of the popular databases. sqlite is, above all else, a C API for interacting with a database. Try using
by sgbeal 4y ago
> For some reason, IME, SQLite feels the hardest to use of the popular databases.
sqlite is, above all else, a C API for interacting with a database. Try using the C APIs for Postgres or MySQL or Oracle/OCI, and i _guaranty_ you you'll find sqlite's easier to work with _by leaps and bounds_.
- nijave 4y agoI'm guessing this varies a lot by language and library. In Python, it uses DB-API 2.0 which is a Python interface so it's basically the same as, say, Postgres (minus the sql dialect quirks). I'd think something like JDBC would do the same for Java, etc
- sgbeal 4y agoi can't speak to the high-level wrappers, but the native C API for MySQL is atrocious, the one for PostGres is meh, and the OCI is also (in my very limited experience) also meh. sqlite's C API (its core-most product) is a dream to use in comparison to its competitors.