this post was submitted on 22 Jun 2023
10 points (100.0% liked)

Python

6288 readers
3 users here now

Welcome to the Python community on the programming.dev Lemmy instance!

๐Ÿ“… Events

PastNovember 2023

October 2023

July 2023

August 2023

September 2023

๐Ÿ Python project:
๐Ÿ’“ Python Community:
โœจ Python Ecosystem:
๐ŸŒŒ Fediverse
Communities
Projects
Feeds

founded 1 year ago
MODERATORS
10
Data analysis with SQLite and Python (sqlite-tutorial-pycon-2023.readthedocs.io)
submitted 1 year ago by learnbyexample to c/python
 

This is text version of PyCon 2023 tutorial. Video can be found at: https://www.youtube.com/watch?v=5TdIxxBPUSI

you are viewing a single comment's thread
view the rest of the comments
[โ€“] JackbyDev 2 points 1 year ago

I'm a big fan of SQLite. They've added strict tables to get around some of the more odd aspects. With a strict table you can no longer put random text into numeric columns. (It was always able to parse numeric strings to numeric types but would happily store stuff like 'howdy' there too.)