CockroachDB·4ySQL Cheat Sheet – Quick and Easy SQL Command Reference Examples
This cheat sheet is designed to make it quick and easy to find that SQL command that’s right on the tip of your tongue. It’ll also be available in a printer-friendly, downloadable PDF form so that you can print it out and reference it easily from your desk.
asayer·4yBuilding CRUD Apps with NextJs
A CRUD application refers to an app that can perform four simple functions: Creating, Reading, Updating, and Deleting data. For example, blog sites need dynamic content management for productivity. With CRUD functionality, we can carry out these functions in our application. Next.js as our case study to look at how CRUD implementation works.
Hacker News·4yA database for 2022
We used to store our database in a single JSON file on disk, and then moved to etcd. Time for another change! We’re going to put everything in asingle file on disks again. We need something easier to dive into and get back out of quickly, a database similar to common development systems.
Pointer·4yturns any MySQL, Postgres, SQLite into a spreadsheet with REST APIs.
NocoDB turns any database into a smart-spreadsheet. It uses Docker, Git, Npm, Slack, Reddit, and Twitter. NocoDB can search, sort, filter, hide columns with uber ease. It can also upload images to cells (Works with S3, Minio, GCP, Azure, DigitalOcean, Linode, OVH, BackBlaze)
Hacker News·4yYDB — an open-source Distributed SQL Database
Using YDB as a database allowed Market Cart to withstand a hundredfold increase in the load on the Cart, while observing strict guarantees for response times. The migration was completed by just one developer in one month. The Cart is one of the key components of any marketplace or online store.
Towards Dev·4yStart writing SQL queries — Part II
The IN operator is shorthand for many OR conditions. The BETWEEN operator allows you to define a range to which the given value belongs. The NOT operator can be added to a WHERE clause to negate the condition that is placed after it. The LIKE operator checks whether the specified string matches a defined pattern.
KDnuggets·4y7 Steps to Mastering SQL for Data Science
The biggest piece of advice I can give aspiring data scientists is to learn SQL. This is an often-overlooked skill by most data science learning providers but is arguably as important as machine learning modeling. In this article, I will walk you through 7 steps you can take to master SQL for any data science or analytics role.