Best of SQLOctober 2023

  1. 1
    Article
    Avatar of materializeMaterialize·3y

    Materialize extension for VS Code

    The Materialize VS Code extension allows developers to explore, query, and enhance their development experience. It is compatible with various IDEs and provides features such as schema exploration, profile configuration, query execution, and syntax validation.

  2. 2
    Article
    Avatar of kdnuggetsKDnuggets·3y

    5 Free Books to Master SQL

    Discover five free books to improve your SQL skills, covering everything from beginner to advanced levels. Learn SQL fundamentals, data manipulation, database management, and more.

  3. 3
    Article
    Avatar of communityCommunity Picks·3y

    We migrated to SQL. Our biggest learning? Don’t use Prisma

    A developer shares their experience migrating from MongoDB to Postgres and using Prisma for their backend. They highlight problems with Prisma's deployment, low performance, and lack of SQL-level joins. They ultimately recommend avoiding Prisma for production workloads.

  4. 4
    Article
    Avatar of freecodecampfreeCodeCamp·3y

    Learn MySQL – Beginner's Course

    Learn MySQL with a comprehensive and practical course on the freeCodeCamp.org YouTube channel. The course covers topics from the basics to advanced functionalities, including installation, database creation, querying, joins, and more. Taught by Josh, a Sql Server Database Administrator.

  5. 5
    Article
    Avatar of pointerPointer·3y

    cpacker/MemGPT: Teaching LLMs memory management for unbounded context 📚🦙

    MemGPT is a system that manages memory in language models to provide extended context. It can be used to create chatbots that can talk to SQL databases and local files. MemGPT can be run locally and has various commands for interaction.

  6. 6
    Article
    Avatar of vercelVercel·3y

    Vercel Postgres is now available for Hobby and Pro users – Vercel

    Vercel Postgres, a serverless SQL database, is now available for Hobby and Pro users. The storage pricing has been reduced by 60% and the usage prices for Pro users have been provided. Users can opt out of using Vercel Postgres by backing up and deleting their database.

  7. 7
    Article
    Avatar of itnextITNEXT·3y

    Combining multiple tables in Supabase

    The article discusses the benefits of splitting data into multiple tables in a relational database, explains how to add a table in Supabase using foreign keys, and demonstrates how to fetch data from multiple tables in Supabase.

  8. 8
    Article
    Avatar of kdnuggetsKDnuggets·3y

    Why SQL is THE Language to Learn for Data Science

    SQL is the essential language for data science due to its universal database accessibility, efficient data cleaning capabilities, seamless integration with other languages, and requirement for most data science jobs.