thenooby

It's impressive and interesting, I guess in terms of performance, it's quite big, 80 qps feels quite huge!!

For such thing of mine, it's more than enough I guess.

Would it be a bad idea to use multiple sqlite files, isolating things per domains? Feels like something possible and interesting?

Thank you very much for your reply.

You're right, I should just start anyway. Waiting is stupid, I could've done a lot more instead of questionning myself, and eventually it will not matter much as you said.

But also, I'm kind of scared to shoot myself in the foot later in the run, if it happens to work, but if it works, I'll change it anyway!

I'll do "eeny, meeny, miny, moe" (I've looked up, its the equivalent of am stram gram in France?) and see what I use :')

Thank you very much for your reply.

Do you use things like Turso too ? How much do you handle with your personal stuff ? Was it hard to manage at first ? Is there any footgun to dodge there ?

SQLite seems awesome and also .. not enough for the long run ? But I don't know much TBH.

Ok so, what you meant by ARM is that MongoDB was not easy to use on ARM architecture machines.

In regard of benchmarks, few months ago, I've seen some benchmarks where Postgres obliterated MySQL, both for read and writes (basic ones), in terms of performances, with Node.js drivers tho' (probably matters too), I did not though that Mongo would be "faster", as it seems from your point of view. Tho' I assume that for a project of my size (tiny), any of the big general purpose database would be largely sufficient, in terms of benchmarks and just a big machines would be good.

Looking at Postgres doc, which is quite nice btw (I did not remember that), I think there is much more features that I can dream of. (More than MySQL!!) The pain point I used to have, trying it, was the "administration" stuff, I'll read more in the doc, probably it was just me that was a noob with it (skill issue), also I did not used docker too.

At the moment, I tried both Cloud things, such a Google cloud, and VPSs, I largely enjoyed more using VPS. Thought I've found Google clound run quite powerful and easy to use.

Speaking about what you said in your previous comments about transforming data beforehand; I've done a PoC for myself about a year ago of that project, where I made multiple scripts (background jobs) which would gather data from each sources, and I tried to normalize everything to my schemas and all the common points of them. It was annoying to update them over the courses of multiple days, because I did not thought everything well from the get go, which is one of the reason I consider documents (I used to put a JSON column where I put any data I did not thought beforehand), but it's eventually a skill issue from me, and now thinking about that, I guess I could just look at the most important sources (more than 10 sources generating data daily, with 2 really big and important ones) and take time to think my schemas properly. In that regards, do you put the raw data somewhere ? (Would you keep it even?) If yes, in the DB or in text form within a S3 like storage ?

Thank you very much for your reply.

So far, I've seen so much people recommending Postgres, I guess it's the right answer for me.

Do you use it yourself on your own VPSs/Servers or into a managed platform ?

Is it hard to upgrade Postgres version to version ? From the MongoDB point of view, was it hard to get into Postgres ? (I guess, because I already know SQL, not extensively, it will be easy to get into it) What are your favorites features ?

No issues while using it is a big deal!! (I'll look into "ARM problems", don't know what it means)

Update: Found a job for the moment that eventually would help me to find something to locate to!!

Reporting my transition to a year, stabilizing my familly and then let's go baby.

Thank you for your response!

I've applied to few help desk jobs today, seems like you don't need big diploma or such, could be a good thing too

I'll look into those and try to apply, maybe I'll have a bit of luck there

Not sure how to take it.

Anyway, I feel shit but I fucking want to go there, I love it, I've probably made wrong choices and Its ok. I'll need a bit more of time I guess, but I'll get there, I'll not give up my dream.

Thank you for you response!

Thank you very much! Yeah I don't have the choice, I'm dumb to have waited that much, I should have got a job earlier but yeah I need to!!

Finding a software job is difficult, I understand that there is ton of applicant, that the overall level is low and that my profile is not easy but I was so close with three interviews .. and nope. haha

Thank you very much.