# \#sqlite

**URL:** https://forum.codeselfstudy.com/tag/sqlite/69.md

[Latest](https://forum.codeselfstudy.com/latest.md) · [Categories](https://forum.codeselfstudy.com/categories.md) · [Tags](https://forum.codeselfstudy.com/tags.md)

---

## [Saving JSON in Sqlite3 (Python)](https://forum.codeselfstudy.com/t/saving-json-in-sqlite3-python/2707)

<div class="topic-metadata">

**Author:** [@Josh](https://forum.codeselfstudy.com/u/Josh)\
**Replies:** 1\
**Last updated:** [August 20, 2021, 10:25pm UTC](https://forum.codeselfstudy.com/t/saving-json-in-sqlite3-python/2707 "2021-08-20T22:25:31Z")

</div>

Today I’m working on a Django site that is connected to slqite3 just to sketch out some ideas. I’m using JSONField for dumping some unstructured data into the database. The Django docs mentioned that JSON is supported i…

---

## [Query CSV files with SQL](https://forum.codeselfstudy.com/t/query-csv-files-with-sql/2693)

<div class="topic-metadata">

**Author:** [@Josh](https://forum.codeselfstudy.com/u/Josh)\
**Replies:** 0\
**Last updated:** [July 18, 2021, 10:24pm UTC](https://forum.codeselfstudy.com/t/query-csv-files-with-sql/2693 "2021-07-18T22:24:19Z")

</div>

Basically, just start up sqlite3 in a terminal and type these commands: .mode csv .import filename.csv table\_name .schema table\_name SELECT \* FROM table\_name LIMIT 10; I’ve imported CSV files into Postgres and MariaD…

---

## [Fun with Firefox and sqlite](https://forum.codeselfstudy.com/t/fun-with-firefox-and-sqlite/1551)

<div class="topic-metadata">

**Author:** [@Josh](https://forum.codeselfstudy.com/u/Josh)\
**Replies:** 1\
**Last updated:** [March 23, 2019, 10:00pm UTC](https://forum.codeselfstudy.com/t/fun-with-firefox-and-sqlite/1551 "2019-03-23T22:00:04Z")

</div>

For anyone who wants to practice SQL, Firefox stores a lot of info in sqlite. You can cd into your Firefox profile directory and then load any of the databases in sqlite: content-prefs.sqlite cookies.sqlite favicons.sql…

---

## [How to export data from sqlite to CSV, HTML, text files, and other formats](https://forum.codeselfstudy.com/t/how-to-export-data-from-sqlite-to-csv-html-text-files-and-other-formats/1423)

<div class="topic-metadata">

**Author:** [@Josh](https://forum.codeselfstudy.com/u/Josh)\
**Replies:** 1\
**Last updated:** [March 1, 2019, 4:41pm UTC](https://forum.codeselfstudy.com/t/how-to-export-data-from-sqlite-to-csv-html-text-files-and-other-formats/1423 "2019-03-01T16:41:05Z")

</div>

I learned some quick, useful tips for working with sqlite that people might be interested in. Here’s a quick snippet on how to export query results to CSV format: sqlite\> .mode csv sqlite\> .output my\_data.csv sqlite\> S…