News

Breaking News

Entertainment

Movies & Series

Music

Science & Technology

Sport

Business & Money

Education & Personal Development

Life

Culture & Art

Hobbies

News

Entertainment

Science & Technology

Sport

Business & Money

Education & Personal Development

Life

Culture & Art

Hobbies

home
›
Franck Pachot

Franck Pachot

8 | Follower

Software

See All

Franck Pachot

14.04.2025

MongoDB with Search Indexes Queried as Kimball's Star Schema with Facts and Dimensions - DEV Community

Export From SQL to CSV Import to MongoDB Indexing the Star Schema Querying the Star Schema - Star... Tagged with mongodb, search, index, analytics.

Franck Pachot

16.04.2025

PostgreSQL JSONB Indexing Limitations with B-Tree and GIN - DEV Community

In a previous post, I highlighted a significant limitation of relational databases: a One-to-Many... Tagged with postgres, gin, btree, jsonb.

Franck Pachot

28.04.2025

PostgreSQL aborts the transactions on error - DEV Community

You may be surprised by this in PostgreSQL: postgres=!# commit; ROLLBACK postgres=# Enter... Tagged with postgres, sql, database, savepoint.

Franck Pachot

28.04.2025

Index Only Scan on JSON Documents, with Covering and Multi-Key Indexes in MongoDB - DEV Community

Storing JSON documents in a SQL database does not make it a document database. The strength of any... Tagged with mongodb, document, database, index.

home›Franck Pachot

Franck Pachot

Software

MongoDB with Search Indexes Queried as Kimball's Star Schema with Facts and Dimensions - DEV Community

PostgreSQL JSONB Indexing Limitations with B-Tree and GIN - DEV Community

PostgreSQL aborts the transactions on error - DEV Community

Index Only Scan on JSON Documents, with Covering and Multi-Key Indexes in MongoDB - DEV Community

home
›
Franck Pachot