fljdin

5 ms·

1. 1.▲
   Database Linting and Analysis for PostgreSQL(pglinter.readthedocs.io)

   117 points by fljdin 1y ago|26 comments
2. 2.▲
   by fljdin 1y ago

   pglinter is a PostgreSQL extension that analyzes your database for potential issues, performance problems, and best practice violations. Written in Rust using pgrx, it provides deep integration with PostgreSQL for efficient database analysi
3. 3.▲
   by fljdin 3y ago

   Thank you for your feedback, both issues have been added to the project tracking.
4. 4.▲
   by fljdin 3y ago

   This is one of the major challenges the tool aims to meet! We hope to achieve reliable results this year. https://gitlab.com/dalibo/transqlate/-/issues/20
5. 5.▲
   by fljdin 3y ago

   The `transqlate` project aims to extend this kind of tool without limitation and under open-source license. We're studying JOOQ from afar, with the ambition of getting closer to its functional coverage.
6. 6.▲
   Transpile Any SQL to PostgreSQL Dialect(gitlab.com)

   189 points by fljdin 3y ago|45 comments
7. 7.▲
   by fljdin 3y ago

   A CLI tool to transpile SQL snippet from a dialect to another using an AST
8. 8.▲
   Recap of the PGDay UK 2023 Edition(blog.dalibo.com)

   1 points by fljdin 3y ago|0 comments
9. 9.▲
   On the Road to Freedom with Db_migrator(fljd.in)

   2 points by fljdin 3y ago|0 comments
10. 10.▲
    by fljdin 3y ago

    Importance of using a B-Tree index by the planner and executor for efficient query execution and performance optimization. Translated from a 2019 french blog post of mine.
11. 11.▲
    Index Explained(fljd.in)

    1 points by fljdin 3y ago|1 comments