cep, to random
@cep@fosstodon.org avatar

Running experiments with ChatGPT asking it questions related to , 60% had incorrect or misleading information, and 20% had answers that would have caused (at best) performance reductions. One suggested that you can just delete WAL files if space is getting tight.

Do not use LLMs as technical advisors.

hunleyd, to random
@hunleyd@fosstodon.org avatar

Announcing FerretDB 1.0 GA - a truly Open Source alternative | FerretDB Blog https://blog.ferretdb.io/ferretdb-1-0-ga-opensource-mongodb-alternative/

fabian, to programming
@fabian@floss.social avatar

🔖 ormar
https://collerek.github.io/ormar/

Mini ORM for Python, with support for Postgres, MySQL, SQLite to be used with async frameworks

mjgardner, to random
@mjgardner@social.sdf.org avatar

TIL about window functions and @rrwo’s helper module for them in the leading , DBIx::Class. You can use them in many different relational database systems like , , , and . https://fosstodon.org/@rrwo/110334747507360471

ascherbaum, to random
@ascherbaum@mastodon.social avatar

PostgreSQL Person of the Week interview with: Floor Drees (@floord)


https://postgresql.life/post/floor_drees/

hunleyd, to random
@hunleyd@fosstodon.org avatar

How collation of punctuation and whitespace works https://peter.eisentraut.org/blog/2023/04/12/how-collation-of-punctuation-and-whitespace-works

hunleyd, to random
@hunleyd@fosstodon.org avatar

How much does it take to compile (on my machines)? https://fluca1978.github.io/2023/04/11/PostgreSQLCompilationTimes.html

jrefior, (edited ) to javascript
@jrefior@hachyderm.io avatar

Is it just me, or is supporting the full range of 8-byte integer IDs in web applications a pain in the butt?
https://www.postgresql.org/docs/15/datatype-numeric.html
https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Number/MIN_SAFE_INTEGER
https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Number/MAX_SAFE_INTEGER
https://stackoverflow.com/questions/59456390/using-bigint-in-typescript
https://stackoverflow.com/questions/18755125/node-js-is-there-any-proper-way-to-parse-json-with-large-numbers-long-bigin

Sooo much easier to handle them as strings and do type conversions in backend code

jrefior, to javascript
@jrefior@hachyderm.io avatar

Another moment where it's a bit frustrating that PostgreSQL doesn't support unsigned integer types.

MDN recommends checking whether a value is in local storage by truthiness:
https://developer.mozilla.org/en-US/docs/Web/API/Web_Storage_API/Using_the_Web_Storage_API#testing_whether_your_storage_has_been_populated

If the value is an ID that could be zero, is that safe?
if (localStorage.getItem("jobID"))

It's easy to skip zero in an unsigned int sequence: you start at 1 and only lose a single value from your range.

If you do that with int you lose half your range.

louis, (edited ) to random
@louis@emacs.ch avatar

If anyone is interested in migrating tables to , I've written a Go CLI to ease that process.

I wrote it two years ago and just updated it to Go 1.20 and it still works pretty well:

https://codeberg.org/louis77/pg2sqlite

hunleyd, to random
@hunleyd@fosstodon.org avatar

Parallel aggregate - 16 - better performance https://www.cybertec-postgresql.com/en/parallel-aggregate-postgresql-16-better-performance/

louis, to random
@louis@emacs.ch avatar

I find it increasingly difficult to self-host a database and have full confidence that it runs in a fully optimized way. There are so many settings, many targeting the underlying VM/hardware. Often I don't even have enough information about the VM/hardware to know what the most optimal settings are.

PostgreSQL devs are adding tons of new features and settings with every release.

There should be a lightweight "auto" mode where PG figures out the most appropriate settings with only a few hints.

But PG is now an enterprise RDBMS primarily targeting Oracle customers. Simplicity is not a quality they expect and I understand that.

I think it is time to explore the route as an alternative. There is https://rqlite.io a fault-tolerant distributed SQLite server with an HTTP API written in Go, with automatic S3 backup and restore.

hunleyd, to random
@hunleyd@fosstodon.org avatar

Setting Up Failover and Failback, the Right Way! - Highgo Software Inc. https://www.highgo.ca/2023/04/10/setting-up-postgresql-failover-and-failback-the-right-way/

hunleyd, to random
@hunleyd@fosstodon.org avatar

Interview with: Joël Cattin | Person of the Week https://postgresql.life/post/joel_cattin/

hunleyd, to random
@hunleyd@fosstodon.org avatar

Schema: Learning PostgreSQL with Grant - Simple Talk https://www.red-gate.com/simple-talk/databases/postgresql/postgresql-schema-learning-postgresql-with-grant/

hunleyd, to random
@hunleyd@fosstodon.org avatar

PGSQL Phriday – Triggers for tracking changes in a table | ads' corner https://andreas.scherbaum.la/blog/archives/1138-PGSQL-Phriday-007-Triggers-for-tracking-changes-in-a-table.html

hunleyd, to random
@hunleyd@fosstodon.org avatar

Updating the Cost Limit On The Fly https://rhaas.blogspot.com/2023/04/updating-cost-limit-on-fly.html

hunleyd, to random
@hunleyd@fosstodon.org avatar

PGSQL Phriday – A word about triggers https://hdombrovskaya.wordpress.com/2023/04/08/pgsql-phriday-007-a-word-about-triggers/

hunleyd, to random
@hunleyd@fosstodon.org avatar

STOP! Trigger Time - pgMustard https://www.pgmustard.com/blog/trigger-time

hunleyd, to random
@hunleyd@fosstodon.org avatar

® JSONB Cheatsheet: Complete & Fast Lookup Guide https://dev.to/ftisiot/postgresqlr-jsonb-cheatsheet-complete-fast-lookup-guide-2o2m

elein,

@hunleyd

Just a note—postgresql documentation is free as is the database program. http://www.postgresql.org

“In this walkthrough, we're going to use an Aiven for PostgreSQL database: we can create one, using the $300 and 30 days trial period, by accessing the aiven…”

hunleyd, to random
@hunleyd@fosstodon.org avatar

Triggers: A Love/Hate Relationship https://www.softwareandbooz.com/triggers-a-love-hate-relationship/

hunleyd, to random
@hunleyd@fosstodon.org avatar

Audit Data with Triggers: PGSQL Phriday - Blog @ RustProof Labs https://blog.rustprooflabs.com/2023/04/pgsqlphriday-007-audit-with-triggers

paulox, to linux
@paulox@fosstodon.org avatar

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) 🐐

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

hunleyd, to random
@hunleyd@fosstodon.org avatar

Triggers in : Love them or hate them? [PGSQL Phriday ] - Stormatics https://stormatics.tech/triggers-in-postgresql-love-them-or-hate-them-pgsql-phriday-007/

  • All
  • Subscribed
  • Moderated
  • Favorites
  • •
  • JUstTest
  • modclub
  • DreamBathrooms
  • InstantRegret
  • tacticalgear
  • magazineikmin
  • Youngstown
  • thenastyranch
  • mdbf
  • slotface
  • rosin
  • Leos
  • kavyap
  • Durango
  • normalnudes
  • ethstaker
  • everett
  • GTA5RPClips
  • cubers
  • khanakhh
  • ngwrru68w68
  • anitta
  • provamag3
  • cisconetworking
  • tester
  • osvaldo12
  • megavids
  • lostlight
  • All magazines
    •