Toot

Written by adamghill on 2025-01-20 at 18:09

One thing I'm still investigating: how to make #SQLite as similar to #PostgreSQL as possible via pragmas (https://www.sqlite.org/pragma.html).

I'm ok sacrificing some speed for referential integrity. I'm currently looking into:

PRAGMA strict = ON;

PRAGMA case_sensitive_like = ON;

PRAGMA recursive_triggers = ON;

PRAGMA automatic_index = ON;

PRAGMA encoding = 'UTF-8';

Anyone have experience with these? I'm thinking about modifying @anze3db benchmark in https://blog.pecar.me/django-sqlite-benchmark to see what the impacts are.

=> More informations about this toot | View the thread | More toots from adamghill@indieweb.social

Mentions

=> View anze3db@fosstodon.org profile

Tags

=> View sqlite tag | View postgresql tag