Re:Show HN: PocketBase – Open Source realtime backend in one...
by randomwebdev on Thursday July 07, 2022 @12:10PM
(#32015819)
"Collections" stores a single records table meta data (eg. name, fields, validators, etc.), so when you create a new collection a new related table will be created (see https://github.com/pocketbase/pocketbase/blob/3d07f0211dc747...).
The admin UI just shows the collections through the web api (https://pocketbase.io/docs/api-collections/).
I actually started with GORM, but its too complex and I ended up replacing it with a simpler query builder package (ozzo-dbx). While the query builder has abstraction for other databases, I'm not planning supporting them at the moment.
Re:Show HN: PocketBase – Open Source realtime backend in one...
by giancarlostoro on Thursday July 07, 2022 @12:37PM
(#32016178)
No worries, I've seen another project called UAdmin that kind of reminds me of this, my problem with UAdmin was that there were bugs and I didn't quite get why it worked how it worked, but having used Django since I realized what I was missing out on.
Thank you for following up, I did see you had a package for extending the built-in Go package for SQL.
Does it render pages automatically based on Schema? I see your really simple example under examples, and its so minimal I want to think you just get all the tables and render views from that. Am I crazy? If so this is really neat.
Did you ever consider using something like GORM? Because I could see this working with other databases and being extremely useful. I use Django to build really quick CRUD interfaces, but sometimes I need to be able to customize it more, and the admin UI is not as extensible as I would normally want, they even suggest you just build custom pages if its not doing what you need, which is a bummer because Django Admin covers the majority of my use cases.