When it comes to choosing a light, simple and high performance database for your python application, SQLite surely comes to mind. Learning and befriending SQlite has several benefits, and it is a must have tool for every programmer. But have you ever wondered what is happening behind the scenes which makes its storage and retrieval so efficient? How is data being managed internally? Let's explore the SQLite database using python while learning some intriguing underlying principles.
As applied programmers, we are often not concerned with low-level realizations; however, in order to make optimal decisions and select the best database for our application, it is critical to understand how data is being handled under the hood. In this session, we will use python to explore SQLite and build a simple application. Through this session, you will get familiar with the internal workings of the SQLite database. You will learn how SQLite uses b-tree indexing for efficient searches and how data is actually stored on disk. We will also observe how the querying capabilities of SQLite are as powerful as any other SQL database. Along the way, you will understand some of the advantages and trade-offs of using SQLite and when it is the best fit. This would also serve as a stepping stone in making better design decisions and effectively conveying them, even if you lack prior experience in the problem domain.
Speakers: Ria Bhatia