Downtime isn’t an option.

In this new DZone article, learn how to proactively prepare your #PostgreSQL database for disaster recovery—ensuring high availability, data integrity, and business continuity.

Read now: https://hubs.la/Q03qGDPh0

For more information on pgEdge, visit: https://hubs.la/Q03qGHYs0

Looking for any examples of using a ShinyApp to allow researchers to select the data they would need for their specific research question. This will be for a large, multi-site project and I was hoping there would be a way to have the the dataset processed based on selection and then sent all securely in the format they need (e.g. long vs wide format). For this to be done securely, I’m thinking the app sends a request which is downloaded regularly to a local machine which can then automatically send out the data as needed using secured methods… But there’s probably a more eloquent way to do this! #R #AskFedi #Data #Database

Next week, #PosetteConf is happening Jun 10-12. Free & virtual

Newly-published, this "ultimate guide" blog post will help you navigate the 4 livestreams & 42 #PostgreSQL talks at POSETTE: An Event for Postgres (or to figure out where the virtual hallway track is happening)

POSETTE is now in its 4th year. It's organized by the Postgres team at Microsoft, and our team's goal (in partnership with the amazing speakers) is to delight all of you who care about Postgres

Boosts appreciated. Don't let your #Postgres friends miss out.

https://techcommunity.microsoft.com/blog/ADforPostgreSQL/ultimate-guide-to-posette-an-event-for-postgres-2025-edition/4419896/

#Trump Taps #Palantir to Create Master #Database on Every #American. This is a page right out of the #fascist handbook. This should scare everyone… especially anyone who actually thought the COVID vax was going to track them. #violationofprivacy

https://newrepublic.com/post/195904/trump-palantir-data-americans

I want to make my partner a simple database (~3 tables, i think), because I think that's the "right" thing to use (as opposed to excel / google sheets). But, I've never had to create a database thingy before.

Seeing this as an opportunity to learn some #DuckDB or #SQLite.

Seeking #recommendations for a simple (GUI) interface for interacting with the tables.

#LibreOffice Base or something else?

#suggestions welcome
#database #db #help

SQLite version 3.50.0 is now available on the SQLite website

* https://sqlite.org/
* https://sqlite.org/releaselog/3_50_0.html
* https://sqlite.org/download.html

More details about changes for this release are in the second link above.

This release occurred exactly 25 years from the first code check-in for SQLite. The developers plan to continue enhancing, supporting, and maintaining SQLite for at least 25 more years.

POSETTE - An Event for Postgres
A virtual developer event
10-12 Jun, 2025

https://posetteconf.com/2025/

All Mac Apps: Your Ultimate Guide to macOS Software

#Tech #Database #Productivity

https://awesomeindie.com/product/all-mac-apps

Any database wizards out there?

I have a table with an ID column. The ID column is unique together with a valid date, so the ID itself is not unique.

However, I also need a name column that is unique under the condition that any given name can only correspond to one specific ID (but not necessarily the other way around).

The database is PostgreSQL. Is it possible to formulate, for instance, a UNIQUE INDEX to achieve this?

Edit: Solved

Let's say you have a #database with inconsistent values (e.g. inconsistent decimal separators – both '.' and ','). How do you call the process that fixes this? I want to call it "normalization" – but in the DB context, normalization is a very specific concept revolving around relations. Is this "harmonization"? #DataScience

It's with my utter dissatisfaction to confirm y'all that PostgreSQL 18 doesn't support `MAX|MIN` aggregates over a UUID column.

This means, you will need to creates the functions I already described... or just plug in Microsoft SQL Server, MySQL or MariaDB as alternatives.

Guess you *can* hack your way up in PostgreSQL for using `MIN(uuid)` and `MAX(uuid)`.

This involves:
1. Creating a function to compare UUID as binary.
2. Create MIN and MAX aggregates uses the function.
3. Create a function to transform UUID into binary.
4. Create additional indexes that use the UUID as binary.

Or you can just install Microsoft SQL Server and invoke the antichrist.

Haha

#programming #database #cringe #sql #blog
Sharpsign not-very-deep. I just made some shallow notes about database server useage with slight reference to #lisp, and shared a database horror story from a (non-lisp!) company I worked at ten years ago.

https://screwlisp.small-web.org/programming/not-very-deep-notes-and-a-cringy-anecdote-about-database-servers-and-SQL/

with some apologies to @saxnot (I will write a more serious post about lisp and databases much later, this one is not it. If you would like to be redacted from the post, let me know).

Thoughts, other horror stories welcome.

Have you, a sensible developer, noticed how horribly bad LLM-generated code is?

Then you should have a pretty good idea how I, a database administrator, feel when I see the queries your ORM has generated.

#SQL
#Database
#LLM
#ORM

Listwise deletion, also known as complete case analysis, is one of the simplest methods for handling missing data.

The attached image illustrates the challenges of listwise deletion when the missing data is not random.

Tutorial: https://statisticsglobe.com/listwise-deletion-missing-data/

More: http://eepurl.com/gH6myT

Can we change our passwords now?!

A huge unsecured credential database discovery is a great reminder to change your passwords

https://www.engadget.com/cybersecurity/a-huge-unsecured-credential-database-discovery-is-a-great-reminder-to-change-your-passwords-210537400.html?src=rss