ByteByteGo·3yEP63: Linux file system explained
The Filesystem Hierarchy Standard (FHS) was introduced to bring order to the Linux file system. By implementing a standard like the FHS, the software can ensure a consistent layout across various Linux distributions. To become proficient in this standard, you can begin by exploring. Utilize commands like "cd" for navigation and "ls" for listing directory contents.
InfoSec Write-ups·3ySQL Injection in The HTTP Custom Header
SQL Injection in The HTTP Custom Header has been a long time since my last write-up. After successful login, the request has one more HTTP header in the request, User header, and the value is a username that login to the application. Now, I try to change the username for IDOR possibility but the server validates it.
Community Picks·3yAwesome SQL Code Review Tools for Developers
SQL (Structured Query Language) is a fundamental tool for managing and manipulating data within relational databases. Writing good SQL code helps you better query the database. Code review is without a doubt one of the crucial parts of software development. It can help developers improve their SQL code quality by detecting potential problems.
KDnuggets·3yHow to Optimize SQL Queries for Faster Data Retrieval
How to Optimize SQL Queries for Faster Data Retrieval, we’ll talk about why SQL query optimization is important and which techniques can be used to optimize it. We'll talk about how to optimize the queries for faster data retrieval and how to use these techniques.
Decube·3yWhat is ETL? Difference between ETL and ELT
ETL and ELT are two approaches to data integration. ETL involves extracting data from source systems, transforming it into an analysis-ready format, and loading it into a data warehouse. ELT involves loading data into the target system first and transforming it as needed.
Community Picks·3yBuild a fully typed web app using Next.js, PlanetScale, Drizzle, and Kysely
PlanetScale is a super cool database-as-a-service platform based on Vitess, the same technology that powers YouTube, Slack, and other mega-scale companies. The PlanetScale CLI is a handy command-line tool provided by PlanetScale to make your life easier.
freeCodeCamp·3yHow to Use MySQL Stored Procedures to Simplify Database Operations
Stored Procedures are a set of SQL statements grouped together to form a logical unit of work. They are similar to functions or methods in programming languages, enabling you to encapsulate complex queries and operations into a single entity. These procedures can calculate metrics like total sales, top-selling products, or revenue by category.
Laravel News·3y🔥 Define Casts in a Query
Laravel allows you to define casts at the model level to handle casting values to their native types. You can use the method to define a cast at query time, giving you the power of complex queries yet still using casts. If you'd like to learn more about casts, check out Eloquent Attribute Casting and Elquent Custom Casts.
