Best of SQL — August 2022

1. 1
   Article

   Community Picks·4y

   Software Engineer Interview: The Interview Study Guide For Software Engineers

   Ben Rogojan created a checklist on his last round of interviews that covers many of the popular topics. To help you keep track of your progress, we've compiled a comprehensive checklist of the same problems listed below.

   271

   11
2. 2
   Article

   Product Hunt·4y

   DbVisualizer - The Universal Database tool

   DbVisualizer is a universal database tool for administrators, developers, and analysts. It runs on all major OSes and connects to all commercially viable database engines.

   123

   8
3. 3
   Article

   Redis·4y

   NoSQL Data Modeling

   The Embedded and Partial Embed Pattern is a great model for keeping different tables with information that relates to one another. In non-relational databases, what you’d want to do is embed your list on the bounded side.

   58

   2
4. 4
   Article

   Supabase·4y

   Supabase Vault

   Supabase Vault is a Postgres extension for managing secrets and encryption inside your database. For self-hosting, pgsodium supports a variety of ways to place the root key into Postgres. To see the decrypted data, there is a special view created called vault. The actual raw key is not available to you in SQL, it is managed entirely outside of the SQL language in the Postgres server. If you take a backup or pause your project, that data remains encrypted.

   37

   1
5. 5
   Article

   SingleStore·4y

   MariaDB vs. MySQL

   MariaDB is an open-source Relational Database Management System (RDBMS) MariaDB is gaining popularity due to its flexibility and availability. MariaDB has made significant progress in the areas of scalability and reliability, and has emerged as a competitor to MySQL.

   29

   1
6. 6
   Article

   KDnuggets·4y

   Getting Started with SQL Cheatsheet

   SQL is one of the most powerful tools we have at our disposal as data scientists. There is no chance it will go out of style in the next few years, and can be immediately of practical use in your learning and your career.

   24

   1
7. 7
   Article

   ByteByteGo·4y

   EP20: How SQL works under the hood. Also...

   How does Netflix scale push messaging for millions of devices? Amazon DynamoDB powered 89 million requests per second during prime days. Netflix’s homegrown solution called ‘Zuul Push’ is used. For Android, FCM is used to send push notifications for Apple devices.

   23
8. 8
   Article

   Geekflare·4y

   PostgreSQL vs MySQL: Differences and Similarities

   The database system uses multi-version concurrency control (MVCC), MVCC makes a database suitable for concurrent data entry and data queries done by writers. Both the database systems offer account management features like roles, groups, and individual users. Users can simply download the distribution package under the MIT license. Oracle controls the development and maintenance of the DBMS. It is free and available as a server version on GitHub.

   14
9. 9
   Article

   InfoSec Write-ups·4y

   Cybersecurity Learning Path

   Learn Programming Programming is a core part if you want to make a career in cybersecurity. Coding knowledge can give you the insight you need to recognize what a piece of software is doing, and even if it's malicious code or not.

   13
10. 10
    Article

    Community Picks·4y

    What is a Materialized View?

    Materialized views should update automatically, but this has so far proven impossible to deliver on. Not every database supports materialized views, and those that do each handle them a little differently, especially when it comes to the approach to view maintenance. MongoDB Yes, in 4.2+ Manual MongoDB has a NoSQL equivalent of materialized view.

    10