Best of SQL — July 2023

  1. 1
    Article
    Avatar of kdnuggetsKDnuggets·3y

    Why is DuckDB Getting Popular?

    DuckDB combines the simplicity and ease of use of SQLite with the analytical performance of specialized columnar databases. DuckDB is free and open-source software, so anyone can use and modify the code. It's embedded, meaning the DBMS ( database management system) runs in the same process as the application that uses it.

  2. 2
    Article
    Avatar of kdnuggetsKDnuggets·3y

    Database Optimization: Exploring Indexes in SQL

    A similar issue also occurs in SQL Server when it retrieves data from the database. To overcome this, SQL server also uses indexing which speeds up the data retrieval process. We will cover why indexing is needed and how we can effectively create and delete indexes.

  3. 3
    Article
    Avatar of mlnewsMachine Learning News·3y

    Top 50+ AI Coding Assistant Tools in 2023

    ChatGPT is capable of writing code without relying on existing code references. ChatGPT has expanded its capabilities to include self-testing of its own code. GitHub Copilot is an AI-powered code completion tool that analyzes contextual code and delivers real-time feedback and recommendations.

  4. 4
    Article
    Avatar of lnLaravel News·3y

    Laravel 10.16 Released

    Laravel 10.16 released v10.16 with support for in the Collection method, improvements to the output for sub-minute tasks, allow binding of IPv6 addresses in artisan serve, and more: Improve the display of sub- minute tasks in the command.

  5. 5
    Article
    Avatar of kdnuggetsKDnuggets·3y

    A Beginner’s Guide to Data Engineering

    A Beginner’s Guide to Data Engineering - KDnuggets. Start today by learning more about data engineering and the fundamental concepts. Data engineering encompasses the set of all processes that collect and integrate raw data from various resources. The responsibilities of data engineer include - Extracting and integrating data from a variety of sources.

  6. 6
    Article
    Avatar of hackernoonHacker Noon·3y

    Creating a Node.js Server With Postgres and Knex on Express

    Creating a Node.js Server With Postgres and Knex on Express is a guide on setting up a node.js server. All within the Express.js framework, this guide will help you get the most out of your Node.JS server.

  7. 7
    Article
    Avatar of uxplanetUX Planet·3y

    How we designed SQL Database Monitoring System

    Inquery is an open-source product that helps engineers to monitor database changes, branching, instant rollback & webhooks. Backstory Eric is a Lead engineer overseeing the technical operations of a successful online platform for fleet hire. To avoid this Eric often restricts database access, which can bog down development.

  8. 8
    Article
    Avatar of lnLaravel News·3y

    Laravel 10.15: Sub-minute Task Scheduling, Raw SQL Query Builder Methods, and More

    The Laravel team released v10.15 with sub-minute scheduling, raw SQL query build methods, throwing an HTTP exception from a view, and more. Sub-minute Scheduling provides new frequency options when scheduling jobs. Nuno Maduro contributed support for inline attachments in notification markdown mailables.

  9. 9
    Article
    Avatar of streamlitStreamlit·3y

    snowChat: Leveraging OpenAI's GPT for SQL queries

    SnowChat is a powerful and user-friendly application that enables users to interact with their Snowflake DataBase using natural language queries. SnowChat leverages OpenAI's GPT model to convert natural language into queries. It has a transformative impact on data interaction by expediting and streamlining data-driven decision-making.

See all SQL archives