from Hacker News

Will PocketBase Survive?

by alxjsn on 12/23/24, 7:03 PM with 10 comments

  • by vunderba on 12/24/24, 2:15 AM

    I really like Pocketbase as a simpler and locally hosted Firebase/Supabase alternative (yes I know Supabase can be self-hosted but its pretty heavyweight) except for one major disadvantage - the lack of a NULL primitive type.

    There's no ability to set null as a value of an item despite null being a perfectly valid data type in SQLite (which is what Pocketbase uses).

    Having to arbitrarily assign a MAGIC CONSTANT value (like -1 for example) to represent a "lack of information" in a column is kludgy at best, and impossible at worst - e.g. if all floating point values have meaning in a column, you're out of luck. The only workaround is to create an unnecessary additional boolean column isNumFilled to indicate if the data in the numerical column is valid.

  • by jasfi on 12/24/24, 6:03 PM

    For a project with 42.2K stars I thought there would be sponsors by now.

  • by demarq on 12/24/24, 10:23 AM

    The answer from the maintainer is PERFECT.

    This is the situation for a lot of open source projects.

  • by ianschmitz on 12/24/24, 1:23 AM

    (2023)