News for hackers. Stuff that matters.

A comment on Why SQLite is so great for the edge. Parent comment

Re:Why SQLite is so great for the edge by charcircuit on Tuesday June 06, 2023 @05:19AM (#36210192)
It should be trivial to set it up on a ramdisk and I see some guides on doing so when I search for "postgres ramdisk"
[ Parent | on HN ]
Re:Why SQLite is so great for the edge by mschuster91 on Tuesday June 06, 2023 @05:27AM (#36210240)
PHP SQLite in-memory effort is `$db = new PDO('sqlite::memory');`. With postgreSQL, you'll at least have to:

1. create the ramdisk

2. mount the ramdisk, configure systemd to automount it

3. modify the systemd unit file for psql to depend on the ramdisk

4. initialize all the psql data structures in the ramdisk mount folder

[ Parent | on HN ]