Database

Relational Database

RDBMS 

Normalization

ACID

BASE

MySQL

SQLITE

MongoDB

MySQL vs SQLITE


Comments

Post a Comment

Popular posts from this blog

Spring JDBC vs Spring Data

 The  difference in abstraction level and scope between Spring JDBC and Spring Data Spring JDBC : Low-level support : Spring JDBC provides a set of classes and utilities that simplify working with JDBC (Java Database Connectivity), the standard Java API for interacting with relational databases. Direct interaction with JDBC : With Spring JDBC, developers still work with core JDBC concepts like Connection, Statement, PreparedStatement, and ResultSet. Control and flexibility : Spring JDBC allows developers to have fine-grained control over SQL queries, transaction management, exception handling, and database access. Spring Data : Higher-level abstractions : Spring Data abstracts away much of the boilerplate code associated with data access by providing a consistent and unified programming model across different data stores (relational databases, NoSQL databases, etc.). Consistency across different data stores : Spring Data offers a common set of concepts and APIs for working wi...
Read more

Security in General

 The key concepts related to security in computing: hashing, symmetric encryption, asymmetric encryption, digital signatures, SSL/TLS protocol flow, and OAuth 2.0 flow. 1. Hashing Purpose : Hashing is a one-way function used to convert data into a fixed-size hash value, which is typically used for data integrity verification. Characteristics : Deterministic: The same input always produces the same output. Irreversible: It should be computationally infeasible to reverse the hash to retrieve the original data. Collision-resistant: Two different inputs should not produce the same hash output (though some algorithms like MD5 and SHA-1 are now considered weak). Common Algorithms : MD5, SHA-1, SHA-256, SHA-3. 2. Symmetric Encryption Purpose : Symmetric encryption uses the same key for both encryption and decryption, making it efficient but requiring secure key distribution. Use Cases : Encrypting data at rest, encrypting data in transit (e.g., SSL/TLS), and securing communication channel...
Read more

Waterfall Model

The Waterfall model is a breakdown of development activities into linear sequential phases, meaning they are passed down onto each other, where each phase depends on the deliverables of the previous one and corresponds to a specialization of tasks. The Waterfall model is a traditional sequential approach to software development, where each phase of the project is completed before moving on to the next. Waterfall promote adaptive planning, evolutionary development, early delivery, and continuous improvement . The phases typically include: Requirements : Gathering and documenting all project requirements from stakeholders. Design : Creating detailed design specifications based on the gathered requirements. Implementation : Coding and developing the software based on the design specifications. Testing : Conducting various testing activities, including unit testing, integration testing, system testing, and user acceptance testing, to ensure the software meets the specified requirements. D...
Read more