Geekflare·4yUltimate SQL Cheat Sheet to Bookmark for Later [2022]
SQL is a set of commands for managing relational database operations like delete, create, update, read, and so on. There are four types of SQL commands: Data Definition Language (DDL), Data Manipulation Language (DML) and Data Control Language. The cheat sheet will help you quickly reference the required commands with the correct syntax.
Pointer·4ybregman-arie/devops-exercises: Linux, Jenkins, AWS, SRE, Prometheus, Docker, Python, Ansible, Git, Kubernetes, Terraform, OpenStack, SQL, NoSQL, Azure, GCP, DNS, Elastic, Network, Virtualization. DevO
This repo contains questions and exercises on various technical topics, sometimes related to DevOps and SRE. There are currently 2292 exercises and questions. You can use these for preparing for an interview but most of the questions don't represent an actual interview. Join our DevOps community where we have discussions and share resources.
Hashnode·4yNode.js ORMs overview and comparison
ORM is a library to access the database, high-level library where you can define models, relations. Ideal ORM allows to define queries and then combine and reuse them to construct more complex queries. I'll share my experience of working with 6 popular ORMs including knex which is query builder.
Hacker News·4ydolthub/dolt: Dolt – It's Git for Data
Dolt is a single 68 megabyte program. It can be used to run queries or update the data using SQL commands. All the commands you know for Git work exactly the same for Dolt. We also built DoltHub, a place to share Dolt databases. If you want to host your own version of Dolt, we have DoltLab.
ByteByteGo·4yNew System Design YouTube channel | Internationalization | SQL Joins | HTTP error handling
The first video is already live and we'll try to post new videos weekly. Our goal is to explain complex systems in an easy-to-understand way. We'll be covering a wide range of topics including: What happens when you type a URL into your browser? How to avoid double charge?
DEV·4ySQL tips for beginners; what I learned after 10+ years of occasionally writing queries and schemas as a web dev
Index nearly everything, index early . Not indexing results in poor performances. Use lower case everywhere (and underscores), do not name your tables with camelCase. Be super consistent when naming tables and columns. Never miss a foreign key . Implicit links and relations between tables should be avoided.
InfoSec Write-ups·4yVulnerabilities in JS based Applications
Developers are increasingly gravitating toward frameworks that are written in JavaScript. There are still a lot of vulnerabilities that can be made vulnerable to. In this blog post we shall be going through a few of the vulnerabilities that you can check in a JS based framework. Vulnerabilities in JS based Applications: XSS, CSRF, SQL Injection.
Product Hunt·4ySteampipe - Open source SQL interface to your favorite cloud APIs🧑💻
select * from AWS, Azure, GCP, Github, Slack etc. Open source project from Turbot, empowers cloud pros to query cloud. Steampipe: select * from cloud; select ‘*’ from any cloud service. The extensible SQL interface to your favorite cloud APIs is free and open source.
TigerData (Creators of TimescaleDB)·4ySQL Isn't That Hard (When You Learn by Exploration)
Miranda Auhl is a developer advocate at Timescale. She uses SQL for troubleshooting, creating new content for developers, or learning something new. Her career path is a little all over the place and both a sad and happy journey. We hope this series helps you learn about new tools, training, and applications.
Ubuntu·4ySQL vs NoSQL: Choosing your database
There are scores of open source and proprietary databases available. Each offers distinct value to organisations. They can be divided into two primary categories: SQL (relational database) and NoSQL (non-relational) This article will explore the difference between the two and which is best for your use case.