Huly – Open-Source All-in-One Project Management Platform

Re:Huly – Open-Source All-in-One Project Management Platform by moooo99 on Monday October 14, 2024 @06:03AM (#41835978)

SQLite is actually substantially more capable than many people think it is. I have served 20k MAUs from a reasonably sized single node server with some headroom to spare. Yes, it requires some thinking about efficiency and not necessarily going with nodejs + some ORM, but you can take SQLite quite far, even in a small to medium enterprise

[ Parent | on HN ]

Re:Huly – Open-Source All-in-One Project Management Platform by creshal on Monday October 14, 2024 @06:34AM (#41836166)

SQLite works well with 2k DAUs on a single node, even with Django's not particularly efficient ORM. You just have to be careful about what you really need to write to DB and what's okay to either not save at all, or just throw into a log file for later offline analysis.

[ Parent | on HN ]

Re:Huly – Open-Source All-in-One Project Management Platform by imglorp on Monday October 14, 2024 @06:46AM (#41836259)

I don't see how these guys can think about MAU/DAU to assess DB load and sizing without talking about the rest of the app/arch details. Wouldn't ops/time be more agnostic?

[ Parent | on HN ]

Re:Huly – Open-Source All-in-One Project Management Platform by alluro2 on Monday October 14, 2024 @07:51AM (#41836644)

Agreed, number of active users cannot make sense as a generic unit across systems...

I have 2 systems where in the first (route optimization platform), 1 user would, as part of just a normal 10 minute session:

- read ~100MB from the database - utilize 100% of 32-core machine CPU (and 64GB of RAM) - resulting in thousands of writes to the database - and side-effect processing (analytics, webhooks etc)

Over a course of a day, it would likely be ~10x for that single user.

In the other system - appointment scheduling - 1 user would, in 1 day, read ~1MB of data from the database, and make 2-3 writes from a single action, with maybe 1 email triggered.

[ Parent | on HN ]

Re:Huly – Open-Source All-in-One Project Management Platform by cutemonster on Monday October 14, 2024 @04:44PM (#41841782)

Can make sense if it's about loading and showing not-too-complicated data, but no intensive computations. Then you can compare roughly similar applications

[ Parent | on HN ]

Re:Huly – Open-Source All-in-One Project Management Platform by cutemonster on Monday October 14, 2024 @04:42PM (#41841753)

Maybe they mean cases somewhat similar to the software this discussion is about.

I.e. load and show stuff from databases (but nothing compute intensive).

[ Parent | on HN ]

Re:Huly – Open-Source All-in-One Project Management Platform by nine_k on Monday October 14, 2024 @06:41AM (#41836225)

SQLite has excellent read performance.

Insert / update performance is quite another story: https://stackoverflow.com/a/48480012 Even in WAL mode, one should remember to use BEGIN CONCURRENT and be ready to handle rollbacks and retries.

[ Parent | on HN ]