Do all the things like ++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatarSign Up
From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple APILearn More
Best free softwares don't work for greater good.
They work for politics and benefits.
And even if you pay, it might not help. The world is full of scammers.5
Netflix and YouTube Music, and whatever paid, are missing an important part of the fun.
I basically hate anything that IDEs aren't smart to fix typos.
- SQL, mostly.4
ORM feels like, I can do better than that, with more predictability (like naming, table creation, and stuff).
The only pro, is hopes for inter-dialects interop (SQLite-Postgres-MySQL-MariaDB).
OK, I also want SQLite-MongoDB interop, because of the cheap price; but this is difficult.
When I normalize a database, it always feels like I cannot predict Cascading, leaving broken relationships and trash queries.2
I thought I had to VARCHAR in non-SQLite RDBMS. I was wrong. There is TEXT.
1. PostGres seems to work better with TEXT.
2. There is an ORM that forces VARCHAR (255) by default.
3. But you can go over the limit without throwing errors.1
Embedded database is so lack of choice. SQLite, might be best, if you want stability / ACIDity.
Again, SQL means normalize everything, if I've ever want to index it...
Then, ON DELETE CASCADE? TRIGGER? Also, MANY-to-MANY kills.6