|
|
|
|
|
by andrewstuart
677 days ago
|
|
Seriously folks - just write straight up SQL. Your database is incredibly powerful and the best way to program it is with SQL. There's a vast array of features and capabilities that can best be made use of by ........ writing SQL. ChatGPT is incredibly good at writing SQL so its super easy. AND, BONUS ...... you get to carry accumulated knowledge forward because you are actually learning SQL instead of yet another abstraction. Write stored procedures - they are awesome, write SQL that returns JSON, use all those weird and wonderful database features like JSON querying storage, indexing and returns, like full text search, write CTE's, write event triggers, write Row Based Access Control, make message queues with SKIP LOCKED. Write Foreign Data Wrappers, make partial indexes and window functions. Stop being scared of SQL, stop needing to hide behind someone's database abstraction and learn the joy of SQL. Let the database do the work. |
|