# Working with SQLite using Go and Python

DevFeed: [Working with SQLite using Go and Python](<https://devfeed.tech/articles/working-with-sqlite-using-go-and-python-22173.md>)

Original publisher: [Read original article](<https://www.ardanlabs.com/blog/2020/11/working-with-sqlite-using-go-python.html>)

Published: 2020-11-30T00:00:00Z

Content type: tutorial

Language: en

Sources: [William Kennedy](<https://devfeed.tech/sources/william-kennedy.md>)

Topics: [SQLite](<https://devfeed.tech/topics/sqlite.md>), [Go Language](<https://devfeed.tech/topics/go-language.md>), [Python](<https://devfeed.tech/topics/python.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [pandas](<https://devfeed.tech/topics/pandas.md>), [HTTP](<https://devfeed.tech/topics/http.md>)

Tags: [ardan-labs](<https://devfeed.tech/tags/ardan-labs.md>), [blog](<https://devfeed.tech/tags/blog.md>), [code](<https://devfeed.tech/tags/code.md>), [database](<https://devfeed.tech/tags/database.md>), [go](<https://devfeed.tech/tags/go.md>), [go-programming](<https://devfeed.tech/tags/go-programming.md>), [golang](<https://devfeed.tech/tags/golang.md>), [http](<https://devfeed.tech/tags/http.md>), [pandas](<https://devfeed.tech/tags/pandas.md>), [programming](<https://devfeed.tech/tags/programming.md>), [python](<https://devfeed.tech/tags/python.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sqlite](<https://devfeed.tech/tags/sqlite.md>)

## AI overview

A tutorial on using SQLite with Go and Python. It explains SQLite, transactions, schemas, and SQL, then builds a Go HTTP server that stores trade notifications in SQLite and a Python program that processes the data.

## Source excerpt

Introduction I prefer to use relational (SQL) databases in general since they provide several features that are very useful when working with data. SQLite is a great choice since the database is a single file, which makes it easier to share data. Even though it's a single file, SQLite can handle up to 281 terabytes of data. SQLite also comes with a command line client called sqlite3 which is great for quick prototyping.