News for hackers. Stuff that matters.

A comment on Ask HN: Which software should exist, but doesn't?.

Re:Ask HN: Which software should exist, but doesn't? by rurban on Saturday July 03, 2021 @02:44AM (#27719840)
A safe sqlite-like file-based, small database, without backend. Phones would need such a SW. SQLite is a clever hack, but not usable for safe usage. And the text search engine is still fundamentally broken and insecure, even in its 5th iteration.

One should not need PostgreSQL for small problems.

[ Parent | on HN ]
Re:Ask HN: Which software should exist, but doesn't? by SahAssar on Saturday July 03, 2021 @09:50AM (#27721611)
Could you say why you don't consider SQLite safe? And how the text search is broken and insecure?

I use SQLite quite a bit and I've never found it to be unsafe or insecure.

[ Parent | on HN ]
Re:Ask HN: Which software should exist, but doesn't? by thijsvandien on Saturday July 03, 2021 @03:40PM (#27724185)
There's also Firebird Embedded if you care about types and a couple more features. It doesn't come with full-text search out of the box, but there are options: http://www.firebirdfaq.org/faq328/.
[ Parent | on HN ]
Re:Ask HN: Which software should exist, but doesn't? by umbrellaguy on Saturday July 03, 2021 @03:15AM (#27719924)
Can you expand on "without backend" in regards to SQLite, or rather its shortcomings?
[ Parent | on HN ]