DB Browser can successfully import large files into SQLite, but it doesn't allow setting up the format of the fields. All CSV imported fields come in as TEXT fields.
- [Male Instructor] My next attempt is to use DB Browser…for SQLite, with the SQLite library.…This worked better than using a web browser…but I was still unable to select the format…of the fields before import.…All fields were imported as text files.…This may be acceptable for your needs…so I'm going to show how it works.…In the next video, I'll show how to import the CSV file,…plus select the field formats.…DB Browser is an open-source SQLite browser,…written in C++ and available on GitHub.…
The official download page is at…sqlitebrowser.org.…There are installable versions for Macintosh,…for Windows, for Portable Applications,…and for Linux.…As well as the original source code.…Once you've installed DB Browser for SQLite,…importing a dataset is incredibly easy.…First, create a new database.…I can either use the icon in the upper left-hand corner,…or I can go under the File menu and select New Database.…
It asks me what I would like to name this database,…and in this case, I'll call it population.…And, I'm going to put this…
- 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.