#postgresSQL
LightNews LightNews
vanuatugis.bsky.social
Enterprise 11.3 Datastore content recovery - is it possible
Hello, As the title questions, is it possible to restore data out of a corrupted Enterprise 11.3 DataStore postgresSQL database? We had a host drop so ended up in a really odd corruption situation that esri support said needed to have a reinstall to recover. System had stopped writing any logs back in May or responding to…
community.esri.com
September 21, 2026 at 5:34 PM
vanuatugis.bsky.social
QGIS - error connection of database in RiverGIS
Currently, I am facing a problem to connect Postgres database to RiverGIS. It shows this error. Couldn't connect to river database: rivergis@localhost Please, check you database connection settings! But, I checked the connection in the PostgresSQL, and it says the connection is successful.
gis.stackexchange.com
August 28, 2026 at 9:05 AM
tonyxzt.bsky.social
I think I'll take a break from my Sharpino #fsharp #eventsourcing project for a while. In the meantime, I'll share a new doc site sharpino.eu . Feel free to review it. Feel free to support me.
Sharpino Docs
Event Sourcing in F# with PostgresSQL, Caching, and Optimistic Locking.
sharpino.eu
July 9, 2026 at 7:52 AM
andin29.bsky.social
Aquí un evento importante en Valencia.
La conferencia anual de Postgressql.

bsky.app/profile/pgco...
pgconf.eu PostgreSQL Conference Europe @pgconf.eu · Jul 7
Registration for PGConf.EU 2026 Is Now Open https://www.postgres...
July 8, 2026 at 9:58 AM
eiryplus.bsky.social
PostgresSQLとdbtでデータパイプラインの学習環境作って。PostgreSQLとdbtはそれぞれDockerのコンテナで動作させて。データパイプラインのレイヤーは lake, staging, intermediate, dwh, martの5層を初期から用意して

この指示だけで、普通に動く学習環境を作ってくれるFable 5強いなぁ・・・。他のモデルでもできるんだろうけど。手直しする場所なんてパッケージ管理周りくらいだった。
パッケージ管理も指示に含めておけば、そこもよしなにやってくれるし、今の若いもんは学習までのハードルがそもそもめっちゃ低いか。2極化が進むわけだ
July 7, 2026 at 11:19 PM
pchalamet.bsky.social
I could not find a tool like DACPAC for PostgresSQL, so I did one. It's named pgpackage and supports DSC-style workflows for PostgresSQL. Still in beta test, so do not use on production unless you have a backup 😉

magnusopera.github.io/pgpackage/
DACPAC-style desired state for PostgreSQL | pgpackage
Treat PostgreSQL schema as desired state in Git, then let pgpackage diff and apply it safely.
magnusopera.github.io
June 24, 2026 at 8:46 PM
awscmblogposts.bsky.social
✍️ New blog post by Giovanni Martinez

Inside Hypercore: How TimescaleDB Quietly Built a Hybrid OLTP/OLAP Engine on Postgres

#postgressql #tigerdata #hypercore
Inside Hypercore: How TimescaleDB Quietly Built a Hybrid OLTP/OLAP Engine on Postgres
Disclosure: I work at Tiger Data, the company behind TimescaleDB. This post is my own analysis...
dev.to
June 2, 2026 at 4:04 AM
mangzedi.wordpress.com.web.brid.gy
2026‑05‑25 ‒ 15H49 (T.T.C.+1) : #YoutUbBe #Pro‑pos⁠‧⁠jm #Fä⁠‧⁠tqha #Qry⁠‧⁠ês⁠‧⁠ôr ; #PostGresSQL.
15H :
mangzedi.wordpress.com
May 25, 2026 at 3:38 PM
postgresql.activitypub.awakari.com.ap.brid.gy
Architecting Digital Trust: A Relational Deep Dive into the LocalHands Prisma Schema Subtitle: How to model a secure, escrow-based marketplace for emerging economies using Prisma and PostgreSQL. Sc...

#Software #architecture #postgressql #prisma #prodsens […]

[Original post on prodsens.live]
Original post on prodsens.live
prodsens.live
May 2, 2026 at 10:16 PM
news.karthihegde.dev
pgrust (PostgresSQL Rust rewrite) update: at 67% Postgres compatibility, and accelerating
Discussion | lobsters | Author: nutmeg
pgrust (PostgresSQL Rust rewrite) update: at 67% Postgres compatibility, and accelerating
It’s been a week since I published the original pgrust post. pgrust is my attempt to rewrite Postgres in Rust. My ultimate goal is to build a database that is safer to work with so that I can work on improving Postgres. pgrust now passes about two thirds of the queries in the Postgres regressio...
malisper.me
April 30, 2026 at 1:35 AM
lobsters-feed.bsky.social
pgrust (PostgresSQL Rust rewrite) update: at 67% Postgres compatibility, and accelerating https://lobste.rs/s/ym2mzi ##databases ##rust ##vibecoding
pgrust update: at 67% Postgres compatibility, and accelerating - malisper.me
It’s been a week since I published the original pgrust post. pgrust is my attempt to rewrite Postgres in Rust. My ultimate goal is to build a database that is safer to work with so that I can work on improving Postgres. pgrust now passes about two thirds of the queries in the Postgres regression […]
malisper.me
April 30, 2026 at 1:50 AM
vanuatugis.bsky.social
QGIS - error connection of database in RiverGIS
Currently, I am facing a problem to connect Postgres database to RiverGIS. It shows this error. Couldn't connect to river database: rivergis@localhost Please, check you database connection settings! But, I checked the connection in the PostgresSQL, and it says the connection is successful.
gis.stackexchange.com
April 26, 2026 at 7:09 PM
opsmatters.com
The latest update for #SumoLogic includes "Join operator and Query Agent for smarter log analysis" and "How to deploy PostgresSQL on #Kubernetes".

#Logging #DevOps https://opsmtrs.com/2CHGDJf
Sumo Logic
Sumo Logic is a secure, cloud-native, machine data analytics service, delivering real-time, continuous intelligence from structured, semi-structured and unstructured data across the entire application lifecycle and stack.
opsmtrs.com
April 23, 2026 at 4:43 AM
postgresql.activitypub.awakari.com.ap.brid.gy
Indexing Strategies for Faster Database Queries TL;DR Indexes = direct lookups — milliseconds vs full table scans (seconds). B-tree for most queries — Supports = , < , > , BETWEEN , LIKE ...

#database #postgressql #sql #performance

Origin | Interest | Match
Indexing Strategies for Faster Database Queries
TL;DR Indexes = direct lookups — milliseconds vs full table scans (seconds). B-tree for...
dev.to
April 21, 2026 at 6:09 PM
postgresql.activitypub.awakari.com.ap.brid.gy
Location as the Anchor: Mapping Species, Geology, UFOs, and Bigfoot to 105,000 Coordinates Part 2 of 5. Part 1 covered the RAM crashes and data ingestion nightmare. This part is about what happens ...

#postgressql #postgis #dataengineering #seo

Origin | Interest | Match
Location as the Anchor: Mapping Species, Geology, UFOs, and Bigfoot to 105,000 Coordinates
Part 2 of 5. Part 1 covered the RAM crashes and data ingestion nightmare. This part is about what...
dev.to
April 19, 2026 at 4:17 AM
feed.igeek.gamer-geek-news.com.ap.brid.gy
🐧 **PostgresSQL: PGDay Armenia and Swiss PGDay 2026**

PostgresSQL news

📰 Source: Tux Machines
🔗 Link: https://tuxmachines.org/n/2026/04/18/PostgresSQL_PGDay_Armenia_and_Swiss_PGDay_2026.shtml
Tux Machines — PostgresSQL: PGDay Armenia and Swiss PGDay 2026
news.tuxmachines.org
April 18, 2026 at 4:07 PM
news.tuxmachines.org.web.brid.gy
PostgresSQL: PGDay Armenia and Swiss PGDay 2026
PostgresSQL news
tuxmachines.org
April 18, 2026 at 4:10 PM
rsamborski.bsky.social
Link: medium.com/google-cloud...
Building a Scalable RAG Backend with Cloud Run Jobs and AlloyDB
We explore how to build an industrial-strength RAG backend using BigQuery, Cloud Run Jobs, Vertex AI, and AlloyDB for PostgresSQL.
medium.com
April 15, 2026 at 8:37 AM
opsmatters.com
The latest update for #SumoLogic includes "How to deploy PostgresSQL on #Kubernetes" and "Claude Code is running bash commands on your infrastructure. Here's how to watch it.".

#Logging #DevOps https://opsmtrs.com/2CHGDJf
Sumo Logic
Sumo Logic is a secure, cloud-native, machine data analytics service, delivering real-time, continuous intelligence from structured, semi-structured and unstructured data across the entire application lifecycle and stack.
opsmtrs.com
April 4, 2026 at 12:54 AM
throwable.bsky.social
📦 weslinkde/laravel-postgres-tools v1.4.0

Some handy helper function for PostgresSQL Databases

🔗 https://github.com/weslinkde/laravel-postgres-tools
March 31, 2026 at 10:14 AM
postgresql.activitypub.awakari.com.ap.brid.gy
PostgreSQL(Alternations) -ALTER TABLE → modify existing table structure. -Operations: add/drop column, change datatype, rename column/table, add/drop constraints. Common ALTER… The post Postgre...

#Software #database #mysql #postgressql #prodsens #live #sql

Origin | Interest | Match
PostgreSQL(Alternations) - prodSens.live
-ALTER TABLE → modify existing table structure. -Operations: add/drop column, change datatype, rename column/table, add/drop constraints. Common ALTER…
prodsens.live
March 20, 2026 at 10:26 AM
postgresql.activitypub.awakari.com.ap.brid.gy
PostgreSql(Aggregative Functions) Aggregative Function: Aggregate functions perform calculations on multiple rows and return a single result. They’re essential for: Summarizing data (e.g., total ...

#postgressql #sql #database #mysql

Origin | Interest | Match
PostgreSql(Aggregative Functions)
Aggregative Function: Aggregate functions perform calculations on multiple rows and return a single...
dev.to
March 20, 2026 at 9:06 AM
mongodb.activitypub.awakari.com.ap.brid.gy
Stop Writing Endless Migrations: Mastering PostgreSQL JSONB in Laravel The "Settings" Table Nightmare Every SaaS application eventually hits the same architectural wall: dynamic data. You h...

#laravel #postgressql #database #webdev

Origin | Interest | Match
Stop Writing Endless Migrations: Mastering PostgreSQL JSONB in Laravel
The "Settings" Table Nightmare Every SaaS application eventually hits the same architectural wall:...
dev.to
March 18, 2026 at 5:02 AM
postgresql.activitypub.awakari.com.ap.brid.gy
Understanding Concurrency in PostgreSQL: How It Handles Multiple Transactions Efficiently Introduction Continue reading on Medium »

#sql #postgressql #design #software-architecture #software-development

Origin | Interest | Match
Awakari App
awakari.com
March 15, 2026 at 1:50 PM
postgresql.activitypub.awakari.com.ap.brid.gy
OpenAI’s Postgres Architecture: A Brilliant Fix for a Billion-Dollar Mistake Author: Matthew Penaroza , Head of AI Solution Architecture at SurrealDB OpenAI’s write-up on scaling PostgreSQL for...

#database #openai #postgres #postgressql

Origin | Interest | Match
OpenAI’s Postgres Architecture: A Brilliant Fix for a Billion-Dollar Mistake
Author: Matthew Penaroza, Head of AI Solution Architecture at SurrealDB OpenAI’s write-up on scaling...
dev.to
March 12, 2026 at 12:30 AM