#dataBase

2025-06-27

Attending #HOW2025? @c2main is speaking in less than 30 minutes at Zhonghua Hall.

Attend to learn about PSI in the context of #PostgreSQL, or keep an eye out for the recording post-conference to watch later on πŸ“½οΈ

#linux #postgres #data #database #china #jinan #highgo #ivorysql #oracle #monitoring #dev

HOW2025 
Catch CΓ©dric @ Highgo Open World 
β€œPressure Stall Information (PSI) has been present in Linux for numerous years, but even so, it's not well known in the world of PostgreSQL. In this talk, we'll introduce PSl along with what it brings, how it works, and where it is used today.

Then, we will use the β€˜pg_psi’ extension to start "playing" with PSl and react to system events. To do this, we will define system triggers so we're notified when the server is slowing down. This gives us the chance to adjust the workload before it's too late, or give more resources to background tasks like auto-vacuum when it's possible.” Resource Control Admission - | have a date with my PSI (Zhonghua Hall)

June 27 at 2 -2:40 PM GMT+8 Talk will be recorded and shared post-conference

www.ivorysql.io
Alfonso Sicilianoalfonsosiciliano@bsd.cafe
2025-06-26

πŸ–₯️ My ultra-budget server powering websysctl.alfonsosiciliano.net has been running smoothly for the past 2 months. So far, so good!

πŸ“ˆ #Crawlers hit tens of thousands of sysctl parameter pages daily. That's fine, since robots.txt allows it. But why keep requesting non-existent pages as if the site were built with WordPress 😀 ? Fortunately, the stack (#FreeBSD :freebsd: + #OpenResty 🌐 + #Lapis ✏️ + a custom-built #database πŸ“¦ ) stays well within the limited resources of my $5/month cloud server.

The code might soon be #OpenSource stay tuned!

#UNIX #sysctl #WebDev #WebServer #ThePowerToServe #coding #Lua #kernel

Screenshot of the "Tree MIB" page from the WebSysctl site. The left panel shows an expandable tree view of the FreeBSD sysctl MIB hierarchy, with nodes like sysctl, kern, vm, sys, security, and their subcategories. The security.mac.mmap_revocation_via_cow node is selected. The right panel displays detailed information about this sysctl parameter, including its link, OID, name, description ("Revoke mmap access to files via copy-on-write semantics, or by removing all write access"), type (integer), format (I), flags (RD, WR, MPSAFE), label, and handler status (Defined). The top navigation bar includes links: Home, Docs, Table, Tree (highlighted), Update, Login, and Contacts.

Key :: Value Access Language (KVAL) for BoltDB and Golang


by @beet_keeper

With some forced downtime as the effects of the Kaikōura earthquake are felt here on the North Island, with the shutdown of Archives New Zealand, what better way to spend it than creating a new grammar and parser for key-value databases? I have spent the last few weeks developing a specification for a Key-Value Access Language (KVAL) and implementing a binding for it for Golang’s BoltDB. I hope it will be of interest to folks, but let’s take a look at it in more detail below.

Continue reading β€œKey :: Value Access Language (KVAL) for BoltDB and Golang”…

#API #Bolt #BoltDB #Database #Go #Golang #KeyValueAccessLanguage #KeyValueStore #KVAL #Libraries

Abstract representation of a Key Value store
pgEdge Distributed PostgreSQLpgEdgeDistributedPostgres
2025-06-26

That’s why we’ve focused on active-active as the solution for edge networks, IoT devices, AI applications, and every other industry demanding high availability, low to zero downtime, minimal latency, and fault tolerant data systems.

What has your experience been with Postgres? ⬇️ πŸ‘€

2025-06-26

If you're diving into SQL Change Data Capture (CDC), I just published an article on it. Hopefully, it can save you some time or help you out!

πŸ”Ήmortylen.hashnode.dev/change-d

#sql #sqlserver #database

2025-06-26

Enhancing reporting and analytics with SQL Server 2025 tools and services. buff.ly/asbT7wb #database #sqlserver #reporting #data #analytics #sqlserver2025

Enhancing reporting and analyt...

2025-06-26

πŸš€ Join Free Online Oracle Cloud Infrastructure (OCI) Demo
πŸ“˜ Learn Cloud Services, Networking, Compute & Storage
πŸ‘¨β€πŸ« With Real-Time Expert: Mr. Krishna
πŸ“… Demo Date: 28/06/2025
πŸ•™ Time: 10:00 AM IST
πŸ”— Join Link: meet.goto.com/467544085
πŸ“ž Contact: +91-7032290546
🎯 Don’t miss this opportunity to boost your Cloud career!

🌐 Visit: visualpath.in/oracle-cloud-inf
πŸ“² WhatsApp: wa.me/c/917032290546

κ³ λ‚¨ν˜„gnh1201@hackers.pub
2025-06-26
pgEdge Distributed PostgreSQLpgEdgeDistributedPostgres
2025-06-25

Curious how you'd achieve conflict resolution in a traditional multi-master architecture? pgEdge uses source-available PostgreSQL extension Spock, which accounts for issues such as incrementing or sum fields with conflict-free delta-apply columns, supports partitioned tables (and geosharding as a result!), & implements last-update-wins conflict resolutions. Learn more:

pgedge.com/blog/navigating-dis

pgEdge Distributed PostgreSQLpgEdgeDistributedPostgres
2025-06-25

It can be challenging to run applications with stringent high availability requirements, low latency requests, and ensure there's a reliable database management system powering it all. Luckily, there's to the rescue. 🐘

Multi-master distributed as a solution is discussed in depth in our technical whitepaper - view it here: pgedge.com/landing-pages/multi

JCONjcon
2025-06-25

Our next session is live: ' Unleashed: Supercharge Your Application' with Markus Kett

Are you struggling with the of traditional databases …

Grab your coffee and hit play: youtu.be/8yyKPxdCTvw

2025-06-25

From Highgo Software Inc., the HOW2025 Eco Conference is in 2 days - will you be there? Say hi to our team!

It is a community-driven technical conference dedicated to advancing #OpenSource technology, especially focused on the #database field (particularly on #PostgreSQL and IvorySQL, a #Postgres distribution with #Oracle compatibility). Registration is 100% free, and it will be live streamed.

#data #tech #technews #techevent #foss #oss #sql #datascience #dev #developer #devcommunity

π•‚πšžπš‹πš’πš”β„™πš’πš‘πšŽπš•kubikpixel@chaos.social
2025-06-25

Why UUIDs are bad, and why you should consider the alternative

TL;DR: Use Cuid2 instead of UUID.

πŸ§‘β€πŸ’» claytonchew.com/article/why-uu

#code #uuid #cuid2 #cuid #uniqueidentity #unique #id #db #database #whyuse #it #considere #uniqueID #programming

2025-06-24

If you're interested in SQL Service Broker, I wrote an article about it a while ago and also shared some test scripts on GitHub. Hopefully, it might help someone or save you some time.

πŸ”Ήmortylen.hashnode.dev/sql-serv
πŸ”Ήgithub.com/mortylen/sql-servic

#sql #sqlserver #servicebroker #database

JAVAPROjavapro
2025-06-24

nearly broke without . redefined data access. cleaned it up. Then came β€”and everything changed again. Raphael De Lio & Brian Sam-Bodden walk through 30 years of shifts.

Read more: javapro.io/2025/05/21/a-look-b

Salar Rahmanian :verified: :scala: :swift: :nix:softinio@social.softinio.com
2025-06-24

πŸŽ‰ Huge thanks to the LanceDB CEO / cofounder Chang She for delivering an incredible talk on "Search, Retrieval, Training, and Analytics with Modern AI Data Lake" at #DataAndAIEngineering #SanFrancisco #meetup !

πŸ“Ή Great news - the recording is now available! Check it out if you missed it or want to revisit the key concepts. πŸ‘‡

https://watch.softinio.com/w/mVkLgtcQw8Qv5vA4v8SDHB

#DataEngineering #AIEngineering #SanFrancisco #LanceDB #DataLake #MachineLearning #VectorDB #Database #AI #ArtificialIntelligence

Erik C. Thauvinethauvin
2025-06-24

DiceDB is an open-source, high-performance, and in-memory database. It delivers blazing-fast performance and a developer-friendly experience, all while supporting real-time applications.

baeldung.com/java-dicedb

Client Info

Server: https://mastodon.social
Version: 2025.04
Repository: https://github.com/cyevgeniy/lmst