News for hackers. Stuff that matters.

A comment on Hctree is an experimental high-concurrency database back end for SQLite. Parent comment

Re:Hctree is an experimental high-concurrency database back ... by nl on Thursday January 19, 2023 @01:29AM (#34437337)
Doesn't almost every language have some kind of abstraction layer that allows this?

JDBC/ODBC/DB-API/Sequelize ORM (ignoring the ORM part).

This used to be one of the major use cases for SQLite - running automated tests and being able to throw away the database file (or manage it at different points in the tests).

[ Parent | on HN ]
Re:Hctree is an experimental high-concurrency database back ... by deredede on Thursday January 19, 2023 @03:30AM (#34438016)
ODBC doesn't help you if you use any sort of pgsql-specific extension, however.
[ Parent | on HN ]
Re:Hctree is an experimental high-concurrency database back ... by hot_gril on Thursday January 19, 2023 @12:35PM (#34443058)
Yeah, but the abstraction layers get in the way if/when I need to optimize queries or use special features, plus it's easier to just write SQL. I'd rather target a specific DBMS and rewrite my queries if I ever change it.

> ignoring the ORM part

As it should be :)

[ Parent | on HN ]
Re:Hctree is an experimental high-concurrency database back ... by nl on Thursday January 19, 2023 @05:08PM (#34446360)
No, all (?) these things let you pass raw SQL straight to the database.

In the case of JDBC and ODBC (and I think DB-API) thats all they do.

[ Parent | on HN ]
Re:Hctree is an experimental high-concurrency database back ... by hot_gril on Thursday January 19, 2023 @05:36PM (#34446651)
But raw SQL made for Postgres doesn't necessarily work for SQLite and vice versa. That's what I mean by the SQL standard being thrown out the window. You might be able to write SQL that works in both if you're careful and avoid a lot of features.
[ Parent | on HN ]