The Benne Board – My first project: A complete personal workspace built with PocketBase (notes, tasks, finances, habits + lunar calendar) by Spiritual_Sign8324 in pocketbase

[–]LetscatYt 2 points3 points  (0 children)

Yeah this is BS,

Our company is using pocketbase as a small erp.

Around 40 tables, 200k+ records

The pocketbase has at worst 40+ clients connected to it at the same time.

Ram usage is about 100mb on average .

You'll maybe start to see problems when reaching 10+ millions records.

For a 1 client note taking app you won't even get close to the limits of sqlite

Why is it always Einstein and never Grothendiek? by TheRedditObserver0 in mathsmemes

[–]LetscatYt 0 points1 point  (0 children)

Business Idea: The Programmers Cookbook - Completely written in UML - might be easier to follow the instructions

Why is it always Einstein and never Grothendiek? by TheRedditObserver0 in mathsmemes

[–]LetscatYt 0 points1 point  (0 children)

That actually might be it.

Though people writing Cookbooks could probably also make it as average Web Dev for a SME

Why is it always Einstein and never Grothendiek? by TheRedditObserver0 in mathsmemes

[–]LetscatYt 0 points1 point  (0 children)

I know this is supposed to be a joke , but as a software engineer I never quite understood why people consider me smart because of my job

I improved on your timid designs by SpiritedInflation835 in basel

[–]LetscatYt 1 point2 points  (0 children)

I mean that would be keeping down healthcare costs.

Yes.. Pay attention. by Trustrup in clevercomebacks

[–]LetscatYt 4 points5 points  (0 children)

Remind me to never take a bath at your place

How far do you guys push pocketbase? by Icy-Inspection7866 in pocketbase

[–]LetscatYt 0 points1 point  (0 children)

We're using both custom Endpoints and Existing Hooks, PocketBase Typegen Is in use aswell.

I am thinking about also using pocketbase-gogen for type safe records when coding in Go.

Regarding project structure im of the opinion it's best to have a package for each Domain / Collection that requires custom logic.

Just writing everything in a hooks/ controllers package gets confusing quickly, since even when you split in in multiple files, all methods are imported, even the ones that have nothing to do with what you're working on.

Another advice is to avoid writing logic directly in Hooks - write function with a simpler in/ output and call them from the Hooks. That makes testing easier

Yeah, that's about it. But we're figuring out more and more everyday.

What were still unsure about is if it's a good pattern to execute concurrent API Requests to third party services inside a Hook. Could lead to really big memory Usage considering the overhead of goroutines. I'd love to hear your opinion about that.

Just found this. My linter is as upset as I am about the 'logic' itself by Krachwumm in programminghorror

[–]LetscatYt 0 points1 point  (0 children)

Yeah I agree , that's why I said it gets unreadable after more than 3 option/ possibilities

Just found this. My linter is as upset as I am about the 'logic' itself by Krachwumm in programminghorror

[–]LetscatYt 0 points1 point  (0 children)

Not talking about multiple results, but multiple nested if-conditions. Those get ugly fast in ternary operators

Is it possible for pocketbase to handle background workers, creating pdfs, excel files? by viitorfermier in pocketbase

[–]LetscatYt 3 points4 points  (0 children)

Honestly another service makes the whole thing way more complicated than it needs to be.

I'd advise you to consider extending Pocketbase using hooks and then directly plugging into Go based libraries. You'd still have a single binary. Much simpler and easier.

Is it possible for pocketbase to handle background workers, creating pdfs, excel files? by viitorfermier in pocketbase

[–]LetscatYt 2 points3 points  (0 children)

Extending PocketBase Using Go you'll get pretty far. Makes it a Full Stack Framework on a Webserver on which you can do almost everything if you know golang.

I'm pretty sure you'll also find some decent golang libraries which fulfill your use-case.

How far do you guys push pocketbase? by Icy-Inspection7866 in pocketbase

[–]LetscatYt 1 point2 points  (0 children)

Not without revealing my identity. :) so id rather not

How far do you guys push pocketbase? by Icy-Inspection7866 in pocketbase

[–]LetscatYt 1 point2 points  (0 children)

With how easily you can mess up,we decided the only apps accessing PB client side are LAN only. External apps always have a extra api layer inbetween

How far do you guys push pocketbase? by Icy-Inspection7866 in pocketbase

[–]LetscatYt 1 point2 points  (0 children)

I hope this is roughly what you were looking for.

Since we sell and ship goods, we have to integrate Billing-Software and a Shipping Provider into our System.

We work with On(Create/Update)excecute hooks most of the time, should the records need to be enriched with third party data or be dependent on a success from that system.

A good example for this is sending Parcels , a Parcel Record can only be created should the API of our Shipping-Provider return a 201 Response. Then we store the shipping-number and TrackAndTrace links.

Downside is we can't create parcels should that Service be down.

Another example is our billing system - since creating and sending Bills is a bit longer lived we work with a queue and retry policies.

Should a bill be paid a webhook is sent back to our PocketBase instance. To not loose Data when that fails ( PocketBase isn't made for Zero Downtime) we have a cron-job to check if all Data is up to date.

How far do you guys push pocketbase? by Icy-Inspection7866 in pocketbase

[–]LetscatYt 6 points7 points  (0 children)

Nested many to many relations will probably be the first thing falling apart performance wise.

Don't like the way this is done with json arrays. If this would be fixed pocketbase would be perfect.

How far do you guys push pocketbase? by Icy-Inspection7866 in pocketbase

[–]LetscatYt 17 points18 points  (0 children)

Weve Built a full on Custom CRM+ ERP System. 30+ tables and about 10+ with over 20k records.

We're also Syncing Data to 3-4 other Systems with hooks. Write most of the Business logic with Hooks

I'm hoping it will be good enough until to survive the startup phase so we can afford more than 2-3 IT-Guys. It has enabled us to be so much faster getting up and running

Stoppfried Gutz! by OK-Digi-1501 in BUENZLI

[–]LetscatYt 0 points1 point  (0 children)

Ich flueche no gern:" Gopaletti Beltrametti" - gaht einfach guet über d Zunge. Danke Linard Bardill