✅To avoid lock-stealing, lock release is handled through an atomic Lua script that verifies ownership before deletion ✅PGSQL pessimistic row locks act as a second layer of protection during booking confirmation. #Backend #SystemDesign #Redis #PostgreSQL #NestJS #BuildInPublic

Do not use Firebase. It is way overpriced. You should just use pgsql or sqlite (depending on usecase)

Every time you create a new Laravel application, the installer asks a series of questions: - Which starter kit would you like to use? - Which database are you using? SQLite, MySQL, or PostgreSQL? - Would you like to install Boost? - Would you like to use Pest? - Would you like to install and build NPM dependencies? - Would you like to initialize a Git repository? These questions are useful, but if you're creating Laravel projects regularly, answering them repeatedly becomes tedious. If your preferred setup includes: - SQLite - Pest - Boost - NPM dependencies installed and built - Git initialized You can skip all the prompts and create a new project with a single command: laravel new --database=sqlite --boost --npm --pest --silent --git my-project Prefer MySQL or PostgreSQL? Just replace sqlite with mysql or pgsql. You can make it even more convenient by creating an alias: alias laravelx="laravel new --database=sqlite --boost --npm --pest --silent --git" Then create a new project like this: laravelx my-project One command. No questions. Your project is ready. Small productivity improvements may not seem important individually, but they save a surprising amount of time when repeated every day. Keep this one handy. It can make your Laravel workflow a little smoother. #Laravel #PHP #WebDevelopment #Programming #DeveloperProductivity #SoftwareDevelopment

Yay set up postgresql 18 on supervisord user-mode in a container :) We need to unify all the databases. Hindsight runs with an embedded pgsql, now I needed firecrawl and that also wants postgres plus redis I love supervisord, it's the only process your container starts. 👌

ここしばらく格闘してたプログラムがようやっと完成した。AI支援受けてればもっとチャッチャと完成してたかもしれないが…PL/pgSQL相手でもいけるのかね

Kenapa harus mysql/pgsql/lain2nya, Kalo sqlite sudah cukup🫣 Banyak loh produk yg kubuat pake sqlite doang. User gak komplen karena mereka kan "yang penting jalan"

Yo solo cambiaría: - GitHub Actions por Dokploy si es infra propia - OCI -> Docker - Astro para frontend - Rust para workers - PGSQL como base de datos

Depois de um incidente semana passada, com dados de teste em ambiente local, eu passei a salvar na memoria do Claude restricao de: - prefira atualizar migrations existentes e aplicar a mudanca via pgsql ao inves de sempre criar novas migrations - antes de rodar migrations faca backup sempre Com essas duas regras, ele passou a sempre verificar certinho. Poderia usar seeds mas o processo de reset perde muito das coisas que nao ficam no seed. Dai, quando quero ver se ta tudo certo com as migrations rodo o db reset. Ate agora tudo correndo bem.

Pgsql bro

Jak nie potrzeba postgresa? Nie ma nic lepszego niż postgres aktualnie xD a w podstawowym użyciu nie różni się znacznie od MySQL, no a jeśli projekt się rozrośnie to łatwiej opanować. Jest jeszcze sqlite ale migracja więcej zajmuje niż postawienie projektu w pgsql

transaction safe Change data capture system for 4d.com database with replication to pgsql..

How’s your secret storage? Pgsql col? Too complicated?

Supply chain alert: Miasma worm targets Microsoft On June 5, 2026, a malicious commit in the Azure/durabletask repository triggered the shutdown of 73 GitHub repositories. Unlike earlier campaigns that required installing a compromised package, this attack executed its payload immediately when the repo was opened. Key risks: • Instant code execution via dev tools • Secrets exfil (AWS, Azure, GCP, GitHub) • CI/CD evasion targeting security controls • Destructive fallback commands Miasma mitigation: • Identify affected systems & kill any persistent processes • Hunt artifacts: /tmp/managed.pyz, pgsql-monitor.service, ~/.cache/.sys-update-check • Rotate ALL creds (AWS, Azure, GCP, GitHub, SSH, DBs, secrets) • Audit cloud activity unauthorized access • Check network logs for check.git-service.com & t.m-kosche.com • Inspect for lateral movement across pods/instances Find the full analysis here: Miasma worm targets Microsoft, compromises 73 GitHub repositories | ThreatLocker Blog

Strona używa Laravel, WildFly, baza pod spodem to PgSQL. Więc nie jest to prosta strona. Ma rozbudowany backend, generujacy dynamicznie frontend. Technologicznie jest to rozbudowana strona, chociaż warstwa prezentacji może wydawać się uboga.

Databases and Their Programming Languages • 🐘 PostgreSQL - C, PL/pgSQL, SQL • 🐬 MySQL - C, C , SQL • 🍃 MongoDB - C , JavaScript • ⚡ Redis - C, Lua • 🔍 Elasticsearch - Java • 🏛️ SQLite - C • 🪳 CockroachDB - Go • 🌊 Cassandra - Java • 🔥 Firebase - C , Java, TypeScript • 🐍 Neo4j - Java, Cypher

a stroll on planet pgsql helped me come across this, yet another amazing blog by @BonesMoses. pg19 is getting query hints, except they're called "plan advice". the implementation is better than any hint system i've seen elsewhere. it took so long because it was to make sure if they add hints, they don't suck. now, pg19 brings `pg_plan_advice`. it lets you nudge the postgres planner toward a specific scan or join strategy without overriding its judgment entirely. if you'd like to learn more, you should read shaun's blog on this.

Hey @dok2001, when are you guys adding a PgSQL or MySQL service to Cloudflare? It's time :)

You just add this to Hermes config and it starts gbrain automatically inside of Hermes so you don't need a separate service Now I just need to unify the pgsql database between Hindsight and GBrain, but optimizations some other time