14 ms·
Missing sqlite comparison point: data types. SQLite is like JS with column datatypes, except even looser. The claim about Datomic only working with JVM languag
by fulafel 2y ago
Missing sqlite comparison point: data types. SQLite is like JS with column datatypes, except even looser.
The claim about Datomic only working with JVM languages isn't right, it has a rest api there are eg python and js client libs using that.
- masklinn 2y ago> Missing sqlite comparison point: data types. SQLite is like JS with column datatypes, except even looser. Also defaults: - sqlite has STRICT tables, you have to opt in, per table. - sqlite does not check foreign keys by default, you have to opt in, per connection. - sqlite has WAL mode, you have to opt in, per database. And even with that you may want / need to add a fair amount of work to ensure you're not upgrading connections lazily (fecking SQLITE_BUSY).
- TacticalCoder 2y ago> The claim about Datomic only working with JVM languages isn't right ... TFA is also implying that it's either Datomic or Postgres but you can use Datomic on top of Postgres.