#postgressql — Public Fediverse posts

Gizmodo: This SimCity-Like Visualization Turns Tech’s Most Boring Systems Into Fun. “Look, no one has ever accused SQL of being fun. It’s ubiquitous, it’s important, and it’s probably something you need to understand if you’re going to be doing any sort of work with data analytics, web development, and any other field that involves, y’know, data. But fun? Not so much. But maybe […]

Gizmodo: This SimCity-Like Visualization Turns Tech’s Most Boring Systems Into Fun. “Look, no one has ever accused SQL of being fun. It’s ubiquitous, it’s important, and it’s probably something you need to understand if you’re going to be doing any sort of work with data analytics, web development, and any other field that involves, y’know, data. But fun? Not so much. But maybe […]

Vault37 has been moved to a new docker-based instance of Postgres 18.4!

The dump and restore were smooth, and everything came right back up. 🥳

#mastodon #mastoadmin #postgresSQL #docker

Vault37 has been moved to a new docker-based instance of Postgres 18.4!

The dump and restore were smooth, and everything came right back up. 🥳

#mastodon #mastoadmin #postgresSQL #docker

Interessanter Workload - Weil wir meetings oft zur Stunde anfangen hat ai Firma die llm services rund um meetings anbietet eine hübsche Sägezahnfunktion in ihren Graphen :)

https://www.recall.ai/blog/postgres-postmaster-does-not-scale

(Geht im Post primär um #PostgresSQL)

Interessanter Workload - Weil wir meetings oft zur Stunde anfangen hat ai Firma die llm services rund um meetings anbietet eine hübsche Sägezahnfunktion in ihren Graphen :)

https://www.recall.ai/blog/postgres-postmaster-does-not-scale

(Geht im Post primär um #PostgresSQL)

Next why the database, why #postgressql why not #mariadb or something else?
Well this is basically based on experience.

When it comes to out of the box performance and stability, I find that postgres. Also when you need to adapt it for scalability in particular sharding I find this to be significantly easier than in other database.

It is not that the other DBs are bad. I find Postgres better.

Next why the database, why #postgressql why not #mariadb or something else?
Well this is basically based on experience.

When it comes to out of the box performance and stability, I find that postgres. Also when you need to adapt it for scalability in particular sharding I find this to be significantly easier than in other database.

It is not that the other DBs are bad. I find Postgres better.

Does anybody know if Postgres added more strict query argument checking since PG14?

I'm seeing things start to fail (when trying to compare string to int so always invalid) that didn't fail on PG17 that didn't fail on earlier releases (and also working on SQLite as everything is being fronted by Sequlize)

#database #PostgresSQL #postgres

Does anybody know if Postgres added more strict query argument checking since PG14?

I'm seeing things start to fail (when trying to compare string to int so always invalid) that didn't fail on PG17 that didn't fail on earlier releases (and also working on SQLite as everything is being fronted by Sequlize)

#database #PostgresSQL #postgres

PostgreSQL permissions are driving me up the wall.

GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA test TO user;

This only appears to apply to existing tables and needs to be run again after any new tables created.

Anybody know a way to have it apply at the SCHEMA level including new tables?

#SQL #PostgresSQL

PostgreSQL permissions are driving me up the wall.

GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA test TO user;

This only appears to apply to existing tables and needs to be run again after any new tables created.

Anybody know a way to have it apply at the SCHEMA level including new tables?

#SQL #PostgresSQL

Moje subiektywne zapiski z kursu...

https://blog.jurkiewicz.tech/kurs-administracji-postgresql-zapiski-9239f6838bb4
#PostgresSQL #kurs #blog #linux

I want to move my #Postgres database from the VPS that Mastodon is on.

I have a shared hosting package from NameCheap that I am paying for that is hosting static websites and not using any of the 50 allocated #PostgresSQL databases.

Are there any downsides to moving my DB to that shared hosting setup? #MastoAdmin

It's the Steller Plus plan at NameCheap

EDIT: Resolved. Several people here and elsewhere report that this shouldn't be done because of degraded performance.

I want to move my #Postgres database from the VPS that Mastodon is on.

I have a shared hosting package from NameCheap that I am paying for that is hosting static websites and not using any of the 50 allocated #PostgresSQL databases.

Are there any downsides to moving my DB to that shared hosting setup? #MastoAdmin

It's the Steller Plus plan at NameCheap

EDIT: Resolved. Several people here and elsewhere report that this shouldn't be done because of degraded performance.

Hab da ein #Jobangebot: #PHP, #Spryker, #PostgresSQL, #graphql in cooler Firma bei 100% #homeoffice oder wahlweise in #Essen oder #Bocholt. Dazu gibt's #Scrum (mehr oder weniger ;-) ), Praktika in anderen Bereichen des Unternehmens, und generell ein prima #Arbeitsklima.

Gerne teilen für mehr Reichweite. Gibt's im Fediverse Hashtags, die sonst noch relevant wären?

https://karriere.rosebikes.de/jobs/40986620/-Senior-PHP-Backend-Developer-m-w-d-/

#FediJobs #FediHire #getFedihired

Hab da ein #Jobangebot: #PHP, #Spryker, #PostgresSQL, #graphql in cooler Firma bei 100% #homeoffice oder wahlweise in #Essen oder #Bocholt. Dazu gibt's #Scrum (mehr oder weniger ;-) ), Praktika in anderen Bereichen des Unternehmens, und generell ein prima #Arbeitsklima.

Gerne teilen für mehr Reichweite. Gibt's im Fediverse Hashtags, die sonst noch relevant wären?

https://karriere.rosebikes.de/jobs/40986620/-Senior-PHP-Backend-Developer-m-w-d-/

#FediJobs #FediHire #getFedihired

Guest @FranckPachot from #yugabyte joins our very own @noctarius2k in this episode of the weekly, 20 min #CloudCommute #podcast, talking about #distributedsql, #postgresql , #vectordatabases, and more. Tune in!

The 🎙️ is available on Spotify, iTunes, Pandora, Amazon Music, and more.

🎥👉 https://youtu.be/1EAKqwcP2SY

#vectordatabase #vectorsearch #vectordb #database #databases #postgres #postgressql

Guest @FranckPachot from #yugabyte joins our very own @noctarius2k in this episode of the weekly, 20 min #CloudCommute #podcast, talking about #distributedsql, #postgresql , #vectordatabases, and more. Tune in!

The 🎙️ is available on Spotify, iTunes, Pandora, Amazon Music, and more.

🎥👉 https://youtu.be/1EAKqwcP2SY

#vectordatabase #vectorsearch #vectordb #database #databases #postgres #postgressql

Есть причина, по которой лучше выбрать #mariadb нежели #postgressql?

Есть причина, по которой лучше выбрать #mariadb нежели #postgressql?

It turns out that a #PostgresSQL table to store URLs crawled is a bad idea: the table is currently 749G on disk. In contrast, a bloom filter with a 1e-7 error for a billion items will take up about 4G https://hur.st/bloomfilter/?n=1000000000&p=1.0E-7&m=&k=

#mwmbl #opensource #searchengine

It turns out that a #PostgresSQL table to store URLs crawled is a bad idea: the table is currently 749G on disk. In contrast, a bloom filter with a 1e-7 error for a billion items will take up about 4G https://hur.st/bloomfilter/?n=1000000000&p=1.0E-7&m=&k=

#mwmbl #opensource #searchengine

Anyone know of an alternative to postico that won't make me guilty regularly for not forking over 60€?

#postgres #database #pgsql #sql #PostgresSQL

National Park Services (NPS) ‘Park Tiles’ [public web mapping, USA]
--
https://www.nps.gov/maps/tools/park-tiles/index.html#12/38.5640/-107.6372 <-- entry point
--
[also a mobile app ]
“Park Tiles is a suite of online basemaps designed to fit the National Park Service’s graphic identity. Built with simplicity and flexibility in mind, Park Tiles basemaps can be used as stand-alone reference maps, or customized web maps with additional data overlays. Park Tiles features NPS-sourced data inside park boundaries, and relies on OpenStreetMap data to provide additional context…”
#GIS #spatial #mapping #PostGIS #PostgresSQL #QGIS #vectortiles #opendata #opensource #gischat #ParkTiles #OSM #basemaps #NPS #maps #webmaps
@NPS

National Park Services (NPS) ‘Park Tiles’ [public web mapping, USA]
--
https://www.nps.gov/maps/tools/park-tiles/index.html#12/38.5640/-107.6372 <-- entry point
--
[also a mobile app ]
“Park Tiles is a suite of online basemaps designed to fit the National Park Service’s graphic identity. Built with simplicity and flexibility in mind, Park Tiles basemaps can be used as stand-alone reference maps, or customized web maps with additional data overlays. Park Tiles features NPS-sourced data inside park boundaries, and relies on OpenStreetMap data to provide additional context…”
#GIS #spatial #mapping #PostGIS #PostgresSQL #QGIS #vectortiles #opendata #opensource #gischat #ParkTiles #OSM #basemaps #NPS #maps #webmaps
@NPS

Ódio desbloqueado: configurar #Django + #PostgresSQL no #Docker/#Podman.

Ódio desbloqueado: configurar #Django + #PostgresSQL no #Docker/#Podman.

Importing the #Google #ngram #Data set into #PostgresSQL.

I'm almost done with the bi-grams.

I've got about ~900GB more to import, then it's on to the tri-grams.

This is an entire, unfiltered set, that I'm going to backup first and put in cold storage.

Then I'm going to filter out rows that have characters that aren't allowed in #HashTags. This is the dataset that will power #FediMod's hashtag #accessibility service.

Importing the #Google #ngram #Data set into #PostgresSQL.

I'm almost done with the bi-grams.

I've got about ~900GB more to import, then it's on to the tri-grams.

This is an entire, unfiltered set, that I'm going to backup first and put in cold storage.

Then I'm going to filter out rows that have characters that aren't allowed in #HashTags. This is the dataset that will power #FediMod's hashtag #accessibility service.

@ascherbaum,

Quest:
Existence of an #ODBC binding for Mastodon that decouples it from #PostgresSQL.

#MySQL only comes into play due to our mysql2odbc library for decoupling MySQL apps.

Based on our expertise and 30+ years of experience re #DataAcces, #DataConnectivity (ODBC and #JDBC), and DBMS tech (see our #VirtuosoRDBMS), I know we can build such a binding if need be.

Initially though, I am curious about what may already exist rather than what’s possible 😊

/cc @el_pink @Mastodon

@ascherbaum,

Quest:
Existence of an #ODBC binding for Mastodon that decouples it from #PostgresSQL.

#MySQL only comes into play due to our mysql2odbc library for decoupling MySQL apps.

Based on our expertise and 30+ years of experience re #DataAcces, #DataConnectivity (ODBC and #JDBC), and DBMS tech (see our #VirtuosoRDBMS), I know we can build such a binding if need be.

Initially though, I am curious about what may already exist rather than what’s possible 😊

/cc @el_pink @Mastodon

@tigase in the latest release of your server you mention emoji support for #MySQL , what about #PostgresSQL ?

#xmpp