Instant SQL is here: Speedrun ad-hoc queries as you type - MotherDuck Blog

Type, see, tweak, repeat! Instant SQL is now in Preview in MotherDuck and the DuckDB Local UI. Bend reality with SQL superpowers to get real-time query results as you type. | Reading time: 8 min read

MotherDuck

๐Ÿ“ฃ Published new free and public #DuckDB #SQLTools Preview v1.6.0 for VS Code IDE with DuckDB v0.10.2 support.

๐Ÿ“ฅ https://marketplace.visualstudio.com/items?itemName=RandomFractalsInc.duckdb-sql-tools

See our #ProDataTools repo for advanced #DuckDBPro schema, commands, and new features updates:

๐Ÿ“ฐ https://github.com/RandomFractals/pro-data-tools/blob/main/duckdb-tools.md#pro-data-tools

#VSCode #DataTools ๐Ÿ› ๏ธ ๐Ÿง™โ€โ™‚๏ธ ...

DuckDB Sql Tools - Visual Studio Marketplace

Extension for Visual Studio Code - DuckDB Sql Tools extension adds DuckDB connections, database schema, and SQL query user interfaces to VSCode IDE.

๐Ÿ“ฃ Released #DuckDBPro #SQLTools for VS Code IDE with #DuckDB v0.10.2 support.

๐Ÿ“ฐ https://github.com/RandomFractals/pro-data-tools/blob/main/CHANGELOG.md#duckdb-pro-tools-v160---2024-07-12

#VSCode #ProDataTools ๐Ÿง™โ€โ™‚๏ธ ...

pro-data-tools/CHANGELOG.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

๐Ÿ“ฃ Released #DuckDB #SQLTools Preview v1.5.0 for VS Code IDE with DuckDB v0.9.2 BigInt support.

๐Ÿ“ฅ https://marketplace.visualstudio.com/items?itemName=RandomFractalsInc.duckdb-sql-tools

Will update this free public DuckDB SQL Tools VS Code extension to support the latest DuckDB v0.10 and v1.0.0 next week.

See our #ProDataTools repo for advanced #DuckDBPro schema, commands, and new features updates:

๐Ÿ“ฐ https://github.com/RandomFractals/pro-data-tools/blob/main/duckdb-tools.md#pro-data-tools

#VSCode #DuckDB #SQLTools ๐Ÿง™โ€โ™‚๏ธ ...

DuckDB Sql Tools - Visual Studio Marketplace

Extension for Visual Studio Code - DuckDB Sql Tools extension adds DuckDB connections, database schema, and SQL query user interfaces to VSCode IDE.

๐Ÿ“ฃ Released #DuckDBPro Tools for VS Code IDE with full DuckDB v0.9.2 and BigInt support.

๐Ÿ“ฐ https://github.com/RandomFractals/pro-data-tools/blob/main/duckdb-tools.md#duckdb-pro-tools

Will update DuckDB Pro Tools to support DuckDB v0.10.3 and the latest v1.0.0 in the next few days. Stay tuned!

#VSCode #DuckDB #ProDataTools #SQLTools ๐Ÿง™โ€โ™‚๏ธ ...

pro-data-tools/duckdb-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

Will be updating #DuckDBPro SQL Tools for VS Code IDE to support DuckDB v0.9.2, v0.10.3 and the latest stable DuckDB v1.0.0 this week.

Let us know what other DuckDB Pro features you'd like to see in our #ProDataTools updates next.

๐Ÿ’ฌ https://github.com/RandomFractals/pro-data-tools/discussions/10

๐Ÿ“ฐ https://github.com/RandomFractals/pro-data-tools?tab=readme-ov-file#duckdb-pro-tools

#VSCode #DuckDB #SQLTools ๐Ÿ› ๏ธ ๐Ÿง™ ...

Welcome to VS Code Pro Data Tools Discussions! ยท RandomFractals pro-data-tools ยท Discussion #10

๐Ÿ‘‹ Welcome! We'll use GitHub Discussions to connect with our VS Code Data Tools users. We hope that you: Ask questions about new data tools features Share your ideas on how to improve them Engage wi...

GitHub

Updated #SQLiteProTools for VS Code IDE to support SQLite v3.44.

๐Ÿ“ฐ https://github.com/RandomFractals/pro-data-tools/blob/main/sqlite-tools.md

Happy 4th of July coders! ๐ŸŽ†

#ProDataTools #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

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
ร—

๐Ÿ“ฃ Released #DuckDBPro Tools for VS Code IDE with full DuckDB v0.9.2 and BigInt support.

๐Ÿ“ฐ https://github.com/RandomFractals/pro-data-tools/blob/main/duckdb-tools.md#duckdb-pro-tools

Will update DuckDB Pro Tools to support DuckDB v0.10.3 and the latest v1.0.0 in the next few days. Stay tuned!

#VSCode #DuckDB #ProDataTools #SQLTools ๐Ÿง™โ€โ™‚๏ธ ...