HTTP QUERY Method
What problem was there? Querying using traditional GET requests with a large number of filters in the URL sometimes hits the browser/server character limit. In addition to limited expressiveness, eve
Jul 10, 20263 min read
Command Palette
Search for a command to run...
Latest articles
Backend Communication Design Patterns
0) Request - Response This is the very basic model that when the client (initiates the communication) usually sends a request to the server for getting something or performing an action and the server responds with the required files/data. ProsC...
Jul 5, 20245 min read
Indexing in databases
Creating an index denotes taking the column data and storing it in another index column our data is stored on disks as we all know, so file systems is the topic we are talking about now Pages (a way for how to store the data on hard disk) data is abo...
Mar 10, 20242 min read
Views in Relational Databases
Views are about providing a customized, filtered representation of the data Simple View in MySQL simple views are virtual tables taking no space on physical hard disks. syntax in MySQL: create view lvl_300_stds as select * from students where level_i...
Mar 10, 20243 min read
MySQL Shell Commands
Entering the SQL mode \sql connecting with a certain user \connect root@localhost using a specific database use new_db; creating a new user and adding a password for him. create user ali@localhost identified by '123pass' DCL (Data Control Languag...
Mar 7, 20241 min read
Transaction 4 Read Phenomena and Isolation Levels
Transactions A Transaction is a sequence of one or more SQL statements executed as a single unit of work. A transaction represents a logical unit of work that is either fully completed or fully rolled back to its previous state if any part of it fail...
Mar 7, 20244 min read