alcinnz
alcinnz boosted
mort
@mort@floss.social  ·  activity timestamp last month

Database collates are ridiculous. Why would I want to globally configure a database's ordering rules? Either I care about presenting locale-appropriate orderings, in which case I need that to be configured PER APPLICATION USER, or I don't care, in which care just use whatever makes the most sense for performance/simplicity (probably ordering by byte value). I don't understand the use case for database-global collate settings. #postgresql #postgres#mysql #databases #rdbms #programming
mort
@mort@floss.social  ·  activity timestamp last month

Database collates are ridiculous. Why would I want to globally configure a database's ordering rules? Either I care about presenting locale-appropriate orderings, in which case I need that to be configured PER APPLICATION USER, or I don't care, in which care just use whatever makes the most sense for performance/simplicity (probably ordering by byte value). I don't understand the use case for database-global collate settings. #postgresql #postgres#mysql #databases #rdbms #programming
{:ok, "Joel Jucá"}
@joel@functional.cafe  ·  activity timestamp 2 months ago

I've used #MySQL before (last time was 2016, I think), but today I'm mostly onto #Postgres (and sometimes, #SQLite). I know PG is superior to MySQL is pretty much all aspect I could think of, but still, it seems that MySQL still has a quite big user base.

What's the catch? What am I missing here? Why would someone use MySQL over Postgres to build smt since Postgres [apparently] is better than MySQL in every single possible aspect?

It's a honest question. Please help me understand it – and perhaps, consider modern MySQL/MariaDB in next projects. :)
Yogthos
@yogthos@social.marxist.network  ·  activity timestamp 2 months ago

Install and run a PostgreSQL database locally on Linux, MacOS or Windows. PostgreSQL can be bundled with your application, or downloaded on demand.

This library provides an embedded-like experience for PostgreSQL similar to what you would have with SQLite.

https://github.com/theseus-rs/postgresql-embedded

#technology #programming #postgres
Fränz Friederes
@friends@chaos.social replied  ·  activity timestamp 2 months ago

This setup delivers the best of both worlds:
- Fast joins and cache-friendly indexes
- Opaque, secure public IDs with great DX

No need to compromise.

#BuildInPublic#Postgres
Andrija Petrovic
@andrija@floss.social  ·  activity timestamp 3 months ago

Today it crossed my mind for the first time that, after all, I don't need #typescript at all.
Some months ago, after some months spent with #rust I got to a compromise idea that I should use #rust for "serious" tasks, and #javascript for quick modelling. The idea evolved quickly into it's same form, but with #typescript in place of JS.
Two months later I'm failing to get #deno run my software because the network layer won't work if I import some .ts file of mine; if only I knew which one.
Andrija Petrovic
@andrija@floss.social replied  ·  activity timestamp 3 months ago

in the meantime I got much braver with #rust, I love the syntax, the tightness, it's got a great native #postgres driver https://github.com/sfackler/rust-postgres (can pipeline requests, while I found 0/zero/ ts drivers capable of doing the same so I had to revert to good ol' JS https://github.com/brianc/node-postgres...)
So, tomorrow is a new day, we'll see...