News for hackers. Stuff that matters.

A comment on Cold Showers: For when people get too hyped up about things. Parent comment

Re:Cold Showers: For when people get too hyped up about things by neurostimulant on Friday July 24, 2020 @07:36PM (#23945571)
How do you handle access from multiple worker processes? Some languages/frameworks handle have poor multi-threading performance and must be deployed in a multi-process setup (e.g. python webapps). Or is it not a good fit for sqlite?
[ Parent | on HN ]
Re:Cold Showers: For when people get too hyped up about things by bob1029 on Friday July 24, 2020 @08:18PM (#23945813)
Multiprocess can work, but you may want to develop an intermediary process that is exclusive owner of the database for performance reasons and then delegate to it. I.e. you could have:

database.db <=> SQLiteAgent <=> localhost HTTP JSON <=> MyPythonWebApps

This exercise would also encourage development of a concise and generic schema for storing your business data (presumably because changes to the above JSON contract would be time consuming).

[ Parent | on HN ]