In latest blog post, I decided to revisit an old misconception I had about ENUMs in PostgreSQL.
Embrace simplicity and reliability with boringSQL. Share passion for things that just works - SQL and PostgreSQL.
boringSQL
@boringsql
- 15 Followers
- 2 Following
- 13 Posts
With summer in full swing it's time to take things easy - Gentle Introduction to Window Functions is for those stuck in SQL-92 times :)
https://notso.boringsql.com/posts/window-functions-introduction/
Almost no PostgreSQL cluster can run without job scheduler - let's find out when to pick pg_cron and when it's time to power up with pg_timetable
https://notso.boringsql.com/posts/time-keepers-pg-cron-pg-timetable/
Apologies for the mistake in the last part of the Time Off Manager tutorial. There's always this one thing that goes missing during the endless final checking of each article.
This time it was definition of the function `public.current_user_id`. Big thanks to billllll from HN
Now with the PostgREST deep dive completed, you can find it (and hopefully share it) as single guide
https://notso.boringsql.com/guides/postgrest-apis-made-easy/
Time for PostgREST - we are closing the series with the authentication and authorization.
It's PostgreSQL extension time! Rust + pgrx = surprisingly magical combo. ✨ All that with sample pg_sysload for smarter batch processing based on the system load
https://notso.boringsql.com/posts/custom-postgresql-extensions-with-rust/
Ready to level up your SQL and PostgREST skills? 🚀 In the second installment of my PostgREST guide, you'll create a near-real-world example of business logic while exploring the security differences between VIEWs and FUNCTIONs. 📊🔒 #SQL #PostgreSQL #APIs #boringSQL
With first part of the Deep Dive into PostgREST trying to open tutorials/guides to create more with just PostgreSQL + SQL
"It works on my DB" is the new "it works on my machine".