While we wrap up our work on new #PGSqlTools for devs and data scientists using VS Code IDE, this is just a friendly reminder that we published #SQLiteProTools extension info last month, with instructions on how to subscribe and access all of the #ProDataTools 🛠️ we produced this year.

📰 https://github.com/RandomFractals/pro-data-tools/blob/main/sqlite-tools.md

#SQLite #SQLTools ...

pro-data-tools/sqlite-tools.md at main · RandomFractals/pro-data-tools

Pro Data Tools 🛠️ for VS Code IDE 🧙‍♂️: DuckDB Pro Tools, PRQL Code Lens, new Markdown SQL Pro Tools, upcoming Data Notebooks 📚 Pro Tools docs and demos, etc. - RandomFractals/pro-data-tools

GitHub

Added over 20 new standard Information Schema SQL view shortcut commands to our new #PGSqlTools over the weekend. These commands should work with most #SQLTools drivers and databases that support information_schema SQL standard.

PG SQL Pro Data Tools will also feature over 30 standard #Postgres system catalogs and view shortcut commands to view PG compatible system tables and views without writing any SQL in VS Code IDE. See: https://www.yugabyte.com/postgresql/compare-postgresql-compatibility/#postgresql-compatibility-matrix

#ProDataTools #PostgreSQL #SQLTools 🛠️

Comparing PostgreSQL-Compatible Databases

Compare PostgreSQL-compatible databases. Find your ideal fit among popular solutions like Amazon RDS, Azure Database for PostgreSQL, Google Spanner, and YugabyteDB

Yugabyte

Implemented a dozen of PG shortcut commands in our new #PGSqlTools today. Will add more shortcut commands for the other #PostgreSQL System Views from this list next week ...

https://www.postgresql.org/docs/current/views-overview.html

#ProDataTools #Postgres #SQLTools

54.1. Overview

54.1. Overview # Table 54.1 lists the system views. More detailed documentation of each catalog follows below. Except where noted, all the …

PostgreSQL Documentation

Started working on new #PGSqlTools plugin this month.

Similar to our #DuckDBPro and #SQLitePro #DataTools 🛠️ this extension will display all #Postgres DB objects in Connections Explorer, provide information schema, system catalogs and other standard PG view shortcut commands for Postgres, Cockroach and many other #pgwire compatible databases.

Aiming to support most of the popular PostgreSQL flavor databases from this list: https://wiki.postgresql.org/wiki/PostgreSQL_derived_databases

#VSCode #PostgreSQL #SQLTools #ProDataTools 🧙

PostgreSQL derived databases - PostgreSQL wiki