SQLite is not multi-user and relies on file system locking to prevent conflicting writes. Because it cannot handle concurrent writes, it is not a good choice for write-intensive applications such as rapid data logging. Also, because it is not client/server, it is a poor choice for multi-user applications such as servers.
- [Man] SQLite does have some disadvantages.…There are some SQL features omitted.…For example, right join, for-each triggers, drop column,…alter column, and add constraint.…SQLite does not support multiple-client concurrency,…users, and user permissions outside of what is provided…by the operating system.…SQLite does not prevent you from putting the wrong data type…into a field.…
For example, SQLite allows you to put strings…into integer fields.…With these pros and cons in mind, there are times when…SQLite is a good solution and other times when it isn't.…Here are some rules of thumb when not to use SQLite.…If you're trying to use multiple clients all accessing…the same data, this may potentially cause a data crash.…Frequent writes to the database are going to be slow.…
Concurrent writes to the database…may also cause a database crash.…Access over the network is not advised, it's extremely slow.…And very large datasets will also cause SQLite to seize up.…SQLite has a maximum of 140 terabytes.…If you're looking to store a small amount of data…
- Strengths and weaknesses of SQLite
- Creating a database
- Joining data sets
- Calculations with SQLite and Python
- Searching a database
- Subqueries and queries in SQLite
- CRUD operations in SQLite with R
Skill Level Intermediate
1. SQLite in Five Minutes
2. Create a Database
3. Join Two Datasets
4. Search a Database
5. Create, Read, Update, and Delete Operations
6. Averages and Calculations
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.