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