microcosm VS webcrate

Manual via https://pkg.go.dev/database/sql with handwritten SQL in the majority of places... but with a wrapper to handle the more complex search scenarios.

For example these from a multi-tenant SaaS forum platform...

This helper to get connections: https://github.com/microcosm-cc/microcosm/blob/master/helper... used like this for inserts: https://github.com/microcosm-cc/microcosm/blob/master/models... and this for reads https://github.com/microcosm-cc/microcosm/blob/master/models... .

But searches... i.e. highly consistent SELECT queries with different WHERE statements (and potentially FROM statements), then in each project I tend to have an idea of a search struct ( https://github.com/microcosm-cc/microcosm/blob/master/models... ) that will validate the inputs and represent the search query, and then something that will consume that and build the SQL for it ( https://github.com/microcosm-cc/microcosm/blob/master/models... ). This isn't pretty... but it's easy for me to tune, debug, and keeps the rest of the code base very maintainable... all the complexity is here in the search.

The vast majority of SQL is very very simple and needs no ORM, and the complexity is just in the search scenario where I want to be able to tune the performance more than an ORM would allow me to do so.

Tool you linked is open source apparently (https://github.com/WebCrateApp/webcrate) so you should be able to self-host it on your own. They have no specific docs for it though...

Hey fellow internet users! I always got frustrated with existing bookmarking tools as they were either too clunky to use or had way too many features I didn't need. Until I decided to just build my own!

WebCrate allows you to organize links, articles and more from around the web into collections called crates. You can share the crates with anyone and since each user gets their own instance of WebCrate in their own 'personal cloud' thanks to Deta Space, you can subscribe to other users crates and view their links right from your dashboard.

Learn more at http://webcrate.app or install it directly on Deta Space (https://deta.space/discovery/webcrate)! Let me know what you think (WebCrate is OSS, so you can also contribute) and I hope you find it useful!

👨‍💻 WebCrate is also open source, report any issues you find, suggest features, or contribute directly with code on GitHub!

WebCrate helps you organize and share links, articles and more from around the web in a central place. It's open source & can be easily self-hosted thanks to your own personal cloud in Deta Space.

WebCrate is completely separate from the browser. You can learn more on the homepage: webcrate.app.

https://webcrate.app - OSS bookmarking tool to help you organize your web

- Vue / Nuxt / Plain CSS

- TypeScript / Node / Express

- Hosted in your own personal cloud thanks to Deta Space (https://deta.space/discovery/webcrate)

Nuxt made the frontend super simple and fast to build, it takes care of a lot of things for you! Deta is also awesome for devs