Re:Pocketbase – open-source realtime back end in 1 file
by burky on Friday November 28, 2025 @02:09PM
(#46081747)
This and DATETIME. The workarounds for these are mostly fine if you’re just using SQLite as a key value store, but doing translations in SQL queries for these workarounds sounds atrocious.
[ Parent
| on HN ]
Re:Pocketbase – open-source realtime back end in 1 file
by mike_d on Friday November 28, 2025 @02:59PM
(#46082221)
90% of people aren't using "SQL" anyway. They are just doing basic CRUD operations on a data store with SQL syntax, usually abstracted through an ORM. The only reason they want a SQL database in the first place is for ACID.
If you find yourself caring about data types or actually writing a query, you should probably setup an actual database server.