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 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 ]