Result and Error Codes| www.sqlite.org
Date And Time Functions| www.sqlite.org
CREATE TABLE| www.sqlite.org
CREATE INDEX| www.sqlite.org
ALTER TABLE| www.sqlite.org
Before talking about module communication, it is important to emphasize the consequences of chosen module design. Problems that we will face when communicating between modules, how often and how much of communication there will be, depend mostly on decided modules structure ... Assuming that we have modules that depend very little on each other, but sometimes they do need to talk with each other - how can they and when they should?| binaryigor.com
When designing systems and deciding on the architecture, I often hear justifying the use of microservices and other complex solutions because of the predicted performance and scalability needs. Out of curiosity then, let's test the limits of an extremely simple approach, the simplest possible one.| binaryigor.com
When it comes to the infrastructure of a software system, there are some features that are virtually always needed, independently of the project nature, and some that are additional, optional, or useful only in some projects and contexts ... Infrastructure is a crucial component of every software system: what do we need from it?| binaryigor.com
1. Introduction| www.sqlite.org
Small. Fast. Reliable.| www.sqlite.org
Write-Ahead Logging| www.sqlite.org
Modularity is a crucial concept when designing and creating software. Independent of whether our chosen architecture style is to have a single unit of deployment - Monolith or multiple units of deployment - Microservices/Services. It is a quality that should be treated completely independent of how many deployable units of software we choose to have.| binaryigor.com
Nowadays, when we develop web-based app/system it is most likely built as SPA, which is a single page application. We should ask, why have we done that? Why have we switched from multi page applications, where the browser supported all of these functions out of the box, functions that we now need to recreate by writing custom JavaScript code?| binaryigor.com
Where you store your application data has enormous impacts on your entire application. There are implications on the entire stack based on what you decide to...| Epic Web Dev
SQLite Foreign Key Support| www.sqlite.org
STRICT Tables| www.sqlite.org
Run-Time Loadable Extensions| www.sqlite.org
If you were creating a web app from scratch today, what database would you use? Probably the most frequent answer I see to this is Postgres, although there are a wide range of common answers: MySQL, MariaDB, Microsoft SQL Server, MongoDB, etc. Today I want you to consider: what if SQLite would do just fine?| Wesley Aptekar-Cassels
Amazon Compute Service Level Agreement | Amazon Web Services, Inc.
Datatypes In SQLite| www.sqlite.org
1. Using the SQLite Online Backup API| www.sqlite.org
1. Overview| www.sqlite.org
The WITH Clause| www.sqlite.org
The Advantages Of Flexible Typing| www.sqlite.org
Generated Columns| www.sqlite.org
Appropriate Uses For SQLite| www.sqlite.org
1. Overview of FTS5| www.sqlite.org