home.social

#sqltools β€” Public Fediverse posts

Live and recent posts from across the Fediverse tagged #sqltools, aggregated by home.social.

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

    πŸ“₯ marketplace.visualstudio.com/i

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

    πŸ“° github.com/RandomFractals/pro-

    #VSCode #DataTools πŸ› οΈ πŸ§™β€β™‚οΈ ...

  2. πŸ“£ Released #DuckDB #SQLTools Preview v1.5.0 for VS Code IDE with DuckDB v0.9.2 BigInt support.

    πŸ“₯ marketplace.visualstudio.com/i

    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:

    πŸ“° github.com/RandomFractals/pro-

    #VSCode #DuckDB #SQLTools πŸ§™β€β™‚οΈ ...

  3. πŸ“£ Released #DuckDBPro Tools for VS Code IDE with full DuckDB v0.9.2 and BigInt support.

    πŸ“° github.com/RandomFractals/pro-

    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 πŸ§™β€β™‚οΈ ...

  4. 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.

    πŸ’¬ github.com/RandomFractals/pro-

    πŸ“° github.com/RandomFractals/pro-

    #VSCode #DuckDB #SQLTools πŸ› οΈ πŸ§™ ...

  5. 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.

    πŸ“° github.com/RandomFractals/pro-

    #SQLite #SQLTools ...

  6. 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: yugabyte.com/postgresql/compar

    #ProDataTools #PostgreSQL #SQLTools πŸ› οΈ

  7. 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 ...

    postgresql.org/docs/current/vi

    #ProDataTools #Postgres #SQLTools

  8. Quick Preview of our upcoming #PGSqlProTools πŸ› οΈ with refined Schemas, Tables, Views and Columns data type icons, type descriptions, PK and FK column indicators.

    #VSCode #ProDataTools #PostgreSQL #SQLTools ...

  9. 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: wiki.postgresql.org/wiki/Postg

    #VSCode #PostgreSQL #SQLTools #ProDataTools πŸ§™

  10. Quick preview of the new #SQLiteProTools VS Code extension we plan to release later this month with column data type icons, primary key indicators, not null constraints info, etc.

    #SQLite / #SQLitePro / #SQLTools / #ProDataTools πŸ§™ ...

  11. Jotted down a few advanced features to add to the new #SQLiteProTools #VSCode extension we plan to release later this month ...

    #SQLite / #SQLitePro / #SQLTools / #ProDataTools πŸ§™ ...

  12. Gonna create new #SQLiteTools for #VSCode IDE in the next month or so for advanced users willing to pay for our #ProDataTools πŸ› οΈ ... #SQLite / #SQLTools πŸ§™β€β™€οΈ ...

  13. #DuckDB devs & users, we just hit 5K installs & over 7.6K downloads of our free & public #DuckDBSQLTools extension for #VSCode IDE.

    DuckDB Labs & co. should just buy that extension to get more traction in the #DataTools field with #SQLTools devs, data scientists, data analysts, and other users using & exploring their DB in Code πŸ˜‰

    πŸ“₯ marketplace.visualstudio.com/i

    #DuckDBTools πŸ› οΈ #ProDataTools πŸ§™β€β™€οΈ ...

  14. Published our #PRQLTools #VSCode extension documentation for devs & data scientists interested in using #PRQL, #SQLTools and various DB drivers to check out:

    πŸ“° github.com/RandomFractals/pro-

    Quick demo of using ▢️ Run Query #PRQLCodeLens with our #DuckDB SQL Tools:

    #ProDataTools πŸ› οΈ πŸ§™β€β™‚οΈ ...

  15. πŸ₯³ #PRQLProTools v1.2 & #PRQLCodeLens now use #PRQL language compiler v0.8 to generate & Run SQL queries for #DuckDB v0.8 & other #SQLTools DB drivers in #VSCode IDE.

    See updated docs & become a Pro sponsor on github to access the latest #ProDataTools πŸ› οΈ πŸ§™β€β™‚οΈ ...

    πŸ’– ‑ github.com/sponsors/RandomFrac

  16. Demo of our new #MarkdownSQLProTools extension with custom Select SQL & Execute SQL #VSCode lenses added to the #SQL code blocks in #markdown documents, showing SQL query results in #SQLTools + extended #DuckDB connection tree view display at the end using our #DuckDBProTools.

    #DataTools πŸ§™β€β™‚οΈ ...

  17. πŸ₯³ Behold! Our new #MarkdownSQLProTools extension w/Select SQL code & Execute All SQL statements #VSCode lenses, integrated with the popular #SQLTools extension & database drivers, #DuckDBProTools in this example 😎

    #Markdown #SQL #DuckDB #ProDataTools #DataTools πŸ§™β€β™‚οΈ ... πŸ’ŽπŸ’ŽπŸ’Ž... πŸš€πŸš€πŸš€ !!!

  18. The official PRQL Code extension doesn't support #PRQL documents with multiple queries defined, but you'll be able to use our new #DataNotebooks πŸ“š extension to load such PRQL docs in #VSCode πŸ““ & run those queries inline or with #PRQLCodeLens & #DuckDBPro #SqlTools πŸ§™β€β™‚οΈ 🀯

  19. willing data souls and explorers can try our awesome #PRQLCodeLens & #DuckDBProTools for $1.33 today. That #ProTools sub goes back to $10 tomorrow, as github prorates their monthly tiers and dues collected ... #PRQL #DuckDB #SQLTools πŸ’ŽπŸ’ŽπŸ’Ž ...

    πŸ’΅ ‑ github.com/sponsors/RandomFrac

  20. You can now Run #PRQL queries with new loop, func & let vars directly on the open #SQLTools connections using #PRQLCodeLens v1.1.0 extension from our private #PRQLPro Tools collection.

    Sign up to get access to the PRQL Code Lens πŸ“¦ #DataTools:

    πŸ’– ‑ github.com/sponsors/RandomFrac

  21. Where all the πŸ¦†s at you ask?

    Here is a fun #PRQL query you can run on that GBIF observations dataset 1st data chunk (~100MB) hosted by AWS with our #PRQLCodeLens #PRQLPro tool in VSCode 😎

    See demo GIF on twitter: twitter.com/TarasNovak/status/

    #DuckDB #SQLTools ...

  22. Also, our private beta of #DataProTools πŸ› οΈ #QueryDataNotebook πŸ““ extension with SQL & #PRQL query run cells will support SQLite, PostgreSQL, MSSQL, and MySQL. We'll see if we can use #SQLTools DB drivers & API for the broader Data Sources support later ... vscode-sqltools.mteixeira.dev/

  23. Users of #VSCodium IDE can also use our new #DuckDBSqlTools extension.

    1⃣ Download duckdb-sql-tools-x.x.x.vsix πŸ“¦ from our extension releases on github:

    πŸ“₯ github.com/RandomFractals/duck

    2⃣ Use Install from #VSIX feature to install #DuckDB #SqlTools πŸ“¦πŸ‘‡

    ▢️ twitter.com/TarasNovak/status/

    #SQL πŸ“œ #DataTools πŸ§™β€β™‚οΈ πŸ”¬ πŸ’Ž ...