🎉🎩 Presenting the magical pg_clickhouse: because what’s better than duct-taping two databases together with an “extension”? Now you can enjoy the thrill of pretending your #Postgres is secretly a #ClickHouse, and bravely hope it doesn’t implode. 🛠️💥
https://clickhouse.com/blog/introducing-pg_clickhouse #pg_clickhouse #database #extension #technews #innovation #HackerNews #ngated
#database
Pg_ClickHouse: A Postgres extension for querying ClickHouse
https://clickhouse.com/blog/introducing-pg_clickhouse
#HackerNews #Pg_ClickHouse #Postgres #ClickHouse #Database #Extension #Querying #Tools
SQLite JSON at full index speed using generated columns
https://www.dbpro.app/blog/sqlite-json-virtual-columns-indexing
#ycombinator #SQLite_JSON_Superpower_Virtual_Columns_Indexing #DB_Pro #database #blog #Blog
In our latest video, Solution Engineer Paul Rothrock demonstrates how pgEdge's Zero Downtime Add Node feature within Spock enables seamless cluster scaling and major version upgrades—without any service interruption.
Scripts to automate this process are available here: https://github.com/pgEdge/spock/tree/main/samples/Z0DAN
Check it out: 👉 https://www.pgedge.com/video/new-feature-highlight-zero-downtime-add-node
All pgEdge software is 100% open source under the PostgreSQL license.
#developers #programming #database #data #tech #technology #opensource #postgresql #postgres
That’s a wrap on the first #PostgreSQL #Edinburgh #meetup! 🐘
Huge thanks to @intrbiz for the talk, @pgEdgeDistributedPostgres for the 🍕, and UoE for the venue.
Slides:
🔹 PG Tricks: https://nexteam.co.uk/files/talks/pg-tricks-postgresedi-meetup.pdf
🔹 RAGtime with #Postgres: https://vyruss.org/computing/slides/postgresedi_ragtime_with_postgres.pdf
We return Feb 12th and need speakers! 🎤 DM/reply if you have a talk idea or feedback!
Happy holidays! 🎄
🚀 How to Deploy #MongoDB on #Ubuntu #VPS (5 Minute Quick-Start Guide)
This article demonstrates how to deploy MongoDB on Ubuntu VPS. This guide walks you through the step-by-step process of deploying MongoDB on an Ubuntu VPS (Ubuntu 22.04 or 24.04).
What is MongoDB?
MongoDB is a NoSQL, open-source, document-oriented #database designed for high performance, scalability, and flexibility. Unlike traditional ...
Continued 👉 https://blog.radwebhosting.com/how-to-deploy-mongodb-on-ubuntu-vps/?utm_source=mastodon&utm_medium=social&utm_campaign=mastodon.raddemo.host #selfhosting #opensource #selfhosted
Recently, our team decided to sponsor and attend Postgres Ibiza 2025 in support of the #PostgreSQL community in Spain and beyond. It ended up being a delightful event, with plenty to do and see, and much engagement from the audience during talks.
Learn more about our experience here - perhaps next year you can make plans to attend and visit us, too!
https://www.data-bene.io/en/blog/postgres-ibiza-2025/
#ibiza #spain #madrid #barcelona #technologia #opensource #europe #statistics #programming #coding #data #database #tech
SQLite JSON at Full Index Speed Using Generated Columns
https://www.dbpro.app/blog/sqlite-json-virtual-columns-indexing
#ycombinator #SQLite_JSON_Superpower_Virtual_Columns_Indexing #DB_Pro #database #blog #Blog
Dew Drop – December 12, 2025 (#4560)
buff.ly/nNoqSCQ
#dotnet #ai #webdev #windowsdev #visualstudio #cloud #csharp #mobiledev #database #dewdrop
Dew Drop – December 12, 2025 (...
Tại sao lại tạo thêm một công cụ SQL nữa? Vì tác giả quá FRUSTRATED với các công cụ hiện có: chậm, nặng, nhiều tính năng không cần. Nên đã tự làm **data-peek** – nhẹ, nhanh (<2s mở), giao diện sạch, hỗ trợ PostgreSQL/MySQL/SQL Server, phím tắt thông minh, dark mode dễ nhìn. Mã nguồn mở, minh bạch, cá nhân dùng miễn phí.
#SQL #Database #OpenSource #Developer #datapeek #SQLClient
#CơSởDữLiệu #MãNguồnMở #PhátTriển #CôngCụLậpTrình
https://dev.to/gillarohith/why-i-built-yet-another-sql-client-a
Dew Drop – December 12, 2025 (#4560)
https://www.alvinashcraft.com/2025/12/12/dew-drop-december-12-2025-4560/
#dotnet #ai #webdev #windowsdev #visualstudio #cloud #csharp #mobiledev #database #dewdrop
Stoolap: High-performance embedded SQL database in pure Rust
Bạn chọn database nào cho ứng dụng? Nhiều người chọn MongoDB vì sợ JOIN, Cassandra để giống Netflix, hay một DB "ngầu" để ghi vào CV. Thực tế: 95% dự án nên dùng PostgreSQL. Dữ liệu nhỏ? Dùng Postgres. Caching? Dùng Redis. Dữ liệu đồ thị? Dùng Neo4j. Đừng tối ưu cho "giả định tương lai". Hãy triển khai nhanh, đúng nhu cầu thực. SQL vẫn là vua. #Database #PostgreSQL #SQL #Tech #Backend #Cơsởdữliệu #SQL #Lậptrình #Côngnghệ
https://dev.to/edgi/why-did-you-choose-that-database-for-your-application-
Azure Cosmos DB: Becoming a Search-Native Database
buff.ly/jShMGDh
#cosmosdb #azure #cloud #nosql #database #search
Azure Cosmos DB : Becoming a S...
Tìm các sản phẩm ít béo và có thể tái chế từ bảng Products. Truy vấn SQL đơn giản với điều kiện low_fats = 'Y' và recyclable = 'Y'.
#LeetCode #SQL #MySQL #Database #Programming #LậpTrình #CơSởDữLiệu #SQL50
#Pellkartoffeln kochen.
Hab zu lange über einer relativ flexiblen Exportstruktur in einem #ERP-System gebrütet.
Jetzt fix was zu essen machen.
Ein Teil der #Kartoffeln wird noch in #Bratkartoffeln konvertiert.
Hier werden Wünsche noch erfüllt!
Danach Gassirunde und danach dann weiter brüten und tüfteln.
Wenn die Pein der kleinen grauen Zellen Spaß macht. #coding #database #datenbank #datenexport
Architect's Guide: Modern API Design and Databases #shorts: An architect explains how legacy APIs and databases flow through a facade and adapter. The adapter determines if data translation is needed before sending it to a translator. #architecture #API #database #legacy #diagram https://www.youtube.com/shorts/cgukH3r77M0
Apparently I'm choosing chaos today, I just named a query using a mix of Snake case and camel case.
#choosingchaos
Welcome credativ as a Gold sponsor of PGConf.DE 2026 in Essen!
Curious about how to migrate efficiently from #Oracle to #PostgreSQL? Our experts have done it reliably and repeatedly using trusted open source solutions such as #IvorySQL.
Learn more about our process in our latest blog:
https://www.data-bene.io/en/blog/migrate-quickly-to-postgresql-from-oracle/
#migration #data #database #dataengineering #programming #coding #devops #opensource #postgres #dba #dev #devcommunity #developer
Client Info
Server: https://mastodon.social
Version: 2025.07
Repository: https://github.com/cyevgeniy/lmst