Excited to be attending my first #PostgreSQL conference #PGDayUK. First nugget of info: PG16 will be released on Thursday 2023-09-14!

@tuckerteague at the base level of just-learning-SQL, PostgreSQL will do the same basic SQL CREATE-SELECT-UPDATE-DELETE stuff as any other DB in mostly the same ways, honestly. So if that's your only goal, PG is as-good as anything else, and you might as well keep going there if you've already started; or switch, whichever.

But as you dig deeper, PG has more underlying depth and consistency under the surface than other systems. Its type system is both more rigid and extensible than MySQL's, for example. There is support for various languages for server-side procedures, it has a complete ecosystem for building custom extensions, and so on.

In short, in PG, you can peel away the layers and find surprisingly strong and consistent reasoning underneath, instead of a nightmare of patched-over bad decisions, which you might find elsewhere.

Note: I am an avowed PostgreSQL fanboy, so, take any grains of salt you'd like.

#SQL #PostgreSQL

Is it just me or did the #PostgreSQL online docs change their formatting? Like, https://www.postgresql.org/docs/current/functions-datetime.html ; I swear that Table 9.32 used to be... well... a table. Now it's a pile of vertical cells with indents for the "Description" and "Example(s)" parts.

That seems bad, if for no other reason than it makes it less accessible, I think (th values can be tied semantically to each column afaik), and I'm trying to figure out if it was on purpose or just a bug. Or, maybe if I somehow slid across to an alternate universe where that always looked that way and/or I'm just a nutcase?

I'd be grateful if anyone would consider this question of mine

#postgresql

https://dba.stackexchange.com/questions/330811/creating-several-records-from-one-based-on-a-numerical-value-stored-in-a-field

Some techniques they used to free unused Index space in #PostgreSQL

https://hakibenita.com/postgresql-unused-index-size

Does anyone know whether the current PostGIS extension 3.3.4 for PostgreSQL still uses the hdf5 package? I’m on openSUSE Leap 15.4, compiling from source.

I ask because I can compile it from source without a) hdf5 being installed (anymore) and b) not compiling/installing hdf5 myself.

So what, if anything at all, is hdf5 being used for PostGIS? I can’t find it in the prerequisites anymore either. Can anyone help me out here, please? Do I still need it or not?

#openSUSE #PostGIS #PostgreSQL

Spent more time than expected to optimize COUNT queries in #PostgreSQL in the last two weeks.
This was very surprising to me as I mostly work with #MySQL and #MariaDB.
But I achieved a speed-up of 150-550% in parts of my customers #NeosCMS application with small adjustments and not using the ORM.
Happy but somehow also disappointed that this is necessary.

Here is one blog post I found that explains some of the reasons and solutions:
https://www.cybertec-postgresql.com/en/postgresql-count-made-fast/

Working with an SME to get #PostgreSQL geometries as Views published to a Service.

Some geometries have no records (yet) - so I created some dummy polygons so they could be symbolised, etc

In the JIRA ticket, she called these "placebo polygons"!!

#GIS #spatial #mapping #gischat #clever

We wrote a guide on configuring, deploying, and running #FerretDB on #Leafcloud using the power of #Kubernetes & #PostgreSQL Operator.

Comprehensive but worthy read --> https://blog.ferretdb.io/deploy-run-ferretdb-leafcloud/

My personal favourite of the designs for #PostgreSQL 16

https://99designs.co.uk/illustrations/contests/postgresql-v-release-artwork-1239210/entries/110

If you are stuck dealing with #CrunchyData or #Bitnami for modern #postgresql in #k8s, let me turn you on to cloudnative-pg.io

TL;DR: An operator and CRDs for managing #psql on #k8s that actually fulfills the promise of the operator pattern. It just, you know, *operates* the stupid thing for you. And its multi-arch.

Amusingly, I found out about it because Crunchydata insists that ARM is super hard and reserved for enterprise customers only. (They've since made contrite noises about walking that back, but no actual movement yet.)

I've been running it for about 15 minutes and so far I am blown away. And weirdly it does not appear to have tried to spy on me! That oversight aside, it comes with full #prometheus support, base alarms, and a VERY nice #grafana dashboard. Handles clustering, failover, scaling, upgrades, all the things.

#postgresql #cloudnative #kubernetes #arm64 #homelab #turingpi

The @LabPlot Team has just published a new video on:

How to import data from SQL databases in LabPlot.

Watch it, like it, share it and subscribe to the LabPlot's channel and comment.

https://www.youtube.com/watch?v=nntP1okY0zg

#Databases, #SQL, #SQLite, #MySQL, #MariaDB, #PostgreSQL, #LabPlot, #DataAnalysis #Statistics #Data

I'm just reminded that I gave a tech talk on PostgreSQL at COSCUP 2015 in Taipei, Taiwan.

And I just found a mastodon instance "g0v.social" where lots of Taiwanese tech guys have joined.

I hope I will be able to bridge tech communities between Taiwan and Japan in the future.

#taiwan #coscup #g0v #postgresql

PostgreSQL 9.4, 9.5 and Beyond @ COSCUP 2015 Taipei
https://www.slideshare.net/snaga/postgresql-94-95-and-beyond-coscup-2015-taipei

TIL: #PostgreSQL's built-in data type #interval preserves months, days, and microseconds as separate fields under the hood.

https://www.postgresql.org/docs/15/datatype-datetime.html#DATATYPE-INTERVAL-INPUT-EXAMPLES

Is #CouchDB still lovable? Going through the docs right now. Seems more fun than using a corporate (and proprietary) Document DB like #MongoDB, #DynamoDB or #Firebase. Also looks more fun than using the weird JSON syntax of #PostgreSQL.

Additionally, the #PostgreSQL community has integrated an s390x builder into their #Jenkins instance and is publishing #IBMZ binaries in their apt repository for #Debian & #Ubuntu 🥳 https://wiki.postgresql.org/wiki/Apt

Is anybody else experiencing Locks in FollowRecommendationsScheduler and similar in case a backup is running at the same time?
It seems (found some evidence on the net, but no solutions) that REFRESH MATERIALIZED VIEW and pg_dump running in parallel come to a situation to lock each other. I experienced this a number of times now and the monitoring is nagging once again - both processes running since some 85 minutes now, normal under 5…

#mastoadmins #PostgreSQL

FINALLY getting (correction: MAKING!) a chance to learn some #PostGIS and utilise it in a 'real world' setting!

I appreciate the opportunity...

#GIS #spatial #mapping #postgresql #postgres #spatialdata #opensource #gischat #selflearning #alwayslearning #opendata #appliedscience #datadelivery #database #rdbms #OGC #STGeometry
@opengeospatial

We are a #opensource #MongoDB alternative built on #PostgreSQL

We wrote a guide on setting up #FerretDB on your #Kubernetes cluster using #StackGres

Read it here -- https://blog.ferretdb.io/run-ferretdb-on-stackgres/

As someone who once worked for a payment processor, I can assure you that even the shittiest VPS/VM running #PostgreSQL and handling Queries stricly #FirstInFirstOut is faster than #Bitcoin :bitcoin: and #Ethereum together in terms of transaction speed and transaction volume.
https://www.youtube.com/watch?v=YQ_xWvX1n9g&t=1578s