Hans-Juergen Schoenig: PostgreSQL: 1 trillion rows in Citus

Hans-Juergen Schoenig: PostgreSQL: 1 trillion rows in Citus
Android News & All the Bytes - Scheduled Maintenance until 2h30 PM Eastern time. #maintenance #website #database #update
Join Alkin Tezuysal's session "Unified Observability: Leveraging ClickHouse as a Comprehensive Telemetry Database" at #FOSSASIASummit2025 to learn how #ClickHouse simplifies observability, giving engineers deep system insights while minimizing infrastructure complexity.
Click here https://youtu.be/sCRXGqOPtOU?si=lWcjSCpKkuD_gLHW to watch on the FOSSASIA YouTube channel.
sqlmap: Automatic SQL injection and database takeover tool
sqlmap is an open source penetration testing tool that automates the process of detecting and exploiting SQL injection flaws and taking over of database servers. […]
https://darkwebinformer.com/sqlmap-automatic-sql-injection-and-database-takeover-tool/
"researched the use of blockchain in #humanitarian work, says that #blockchain technologies... offer no obvious advantages over other tools organizations could use, such as an existing payments system or another #database tool. “There’s no proven advantage that it’s cheaper or better,” he says. “The way it’s been presented is this #tech solutionist approach that has been proven over and over again to not have any substantial impact in reality”"
https://www.wired.com/story/trump-administration-usaid-blockchain/
»Facial Recognition Company Clearview Attempted to Buy Social Security Numbers and Mugshots for its Database:
Clearview AI spent nearly a million dollars in a bid to purchase “690 million arrest records and 390 million arrest photos” from all 50 states, court records reveal.«
What does this have to do with intelligence if the dasts are clearly clearly visible? (just a retired question.)
Facial Recognition Company #Clearview Attempted to Buy #SocialSecurity Numbers and #Mugshots for its #Database
https://www.404media.co/facial-recognition-company-clearview-attempted-to-buy-social-security-numbers-and-mugshots-for-its-database/
Years ago I created a #php #mysql #comics #database
https://sourceforge.net/projects/madcollector/
DM me If you'd be interested in reviving it.
"Police officers and employees misusing access to police database now account for over half of all cybercrime pros-ecutions in the UK. The harms this can cause are considerable.
Yet police continue to call for encryption to be weakened to allow for greater access to communication data."—Alice Hutchings [Cambridge Cybercrime Centre]
Police Behaving Badly >
searchcode.com’s SQLite database is probably 6 terabytes bigger than yours
While working on porting the Small Technology Foundation web site¹ to Kitten², I took the opportunity to pull out base Model and Collection classes that I’ll likely end up including in Kitten proper:
• Model: https://codeberg.org/small-tech/site/src/branch/kitten/app_modules/database/Model.js
• Collection: https://codeberg.org/small-tech/site/src/branch/kitten/app_modules/database/Collection.js
To see them in use, here’s the base Posts class (with RSS generation) that extends Collection:
https://codeberg.org/small-tech/site/src/branch/kitten/app_modules/database/Posts.js
And here’s the concrete EventPosts collection class that extends Posts:
https://codeberg.org/small-tech/site/src/branch/kitten/app_modules/database/EventPosts.js
And the EventPost (showing an implementation of a calculated property):
https://codeberg.org/small-tech/site/src/branch/kitten/app_modules/database/EventPost.js
So all this is possible (persisting and reading back typed model collections, etc.) thanks to JSDB¹ (JavaScript database), a zero-dependency, transparent, in-memory, streaming write-on-update JavaScript database I wrote for the Small Web that persists to a JavaScript transaction log and is included as as first-class citizen in Kitten.
https://codeberg.org/small-tech/jsdb
And if you want to know how the magic mapping of classes happens, see the Database App Module:
https://codeberg.org/small-tech/site/src/branch/kitten/app_modules/database/database.js#L34
PS. For a much gentler introduction to persistence in Kitten, see the Kitten Persistence tutorial:
https://kitten.small-web.org/tutorials/persistence/
Enjoy!
Web developers: Do you use MariaDB or PostgreSQL for web apps? Is there any particular reason for your choice?
- Eridian
This is an interesting bar chart of my record collection. You can see some of the major changes in tech, and sometimes even how my musical taste responds to it.
“A NATIONAL CYBERATTACK”
https://krebsonsecurity.com/2025/02/trump-2-0-brings-cuts-to-cyber-consumer-protections/
"The rapidity w/ which #DOGE has rifled through one federal #database after another... has alarmed many #security experts...
“The most alarming aspect isn’t just the access being granted,” wrote Bruce Schneier & Davi Ottenheimer, referring to DOGE as a national #cyberattack. “It’s the systematic dismantling of security measures that would detect & prevent misuse"
I've had quite a few outrageous responses to my alerts, this is another one of those, sent by teammateapp.com CEO.
After my initial alert and follow up email, I get a reply lying about the severity of the exposure and telling me to stop harassing the company.
This CEO also didn't know what Proton is and thought I work for them and threatened to report me to them in case I didn't stop.
Read about it here: https://jltee.substack.com/p/new-zealand-companys-impossible-to-hack-security
Federal workers launch a new site to share inside information about DOGE
“They are destroyers. We are the builders.”
https://www.theverge.com/news/617014/federal-workers-we-the-builders-website-doge
"a secure outlet for #government workers to share how their workplaces are being impacted by #DOGE...
aimed at informing the general #public about what’s happening inside federal agencies, as well as explaining how a #database being accessed by DOGE in #WashingtonDC could impact citizens in tangible ways all across the country."
Bingo! In earlier testing with cubeSQL, I was using a known seed to validate the hashes were being creating correctly. I now have the the Atari doing generating the seed and connecting to cubeSQL (running on Linux) via FujiNet.
I found an oddity in the FujiNet b64 encode that needs some more troubleshooting to isolate. And that was causing me much grief in trying to get these complex hashes put together successfully - thus the known seed that is now removed.
I can sleep now. :D