#OpenBSD developer, #database engineering, #distributed systems, information #security.
Joined Jan 2018
mulander
boosted
Hot off the press—just in time for #PGConfEU, a new #PathToCitusCon podcast 🎙️ for developers who love #PostgreSQL with a-ma-zing guests @lukas & Rob Treat!
Good weekend listening 🎧 about: My Journey into Postgres Monitoring 📈
Hosting this podcast w/ Pino de Candia is one of the most fun parts of my #PostgreSQL community work & I hope y'all love it. ❤️
You can listen & subscribe on all the podcast platforms! Boosts appreciated 🙌
mulander
boosted
My boss wrote a blog post that just dropped announcing 11 new features in Azure Database for PostgreSQL - Flexible Server that are in GA & Public Preview including:
✅ #PostgreSQL 16 support (GA)
✅ Premium SSD v2 (Preview)
✅ New azure_ai extension (Preview)
For those of you who care about #PostgreSQL on Azure, details & links in Charles Feddersen's blog
mulander
boosted
PostgreSQL 16 support has been added to Citus 12.1!
This blog post by Citus database engineer Naisila Puka walks through everything that's new in the 12.1 open source release of Citus. (There are some schema-based sharding improvements too...)
Good weekend reading. Big welcome to Citus 12.1. 👋 👋
#Citus #opensource #PostgreSQL #Postgres #database
https://www.citusdata.com/blog/2023/09/22/adding-postgres-16-support-to-citus-12-1/
mulander
boosted
Carol Smith: Episode 6 highlights of Path To Citus Con podcast w/Chelsea Dole & Floor Drees https://www.citusdata.com/blog/2023/08/11/ep06-highlights-of-path-to-citus-con-podcast/
#postgres #postgresql
mulander
boosted
Hot off the press is Episode 6 of the #PathToCitusCon podcast for developers who love Postgres.
Live recording happened on Discord earlier this week & now it's available in all the podcast places 🎙️ so you can listen while you walk the dog or do dishes or _whatever_.
Thanks 🙌 to @floord & Chelsea Dole for joining Pino & me for the convo on "You're probably already using Postgres: What you need to know"
And +1 to Carol Smith & @asw for producing! #PostgreSQL #podcast https://pathtocituscon.transistor.fm/episodes/youre-probably-already-using-postgres-what-you-need-to-know-with-chelsea-dole-floor-drees
mulander
boosted
Do you like podcasts? Are you a developer? Do you love #PostgreSQL?
I'm co-hosting a new #podcast for developers who love Postgres
This Wed Aug 9 @ 10:00am PDT you can join the live recording of #PathToCitusCon Ep06 w/guests Chelsea Dole & @floord
Topic = You're probably already using Postgres: What you need to know
Boost please & tell friends
Mark your calendar (invite says how to join) https://aka.ms/PathToCitusCon-Ep06-cal
Or listen to past episodes anytime anywhere https://aka.ms/PathToCitusCon-transistor
The 12.0 open-source release of the Citus database extension to #PostgreSQL is out!
Marco Slot in his post introduces schema-based sharding, goes into detail of sharding model tradeoffs, & even covers the extended PG MERGE support in this release:
https://www.citusdata.com/blog/2023/07/18/citus-12-schema-based-sharding-for-postgres/
Personally, I see this release as a major milestone for Citus. The list of changes may not be long, but actually introducing a whole new sharding model enables new types of workloads that were either very hard or near impossible to achieve with Citus.
While row-based sharding is still the most efficient both in terms of hardware margins (densely packing tenants on nodes) and performance - it did require a lot of up-front work to adapt schemas and apps to this model.
What types of apps had it hard?
One obvious app is actually regular multi-tenancy. The customer is always right, and sometimes your customers don't want to upgrade on the same pace as everyone else. There are also cases when some of them require individual schema changes.
With row based-sharding you share the schema, so individual touches like that are hard or impossible.
The second type of apps are #microservices, by definition they want to own the storage and handling storage in them is one of the main problems: https://stackoverflow.blog/2020/11/23/the-macro-problem-with-microservices/
Citus solves that now, with schema based sharding it's very easy to implement microservices: https://docs.citusdata.com/en/v12.0/get_started/tutorial_microservices.html
This allows easy horizontal scaling of storage, while giving these apps the autonomy they desire.
Best part however is: you can do both. Deploy with schema-based sharding and migrate parts of your app (or whale tenants) to the row-based sharding model.
All of this was developed 100% in the open. If you starred our GitHub repo, you saw it made live: https://github.com/citusdata/citus
mulander
boosted
So it turns out that co-hosting the #PathToCitusCon podcast for developers who love Postgres is one of the most FUN parts of my job!
This blog post from Carol Smith is hot off the press & has all the links for listening to past episodes, subscribing, and how to participate in the live recordings on Discord (where we have a lively text chat!)
Give it a listen & let me know what you think!
#podcast #PathToCitusCon #PostgreSQL #databases #microsoft #OpenSource #community
https://www.citusdata.com/blog/2023/07/14/say-hello-to-path-to-citus-con-podcast/
mulander
boosted
The topic for this month's podcast for developers who love Postgres (aka "Path To Citus Con") is:
> My favorite ways to learn more about Postgres
When?
> Live podcast recording will happen on Discord on Wed 12 July @ 10am PDT
Guests = @ryanbooz & Grant Fritchey
Hosts = myself & Pino de Candia
Join us! And please boost so more people discover it! Calendar invite w/details on how to join https://aka.ms/PathToCitusCon-Ep05-cal
#PostgreSQL #Postgres #podcast #discord #databases #SQL #microsoft #OpenSource
mulander
boosted
Hot off the press this blog post about a new performance benchmark of 3 distributed PostgreSQL implementations, including Azure Cosmos DB for Postgres, with Citus distributed tables
The benchmarking software used was HammerDB. Report by GigaOM.
Thanks @marcoslot for sharing the results in this blog post! https://devblogs.microsoft.com/cosmosdb/distributed-postgresql-benchmarks-using-hammerdb-by-gigaom/
#PostgreSQL #Postgres #opensource #database #performance #HammerDB #Azure #AzureCosmosDB #Microsoft
mulander
boosted
Happening Wed June 7th @ 10:00am PDT is Episode 04 of "Path To Citus Con", the monthly podcast on PostgreSQL, Citus, databases, & developers—from the Postgres team at Microsoft.
Guests today = Melanie Plageman & @tmunro along w/co-hosts Pino de Candia and me!
Topic: How I got started as a developer (& in Postgres)
If you listen live, you can participate in the live chat.
Plz boost! This calendar link has instructions on how to join the Discord: https://aka.ms/PathToCitusCon-Ep04-cal
mulander
boosted
Bruce Momjian of EDB is a prolific PostgreSQL presenter 🔥 and the organizers of Citus Con: An Event for Postgres were thrilled he gave a talk at Citus Con.
So today's Citus Con video of the day is from Bruce! If you are looking for a solid primer on Postgres & the Artificial Intelligence landscape, Bruce's #CitusCon talk 📺🎙️ is the place to start.
https://aka.ms/cituscon-brucem-2023
#PostgreSQL #Postgres #CitusCon #databases #artificialintelligence
mulander
boosted
It's the last day of May and today's #CitusCon video of the day is by @cyberdemn of Microsoft, who is the lead of the Patroni project for PostgreSQL...
If you want to learn about the key to scalable (horizontally scalable) & fault-tolerant PostgreSQL, watch this talk (and demo) about Citus and Patroni.
https://aka.ms/cituscon-alexanderk-2023
#PostgreSQL #Citus #databases #Patroni #Microsoft #OpenSource #HighAvailability
mulander
boosted
Today's #CitusCon video of the day is 📽️ by Hettie Dombrovskaya, it's all about temporal features in PostgreSQL. 🐘
Henrietta does a great job explaining the SQL standard for time, how temporal data concepts are (currently) implemented in PostgreSQL, & what is still missing.
mulander
boosted
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
mulander
boosted
I've been thinking about creating a Citus Open Source account here on Mastodon, or a Citus Con account to share all the great #PostgreSQL & #Citus talks, for people who care about such things.
In the meantime, I've just gotta share this new blog post on the Citus Blog, about what's new in the 3.2 version of the 'django-multitenant' library for building multi-tenant SaaS apps on Postgres & Citus.
mulander
boosted
As co-chair, I'm excited about this 💥 all the individual livestream talks from Citus Con: An Event for Postgres 2023 have published on YouTube 📺
Including some phenomenal talks 💡 by @simon & @cyberdemn & @tmunro - and others not yet on Mastodon
Enjoy the playlist of 37 talks & pls tell your friends
https://aka.ms/cituscon-playlist
#CitusCon #PostgreSQL #Citus #SmallData #OpenSource #Patroni #YouTube #DistributedPostgreSQL #HammerDB
mulander
boosted
Happy #CitusCon day.
If you're a #PostgreSQL person & in an EMEA-friendly timezone, we hope you join us for the 3.5 hour EMEA livestream 📺 which starts at 9:00am CEST on Wed 19 Apr.
Plus official backchannel on Discord!
You can watch livestream & get all the info at https://aka.ms/cituscon (be sure to reload page when it starts!)
This 54 sec video tells you WHY you might care. Isaac Alves & I made it with love. ❤️ Please Boost! 💥
mulander
boosted
Yikes, I am in the home straight before Citus Con: An Event for Postgres 2023, our 2nd annual virtual event happening:
- Tue Apr 18 @ 9am PDT
- Wed Apr 19 @ 9am CEST
Who do I know on Twitch who has #PostgreSQL followers & would be willing to "raid" the Twitch livestream from #Microsoft Developer for the 2 #CitusCon livestreams? Boosts welcome!
@nova would you—or do you know anybody whose Twitch ppl care about #postgres
mulander
boosted
There are 37 amazing talks @ the Apr 18-19 free & virtual Citus Con: An Event for Postgres 2023.
Please boost 💥 to spread the word to your friends who use #PostgreSQL 🐘 so they add this to their calendars & join the livestreams + virtual hallway track on Discord? 👀
Each of 2 livestreams has 6 talks + there are 25 on-demand talks that will publish at start of #CitusCon
@simon & @marcoslot = keynoters!
Schedule details: https://aka.ms/cituscon
#Citus #OpenSource #Azure #Microsoft
#OpenBSD developer, #database engineering, #distributed systems, information #security.
Joined Jan 2018
