TheSteve0, 1 year ago to rust

Fun for all the cRUSTaceans - you can now write embedded code in #PostgreSQL with PL/Rust. AND it's a trusted language!

#rustlang #rust #postgres #NowThatIsCool

https://github.com/tcdi/plrust

hunleyd, 1 year ago to random

Next steps for #Postgres pluggable storage https://supabase.com/blog/postgres-pluggable-strorage

hunleyd, 1 year ago to random

Thinking Fast vs. Slow with Your Data in #Postgres https://www.crunchydata.com/blog/thinking-fast-vs-slow-with-your-data-in-postgres

hynek, 1 year ago to fediverse

The number of times I’ve clicked the icon of a #Postgres client when I meant a #Mastodon client is not zero and keeps growing.

hunleyd, 1 year ago to random

#Postgres FM | auto_explain https://share.transistor.fm/s/c3ccbf26 #podcast

paulox, 1 year ago to random

Laurent Tramoy is holding the workshop "Mastering the Django ORM with PostgreSQL" at DjangoCon Europe 2023 in Edinburgh 🦄🏴󠁧󠁢󠁳󠁣󠁴󠁿🇪🇺

#DjangoCon #DjangoConEU #DjangoConEurope #Django #ORM #Postgres #PostgreSQL

CC @djangoconeurope

https://pretalx.com/djangocon-europe-2023/talk/DK3XET/

paulox, 1 year ago to random

Karen Jex is presenting the talk "Tuning PostgreSQL to work even better" at the DjangoCon Europe 2023 in Edinburgh 🏴󠁧󠁢󠁳󠁣󠁴󠁿🦄🚀

#DjangoConEuroppe #DjangoCon #Django #Postgres #PostgreSQL

CC @djangoconeurope

https://pretalx.com/djangocon-europe-2023/talk/BT7XGG/

vansari, 1 year ago to php German

Today I tried to setup a PHP ecosystem on my MacBook Pro M2 with Podman. It was a little bit difficult but I have done it ☺️

Now I have a isolated pod where my #php fpm #nginx and #postgres are running. The only published port is 8080 for the nginx.

But the best benefit is: Each container runs rootless ! #podman #devops

Here is the link to the #github repository:

https://github.com/vansari/podman-knowledge

hunleyd, 1 year ago to random

How #Postgres Triggers Can Simplify Your Backend Development https://themythicalengineer.com/how-postgres-triggers-can-simplify-your-backend-development.html

hunleyd, 1 year ago to random

Structured #Postgres Regression Tests - Yurii Rashkovskii https://yrashk.com/blog/2023/04/23/structured-postgres-regression-tests/

AAronL1968, 1 year ago to programming

Looking for a new gig, laid off from Disney after 25 years. My areas of expertise include #java and #postgres, as well as the Microsoft stack (#SQLServer). I have vast domain knowledge in the field of movie distribution. #OpenToWork #HireDisney

hunleyd, 1 year ago to random

Postgres FM | Queues in #Postgres https://share.transistor.fm/s/e86cbb49 #podcast

hunleyd, 1 year ago to random

#Postgres - Fun with LWLocks https://paquier.xyz/postgresql-2/2023-04-20-fun-with-lwlocks/

hunleyd, 1 year ago to random

#Postgres 16 highlight: Logical decoding on standby https://bdrouvot.github.io/2023/04/19/postgres-16-highlight-logical-decoding-on-standby/

hunleyd, 1 year ago to random

Writing Data from #Postgres to #MongoDB https://www.crunchydata.com/blog/writing-data-from-postgres-to-mongodb

clairegiordano, 1 year ago to opensource

Today's #CitusCon video of the day 📺 was presented by Postgres committer @tmunro who I am privileged to work with at Microsoft.

It's all about Parallelism in PostgreSQL. With a lovely sock analogy to boot. Thomas is such a good explainer & teacher, hope y'all enjoy it.

https://aka.ms/cituscon-thomasm-2023

#PostgreSQL #Postgres #databases #database #conference #OpenSource #Microsoft

hunleyd, 1 year ago to random

#Postgres FM | Read-only considerations https://share.transistor.fm/s/3b242ada #podcast

hunleyd, 1 year ago to random

#Postgres 16 highlight - require_auth for libpq https://paquier.xyz/postgresql-2/2023-04-13-postgres-16-require-auth/

scy, 1 year ago (edited 1 year ago) to random

So @element took part in the European Police Congress in Berlin, had a booth and presentation there, and is proudly posting on the fedi about it.

https://mastodon.matrix.org/@element/110304013472307767
https://mastodon.matrix.org/@element/110310853505977058

I’m currently paying them $11.90 a month to host my homeserver on their EMS platform.

My payment in April will have been the last.

It’s one thing to provide FLOSS comms to the government. It’s another to proudly support our fucked up police system.

hunleyd, 1 year ago to random

#Postgres FM | Partitioning https://share.transistor.fm/s/f7bf1092 #podcast

paulox, 1 year ago to linux

I just published a short guide explaining how to upgrade PostgreSQL 🐘 from version 14 to 15 on Ubuntu 23.04 (Lunar Lobster) 🦞 after upgrading it from version 22.10 (Kinetic Kudu) 🐐

#Ubuntu #LunarLobster #PostgreSQL #Postgres #HowTo #Upgrade

Read it 👇
https://www.paulox.net/2023/04/27/upgrading-postgresql-from-version-14-to-15-on-ubuntu-23-04-lunar-lobster/

rustprooflabs, 1 year ago to random

Such an innocent looking query... I didn't expect it to do this!

One table has 500 rows, the other has 381k. Table stats are accurate. The planner still decides it will return 39M rows, roughly 20% of what a cartesian join. The screenshot is from pgMustard, plan here: https://app.pgmustard.com/#/explore/486276b3-d9e5-4bc8-a1eb-a3a23cd1caf4?highlighted=0

SELECT *
FROM store_potential_customers p
INNER JOIN osm.road_line r
ON r.route_motor
WHERE p.geom <-> r.geom < 100
;

@michristofides
#postgis #postgresql #postgres #performance

hunleyd, 1 year ago to random

SQL Maxis: Why We Ditched RabbitMQ And Replaced It With A #Postgres Queue https://www.prequel.co/blog/sql-maxis-why-we-ditched-rabbitmq-and-replaced-it-with-a-postgres-queue

hunleyd, 1 year ago to random

Highly Available #Postgres Clusters in #Kubernetes, Tue, Apr 25, 2023, 6:00 PM | Meetup https://www.meetup.com/postgrescmh/events/bjbmcmyfcgbhc/

masukomi, 1 year ago to random

#FerretDB 1.0 has been announced
Ferret is a proxy that sits between your #mongodb drivers & a #postgres db converting mongo queries into postgres SQL and using PG for the persistence.

https://www.ferretdb.io/

I am finding myself at a complete loss as to any practical reason why someone would want to use this. The ONLY case i can make for it is that it satisfies people who are zealous about open source licenses and aren't happy with Mongo's.

What am i missing?