UploadLanguage (EN)Support
BusinessMobileSocial MediaMarketingTechnologyArt & PhotosCareerDesignEducationPresentations & Public SpeakingGovernment & NonprofitHealthcareInternetLawLeadership & ManagementAutomotiveEngineeringSoftwareRecruiting & HRRetailSalesServicesScienceSmall Business & EntrepreneurshipFoodEnvironmentEconomy & FinanceData & AnalyticsInvestor RelationsSportsSpiritualNews & PoliticsTravelSelf ImprovementReal EstateEntertainment & HumorHealth & MedicineDevices & HardwareLifestyle
Upload
Sign in
Nabin Dhakal, profile picture
Uploaded byNabin Dhakal
PPTX, PDF4,912 views

SQLite in Flutter.pptx

SQLite is a lightweight relational database management system used by developers, particularly in Flutter via the sqflite package. It features self-containment, serverlessness, and minimal configuration, and while databases can remain open during application use, they can be closed to release resources. Supported data types include integer, real, text, and blob, while datetime and bool require alternative representations.

Data & Analytics◦
Related topics:
Mobile App Insights•
Downloaded 22 times
1 / 14
2 / 14
Most read
3 / 14
Most read
4 / 14
5 / 14
6 / 14
Most read
7 / 14
8 / 14
9 / 14
10 / 14
11 / 14
12 / 14
13 / 14
14 / 14
SQLite in Flutter Prepared By: Nabin Dhakal
What is SQLite? ● SQLite is a software library that provides a relational database management system. The lite in SQLite means lightweight in terms of setup, database administration, and required resources. ● SQLite has the following noticeable features: self-contained, serverless, zero- configuration, transactional. ● It is not a standalone app; rather, it is a library that software developers embed in their apps. For Flutter: We use this sqflite package to perform SQL queries.
How Server Database works
SQLite Working
Opening a database A SQLite database is saved in the path obtained by getDatabasesPath(). Path from getDatabasesPath() is the default database Android and the documents directory on iOS/MacOS.
Creating Table
Close database Many applications use one database and would never need to close it (it will be closed when the application is terminated). If you want to release resources, you can close the database.
Add Item
Read Item
Edit/Update
Delete
Supported SQLite types ● INTEGER ● REAL ● TEXT ● BLOB
Unsupported types ● DateTime ○ Can store them with int (millisSinceEpoch) or string (iso8601). ● bool is not a supported SQLite type. ○ Use INTEGER and 0 and 1 values.
Thank You!!!