Just dropped a demo of chrondb — a PostgreSQL-compatible database that persists everything in Git.
Connect via psql, run SQL queries, and watch your data get versioned like code.
Watch it in action: https://www.youtube.com/watch?v=MRenNs_lbDQ
Just dropped a demo of chrondb — a PostgreSQL-compatible database that persists everything in Git.
Connect via psql, run SQL queries, and watch your data get versioned like code.
Watch it in action: https://www.youtube.com/watch?v=MRenNs_lbDQ
"Managing #PostgreSQL at scale: Challenges, Tools, & Techniques" will be presented by @karenhjex (Karen Jex) at #PosetteConf 2025 (Livestream 3 on Wed Jun 11th @ 9:00am PDT (UTC-7))
Learn more: https://posetteconf.com/2025/talks/managing-postgres-at-scale-challenges-tools-techniques/
- https://awstip.com/mastering-django-orm-from-models-to-advanced-queries-be22ec26e8bb
-----------------------
Django ORM turns complex database queries into simple Python code. Instead of writing long SQL statements, you can use:
- Basic filters (filter(), exclude(), get()) to find exactly what you need.
- Smart optimisations (select_related(), prefetch_related()) to speed up your app.
- Handy tricks (annotate(), aggregate()) for calculations without extra code.
-------------------------------------
The #free and #private office suite is a powerful, free and private office suite the successor project to #OpenOffice used by people around the world. It's #compatible with Microsoft Office (#365) and is backed by a non-profit organization, The Document Foundation. LibreOffice includes Writer (word processing), Calc (#spreadsheets), Impress (presentations), Draw (vector graphics and #flowcharts), Base (#databases), and Math (formula editing).
Do you like #databases? This is some interesting research into "ad hoc" transactions while using databases. It's like juggling your own locks and the database's transaction mechanism. Worth a read but it's not short. #programming #transactions https://cacm.acm.org/research-highlights/many-faces-of-ad-hoc-transactions/
What is the best free, open source program to make an Entity-Relationship Diagram of a database? Must be a local application, not web based.
Once upon a time I would have googled this but now all the results are search-engine optimized "blogs" from vendors trying to convince you their browser-based, subscripton-model app is the best option.
EDIT: One more requirement. I would like the field names and data types listed within the box for each table.
Join Peter Farkas's session "Leveraging Open Source Databases for Strategic Advantage" at #FOSSASIASummit2025 to get practical tips on choosing and migrating to open-source databases—and how they can boost your business and tech growth.
Click here https://youtu.be/AsDgZg-pLbM?si=0NkA2DNhSIgorEm9 to watch on the FOSSASIA YouTube channel
#OpenSource #Databases #FOSSASIA
Trump’s Aggression Sours #Europe on #US Cloud Giants
Companies in #EU are starting to look for ways to ditch #Amazon, #Google, and #Microsoft cloud services amid fears of rising #security risks from US. But cutting ties won’t be easy.
Organizations appear to be reconsidering their use of these companies’ cloud services—including #servers, storage, and #databases—citing uncertainties around #privacy and data access fears under Trump administration.
https://www.wired.com/story/trump-us-cloud-services-europe/
https://archive.ph/8FBGJ
Grist is the evolution of #spreadsheets.
The grist-core repo is the heart of Grist, including the hosted services offered by Grist Labs, an NYC-based company and Grist's main developer.
The French government organizations ANCT Données et Territoires and DINUM (Direction Interministérielle du Numérique) have also made significant contributions to the codebase.
- https://github.com/gristlabs/grist-core/commit/7bfe88bb3ee08d2393210e26bbc240aba4a0f5a7
Das gilt auch, und nicht nur für
1. #FOSS
2. #AI Modelle
3. #CVE #databases
4. #kev https://www.cisa.gov/known-exploited-vulnerabilities-catalog #CISA ist bereits unter Beschuss
5. #tor https://www.opentech.fund/ auch unter Beschuss
Wir können uns eigentlich nur noch auf reine #FOSS Modelle verlassen, und selbst das wird schwer, weil einige Communities gespalten sind.
Für alle, die jetzt noch gut schlafen konnten.
"Building modern Python web apps with PostgreSQL" will be delivered by Pamela Fox (@pamelafox) at #PosetteConf 2025 (Livestream 1 on Tue Jun 10th @ 10:00am PDT (UTC-7)).
Learn more: https://posetteconf.com/speakers/pamela-fox/
Boriss Mejias & Sarah Conway are part of the slate of speakers for #PosetteConf 2025. They will be telling a Postgres Story about "Cunning Schema Design with Creative Data Modeling" (Livestream 1 on Tue Jun 10th @ 9:00am PDT (UTC-7)).
Learn more: https://posetteconf.com/2025/talks/postgres-storytelling-cunning-schema-design-with-creative-data-modeling/
Hey #fedihire universe , like to work with a freelancer passionate about:
- #Django, doing it since 2007
- #JavaScript (preferably vanilla) since 1999
- and I love to speed up and optimize #databases, for speed, space, etc.
- fast, speedy, slim and very usable #websites (MPA but with SPA feel)
So I am backend and frontend experienced and love to help.
#Impact #startups preferred.
#FediHire #hire #freelance #work #searching
things I write about: https://picostitch.com
How AfterHour built an ultra-scalable chat service in one month with Rama
The LIVE recording for the #TalkingPostgres #podcast is happening on Wed 12 Mar at 10:00am PDT. Hope you can join us (or at least tell your database friends!) Boosts are always, always appreciated
This is Ep25 & the guest will be Dawn Wages @BajoranEngineer who is director of Community & Developer Relations at Anaconda—& will be talking about "Why Python developers just use Postgres"
#databases #python #django #OpenSource #PostgreSQL #Postgres
In affidavit, former Social Security official says DOGE is putting benefits at risk
https://www.muskwatch.com/p/in-affidavit-former-social-security
"detailed how deputies for #ElonMusk forced their way into the agency, formed a clandestine unit, and gained access to its most sensitive #databases...
also warned that careless actions by Musk’s #Doge could lead to interruptions in #SocialSecurity payments."
Postgres Just Cracked the Top Fastest Databases for Analytics — https://www.mooncake.dev/blog/clickbench-v0.1
#HackerNews #Postgres #Databases #Analytics #FastestTech #DataDriven
In 2024, the Data Bene team traveled to, presented at, & sponsored a number of #PostgreSQL community events, as well as started a blog, began a podcast in collaboration with Xata, and contributed back to #OpenSource.
Curious to know the details and see what we learned as a result of our experiences? Check out our new #Substack (free to subscribe) to see our recap for the year:
https://open.substack.com/pub/databene/p/engaging-with-the-postgresql-community
I asked for help here some months ago about one of the servers on this post that was hosted by Microsoft.
You can read about how that and other servers with infostealer logs ended up closed.
Hint: MSRC Portal is basically useless.
https://jltee.substack.com/p/billions-of-infostealer-logs-exposed
UPDATE: Federal court issues injunction against DOGE based on Musk Watch report
https://www.muskwatch.com/p/update-federal-court-issues-injunction
"The TRO, which expires March 10, will give the court time to make a final determination about whether #DOGE should be permitted to have access to these federal employee #databases. The court found that the plaintiffs "have shown a likelihood of success on the merits of their claim that OPM’s disclosure of their records to DOGE affiliates… violates the #Privacy Act."