#TIL that there is a new #GUI for #duckdb: #dbgate (https://dbgate.org). The current 6.4.x releases have now support for my fav analytical db (details in https://dbgate.org/blog/2025-04-30-6-4-0/)
#Development #Releases
Redis is open source again · Redis 8 is the first version with the new license https://ilo.im/163me5
_____
#Redis #OpenSource #Caching #DataStorage #Database #NoSQL #WebDev #Backend
(more FOSS news in previous posts of the thread)
qBittorrent 5.1 released with security improvements, support for the Thunar file manager on Linux, support for the “eXact Length” parameter when creating magnet URIs, support for fetching the tracker list from URLs, announce_port support, drag support to the torrent content widget, ability to display the external IP address in the status bar etc.:
https://9to5linux.com/qbittorrent-5-1-open-source-bittorrent-client-released-as-a-major-update
Redis goes open source again (kinda), offers Open Source edition from version 8:
https://alternativeto.net/news/2025/5/redis-goes-open-source-again-with-the-launch-of-redis-8-under-the-agplv3-license/
UN ditches Google Forms for CryptPad, as part of their initiative to adopt FOSS technologies:
https://news.itsfoss.com/un-ditches-google-form/
You should not expose a #database externally. You should expose an API with appropriate authentication and authorization rules that can communicate with your database.
https://www.reddit.com/r/PostgreSQL/comments/zxc0go/best_practise_exposing_db_access_to_internet/
NEW POST:
Remove IDENTITY Property From a Column
A (mostly) simple option that doesn't require any I/O...or the need for a large maintenance window.
Dave Mason
https://www.davemason.me/2025/05/03/remove-identity-property-from-a-column
I enjoy #MongoDb but the support for community is so poor that I’m starting to consider to use another #database that works on #apple silicon, can easily deploy on #kubernetes and supports documents. I’m seriously considering postgresql
"#Pgvector vs. #Qdrant: Open-Source Vector #Database Comparison"
TL;DR pgvector is awesome
Announcing the Release of SSMS 21 Preview 7.
Redis, which last year ceased licensing its code with the open source BSD-3 licence in favour of "source available" SSPL licences, which are not recognised by the Open Source Institute (OSI), has returned to the fold.
https://www.computing.co.uk/news/2025/open-source/redis-returns-to-the-open-source-fold
‘This Is What We Were Always Scared of’: DOGE Is Building a Surveillance State
Why is DOGE building a master #database acquiring & aggregating every database held by the US govt?
Why indeed.
@itsfoss And PostgreSQL taking on the huge task of managing all the infrastructure data.
The #FBI has its own “Next Generation Identification” #biometric & #criminal-history #database program; the agency also has a #FacialRecognition apparatus capable of matching people against >640M photos—a database made up of #DriversLicense & #passport photos, as well as mug shots. The #SocialSecurity Admin keeps a master #earnings file, which contains the “individual earnings histories for each of the 350+ million SSNs that have been assigned to workers.”
New post: "WebSysctl is Now Live!"
https://alfonsosiciliano.gitlab.io/posts/2025-04-26-websysctl.html
This looks really useful: sp_IndexCleanup
It's a stored procedure from Erik Darling that analyzes SQL Server indexes. It checks for things like unused indexes, uncompressed indexes, overlapping indexes, duplicated/nearly duplicated indexes, etc. And if I understood the video, if generates 'cleanup' scripts. Cool!
NYT Op-Ed 
