considering making my own DBMS. this is a good idea, right?
November 2, 2026 at 3:22 AM
considering making my own DBMS. this is a good idea, right?
dbms is short for “damn b*tch, more SQL?”
November 2, 2026 at 3:34 AM
dbms is short for “damn b*tch, more SQL?”
What makes ClickHouse a column-oriented DBMS, how one server is put together and how to run it on Kubernetes with the UK Price Paid dataset loaded.
#clickhouse #databases #analytics #kubernetes
https://stdout.adegoodyer.com/posts/columnar-storage-and-where-clickhouse-fits/?utm_source=bluesky
#clickhouse #databases #analytics #kubernetes
https://stdout.adegoodyer.com/posts/columnar-storage-and-where-clickhouse-fits/?utm_source=bluesky
ClickHouse Internals: Part 1 - Columnar Storage and Where ClickHouse Fits
What makes ClickHouse a column-oriented DBMS, how one server is put together and how to run it on Kubernetes with the UK Price Paid dataset loaded.
stdout.adegoodyer.com
October 31, 2026 at 12:40 PM
What makes ClickHouse a column-oriented DBMS, how one server is put together and how to run it on Kubernetes with the UK Price Paid dataset loaded.
#clickhouse #databases #analytics #kubernetes
https://stdout.adegoodyer.com/posts/columnar-storage-and-where-clickhouse-fits/?utm_source=bluesky
#clickhouse #databases #analytics #kubernetes
https://stdout.adegoodyer.com/posts/columnar-storage-and-where-clickhouse-fits/?utm_source=bluesky
📦 lagdo/dbadmin-app-symfony v0.14.0
A web based database management tool with multiple DBMS support.
🔗 https://github.com/lagdo/dbadmin-app-symfony
A web based database management tool with multiple DBMS support.
🔗 https://github.com/lagdo/dbadmin-app-symfony
November 2, 2026 at 12:00 AM
📦 lagdo/dbadmin-app-symfony v0.14.0
A web based database management tool with multiple DBMS support.
🔗 https://github.com/lagdo/dbadmin-app-symfony
A web based database management tool with multiple DBMS support.
🔗 https://github.com/lagdo/dbadmin-app-symfony
📘 SQL course, lesson 1.1: Introduction to Databases
Free lesson with tasks you run right in the browser:
https://sqltest.online/en/lesson/getting-started/introduction-to-databases
#SQL #LearnSQL #Database
Free lesson with tasks you run right in the browser:
https://sqltest.online/en/lesson/getting-started/introduction-to-databases
#SQL #LearnSQL #Database
Introduction to Databases
A database is an organized collection of data managed by a DBMS. Learn database types, core DBMS functions, and why SQL is the universal data language.
sqltest.online
November 3, 2026 at 10:41 AM
📘 SQL course, lesson 1.1: Introduction to Databases
Free lesson with tasks you run right in the browser:
https://sqltest.online/en/lesson/getting-started/introduction-to-databases
#SQL #LearnSQL #Database
Free lesson with tasks you run right in the browser:
https://sqltest.online/en/lesson/getting-started/introduction-to-databases
#SQL #LearnSQL #Database
Solving 500+ DSA problems doesn't guarantee you'll crack a software engineering interview.
You also need CS fundamentals, DBMS, system design, and the ability to explain your project decisions.
Don't just solve problems. Understand the WHY.
#SoftwareEngineering #CodingInterviews
You also need CS fundamentals, DBMS, system design, and the ability to explain your project decisions.
Don't just solve problems. Understand the WHY.
#SoftwareEngineering #CodingInterviews
October 31, 2026 at 2:02 PM
Solving 500+ DSA problems doesn't guarantee you'll crack a software engineering interview.
You also need CS fundamentals, DBMS, system design, and the ability to explain your project decisions.
Don't just solve problems. Understand the WHY.
#SoftwareEngineering #CodingInterviews
You also need CS fundamentals, DBMS, system design, and the ability to explain your project decisions.
Don't just solve problems. Understand the WHY.
#SoftwareEngineering #CodingInterviews
📦 lagdo/dbadmin-app-slim v0.14.0
A web based database management tool with multiple DBMS support.
🔗 https://github.com/lagdo/dbadmin-app-slim
A web based database management tool with multiple DBMS support.
🔗 https://github.com/lagdo/dbadmin-app-slim
November 2, 2026 at 12:00 AM
📦 lagdo/dbadmin-app-slim v0.14.0
A web based database management tool with multiple DBMS support.
🔗 https://github.com/lagdo/dbadmin-app-slim
A web based database management tool with multiple DBMS support.
🔗 https://github.com/lagdo/dbadmin-app-slim
📦 lagdo/dbadmin-app-laravel v0.14.0
A web based database management tool with multiple DBMS support.
🔗 https://github.com/lagdo/dbadmin-app-laravel
A web based database management tool with multiple DBMS support.
🔗 https://github.com/lagdo/dbadmin-app-laravel
November 2, 2026 at 12:00 AM
📦 lagdo/dbadmin-app-laravel v0.14.0
A web based database management tool with multiple DBMS support.
🔗 https://github.com/lagdo/dbadmin-app-laravel
A web based database management tool with multiple DBMS support.
🔗 https://github.com/lagdo/dbadmin-app-laravel
even just having the bot scrape out the punchlines of "must have 5 years experience with [DBMS created 3 years ago]" would help. but also we had a technology for that, and it was "an email." (the email recipient's 5min read time was valuable, but also amortizable.)
October 29, 2026 at 4:46 PM
even just having the bot scrape out the punchlines of "must have 5 years experience with [DBMS created 3 years ago]" would help. but also we had a technology for that, and it was "an email." (the email recipient's 5min read time was valuable, but also amortizable.)
【過去記事】トリガー（trigger）とは
トリガー＝引き金ですね。
カンタンに言ってしまえば「引き金となるもの」って感じでしょうか。データベース管理システム(DBMS=共有データとしてのデータベースを管理し、データに対するアクセス要求に応え
https://mutsu.me/blog/archives/980?utm_source=bluesky&utm_medium=social&utm_campaign=dio_blog_reposter
トリガー＝引き金ですね。
カンタンに言ってしまえば「引き金となるもの」って感じでしょうか。データベース管理システム(DBMS=共有データとしてのデータベースを管理し、データに対するアクセス要求に応え
https://mutsu.me/blog/archives/980?utm_source=bluesky&utm_medium=social&utm_campaign=dio_blog_reposter
November 3, 2026 at 11:33 PM
【過去記事】トリガー（trigger）とは
トリガー＝引き金ですね。
カンタンに言ってしまえば「引き金となるもの」って感じでしょうか。データベース管理システム(DBMS=共有データとしてのデータベースを管理し、データに対するアクセス要求に応え
https://mutsu.me/blog/archives/980?utm_source=bluesky&utm_medium=social&utm_campaign=dio_blog_reposter
トリガー＝引き金ですね。
カンタンに言ってしまえば「引き金となるもの」って感じでしょうか。データベース管理システム(DBMS=共有データとしてのデータベースを管理し、データに対するアクセス要求に応え
https://mutsu.me/blog/archives/980?utm_source=bluesky&utm_medium=social&utm_campaign=dio_blog_reposter
www.youtube.com/watch?v=DBMs...
Yeah this looks a bit rough ngl guys
Yeah this looks a bit rough ngl guys
Transformers Reactivate Closed Beta Test Trailer
YouTube video by RoboGamer1HD
www.youtube.com
October 27, 2026 at 9:04 PM
www.youtube.com/watch?v=DBMs...
Yeah this looks a bit rough ngl guys
Yeah this looks a bit rough ngl guys
Igor Suhorukov: pg_vexec one month on: ahead of ClickHouse on Parquet, close behind on MergeTree
tech_blogs_planetscale
#Databases
tech_blogs_planetscale
#Databases
Igor Suhorukov: pg_vexec one month on: ahead of ClickHouse on Parquet, close behind on MergeTree
A month after porting Greenplum to PostgreSQL 19, pg_vexec beats ClickHouse on Parquet and nearly catches up on MergeTree in ClickBench, and a rough draft of a GPU version is faster still. I’ve published the telemetry from the runs: charts, metrics, DBMS logs and numbers from deep inside the engin
postgr.es
October 30, 2026 at 8:42 PM
Igor Suhorukov: pg_vexec one month on: ahead of ClickHouse on Parquet, close behind on MergeTree
tech_blogs_planetscale
#Databases
tech_blogs_planetscale
#Databases
No. It's what the wealthy will do with "AI" to us.
Likely, it's enslavement by the Mark of the Beast (Palantir + data centers + Oracle DBMS + "AI" + digital cash replacing physical cash, to watch everything you do and cut off your ability to buy food and water if you piss off the wealthy).
Likely, it's enslavement by the Mark of the Beast (Palantir + data centers + Oracle DBMS + "AI" + digital cash replacing physical cash, to watch everything you do and cut off your ability to buy food and water if you piss off the wealthy).
October 28, 2026 at 11:51 AM
No. It's what the wealthy will do with "AI" to us.
Likely, it's enslavement by the Mark of the Beast (Palantir + data centers + Oracle DBMS + "AI" + digital cash replacing physical cash, to watch everything you do and cut off your ability to buy food and water if you piss off the wealthy).
Likely, it's enslavement by the Mark of the Beast (Palantir + data centers + Oracle DBMS + "AI" + digital cash replacing physical cash, to watch everything you do and cut off your ability to buy food and water if you piss off the wealthy).
Every useful application needs a way to manage information. Learning DBMS, SQL, and database design gives CSE students a better understanding of how real-world software works.
#GalgotiasUniversity #BTechCSE #DBMS
#GalgotiasUniversity #BTechCSE #DBMS
October 22, 2026 at 7:27 AM
Every useful application needs a way to manage information. Learning DBMS, SQL, and database design gives CSE students a better understanding of how real-world software works.
#GalgotiasUniversity #BTechCSE #DBMS
#GalgotiasUniversity #BTechCSE #DBMS
A colleague once asked a chat bot something about high availability in a specific DBMS - while screen sharing with me - when I'd just told him how it worked. It gave him the wrong answer, which I then had to refute because he clearly weighted its answer higher than mine.
October 22, 2026 at 11:08 AM
A colleague once asked a chat bot something about high availability in a specific DBMS - while screen sharing with me - when I'd just told him how it worked. It gave him the wrong answer, which I then had to refute because he clearly weighted its answer higher than mine.
Fast Open-Source OLAP (Online Analytical Processing) DBMS | ClickHouse https://clickhouse.com/
Fast Open-Source OLAP DBMS | ClickHouse
ClickHouse is a fast open-source column-oriented database management system that allows generating analytical data reports in real-time using SQL queries
clickhouse.com
October 21, 2026 at 10:22 PM
Fast Open-Source OLAP (Online Analytical Processing) DBMS | ClickHouse https://clickhouse.com/
Tino Engelbrecht and Joshua Steinmann are now speaking about DBMS design differences between #postgresql and #oracle at #pgconf.eu
October 21, 2026 at 10:01 AM
Tino Engelbrecht and Joshua Steinmann are now speaking about DBMS design differences between #postgresql and #oracle at #pgconf.eu
Blind SQL Injection: How do you identify the DBMS when the application reveals nothing?
MySQL, PostgreSQL, SQL Server, or Oracle?
Learn how to fingerprint the database using Boolean-Based and Time-Based techniques.
hackersbrain.com/identify-dat...
#SQLInjection #CyberSecurity
MySQL, PostgreSQL, SQL Server, or Oracle?
Learn how to fingerprint the database using Boolean-Based and Time-Based techniques.
hackersbrain.com/identify-dat...
#SQLInjection #CyberSecurity
How to Identify the DBMS in Blind SQL Injection
Learn how to identify MySQL, PostgreSQL, SQL Server, or Oracle using boolean-based and time-based blind SQL injection payloads, with practical examples.
hackersbrain.com
October 21, 2026 at 3:47 PM
Blind SQL Injection: How do you identify the DBMS when the application reveals nothing?
MySQL, PostgreSQL, SQL Server, or Oracle?
Learn how to fingerprint the database using Boolean-Based and Time-Based techniques.
hackersbrain.com/identify-dat...
#SQLInjection #CyberSecurity
MySQL, PostgreSQL, SQL Server, or Oracle?
Learn how to fingerprint the database using Boolean-Based and Time-Based techniques.
hackersbrain.com/identify-dat...
#SQLInjection #CyberSecurity
💥Boom💥
Virtuoso, our modern multi-model database management system (DBMS), already natively supports both relational tables and RDF entity-relationship graphs. Today, It has been officially extended to include native vector indexing for similarity search across literal values in SQL columns and […]
Virtuoso, our modern multi-model database management system (DBMS), already natively supports both relational tables and RDF entity-relationship graphs. Today, It has been officially extended to include native vector indexing for similarity search across literal values in SQL columns and […]
Original post on mastodon.social
mastodon.social
October 20, 2026 at 10:26 PM
💥Boom💥
Virtuoso, our modern multi-model database management system (DBMS), already natively supports both relational tables and RDF entity-relationship graphs. Today, It has been officially extended to include native vector indexing for similarity search across literal values in SQL columns and […]
Virtuoso, our modern multi-model database management system (DBMS), already natively supports both relational tables and RDF entity-relationship graphs. Today, It has been officially extended to include native vector indexing for similarity search across literal values in SQL columns and […]
#PostgreSQL の関数を併用すると、SQLの表現力がときに想像を超える。
unnest() は次のSQL文のように、バルクインサートを可能に。
INSERT INTO some_table (age, city, created_at)
SELECT unnest(array[20, 30, 40]), 'Tokyo', now();
www.unicorn.limited/jp/rd/dbms/2...
unnest() は次のSQL文のように、バルクインサートを可能に。
INSERT INTO some_table (age, city, created_at)
SELECT unnest(array[20, 30, 40]), 'Tokyo', now();
www.unicorn.limited/jp/rd/dbms/2...
PostgreSQLの配列でバルクインサート
複数行を一括でINSERTする際、配列を利用できます。配列型のカラムではなく、複数行を投入する方法です。
PostgreSQLにはunnest()という関数があり、配列を行に変換できます。
たとえば、以下のようなクエリが可能になります。
INSERT INTO some_table (age, …
www.unicorn.limited
October 22, 2026 at 3:24 AM
#PostgreSQL の関数を併用すると、SQLの表現力がときに想像を超える。
unnest() は次のSQL文のように、バルクインサートを可能に。
INSERT INTO some_table (age, city, created_at)
SELECT unnest(array[20, 30, 40]), 'Tokyo', now();
www.unicorn.limited/jp/rd/dbms/2...
unnest() は次のSQL文のように、バルクインサートを可能に。
INSERT INTO some_table (age, city, created_at)
SELECT unnest(array[20, 30, 40]), 'Tokyo', now();
www.unicorn.limited/jp/rd/dbms/2...
I was excited at one point because most IT problems had been solved.
Scalable DBMS, networking math miracles, Moores Law bounding along, WWW tech removing client compatibility (*real* write once, run anywhere, scale up 1000X)
Not perfect, but amazing compared to now, where HW is wasted on $lopware.
Scalable DBMS, networking math miracles, Moores Law bounding along, WWW tech removing client compatibility (*real* write once, run anywhere, scale up 1000X)
Not perfect, but amazing compared to now, where HW is wasted on $lopware.
October 18, 2026 at 11:25 PM
I was excited at one point because most IT problems had been solved.
Scalable DBMS, networking math miracles, Moores Law bounding along, WWW tech removing client compatibility (*real* write once, run anywhere, scale up 1000X)
Not perfect, but amazing compared to now, where HW is wasted on $lopware.
Scalable DBMS, networking math miracles, Moores Law bounding along, WWW tech removing client compatibility (*real* write once, run anywhere, scale up 1000X)
Not perfect, but amazing compared to now, where HW is wasted on $lopware.
pgのリモート #レプリケーション をセットアップする configと実際の手順。
バックアップとしての複製だけでなく、Readレプリカによる負荷分散にも。
www.unicorn.limited/jp/rd/dbms/2...
* 同期／非同期の選択
* 同一クラスタ・同一DB
* マイグレーション
#Postgres #UnicornResearch
バックアップとしての複製だけでなく、Readレプリカによる負荷分散にも。
www.unicorn.limited/jp/rd/dbms/2...
* 同期／非同期の選択
* 同一クラスタ・同一DB
* マイグレーション
#Postgres #UnicornResearch
PostgreSQL論理レプリケーション設定
ロジカルレプリケーション機能を利用すると、テーブル単位でレプリケーション構成をとれます。
一般的なRead/Writeスプリット構成のほか、アプリケーションフレームワークから見て単一DB内に外部マスターのテーブルを持ち込むこともできるため、マイクロサービスの難題になりがちなデータ伝播の解決への活用も …
www.unicorn.limited
October 19, 2026 at 1:18 AM
pgのリモート #レプリケーション をセットアップする configと実際の手順。
バックアップとしての複製だけでなく、Readレプリカによる負荷分散にも。
www.unicorn.limited/jp/rd/dbms/2...
* 同期／非同期の選択
* 同一クラスタ・同一DB
* マイグレーション
#Postgres #UnicornResearch
バックアップとしての複製だけでなく、Readレプリカによる負荷分散にも。
www.unicorn.limited/jp/rd/dbms/2...
* 同期／非同期の選択
* 同一クラスタ・同一DB
* マイグレーション
#Postgres #UnicornResearch
JetStream accelerates databases by generating query-specific optimizers linked with existing DBMS, achieving up to 315× speedups. It retains storage and transaction integrity while employing machine learning and rigorous verification for performance and correctness. https://arxiv.org/abs/2610.20527
JetStream: Generating Verified Query Accelerators for Existing Database Systems
ArXiv link for JetStream: Generating Verified Query Accelerators for Existing Database Systems
arxiv.org
October 16, 2026 at 12:10 PM
JetStream accelerates databases by generating query-specific optimizers linked with existing DBMS, achieving up to 315× speedups. It retains storage and transaction integrity while employing machine learning and rigorous verification for performance and correctness. https://arxiv.org/abs/2610.20527
JetStream revolutionizes database performance with query-specific accelerators that enhance existing DBMS without data migration, achieving 315× read speedup while ensuring accuracy with machine-checked proofs. https://arxiv.org/abs/2610.20527
JetStream: Generating Verified Query Accelerators for Existing Database Systems
ArXiv link for JetStream: Generating Verified Query Accelerators for Existing Database Systems
arxiv.org
October 15, 2026 at 8:00 PM
JetStream revolutionizes database performance with query-specific accelerators that enhance existing DBMS without data migration, achieving 315× read speedup while ensuring accuracy with machine-checked proofs. https://arxiv.org/abs/2610.20527
JetStream introduces a framework for generating database accelerators that work with existing DBMS, achieving 315x speedups while retaining SQL functionality. This boosts performance and supports dynamic data, enabling verified execution without migration. https://arxiv.org/abs/2610.20527
JetStream: Generating Verified Query Accelerators for Existing Database Systems
ArXiv link for JetStream: Generating Verified Query Accelerators for Existing Database Systems
arxiv.org
October 15, 2026 at 8:10 PM
JetStream introduces a framework for generating database accelerators that work with existing DBMS, achieving 315x speedups while retaining SQL functionality. This boosts performance and supports dynamic data, enabling verified execution without migration. https://arxiv.org/abs/2610.20527