Home
About
SK blog
Rapture in Everything
Posts tagged "python"
2020 Apr 18
2020 Apr 18
csv-to-sqlite 2.1 - script support, encodings and brackets
Version 2.1 of csv-to-sqlite was just released. There are a few new things, suggested in GitHub issues: you can now specify that you do not want brackets around your column names, you can specify the encoding your files (the default still is UTF-8) and it's now easier to use csv-to-sqlite in scripts. If you wish to do that, simply install it as a dependency: pip install csv-to-sqliteAs an aside: if you're not using Pipenv yet, take a look at it. It's great.Then import it and call write_csv(). import csv_to_sqlite # all the usual options are supported...
tools
python
csv-to-sqlite
2019 Apr 24
2019 Apr 24
csv-to-sqlite 2.0 - memory improvements
My csv-to-sqlite script got some updates - most importantly it now requires far less memory....
tools
python
open source
2019 Mar 28
2019 Mar 28
PyCon SK 2019
Last time I've written about PyCon was in in 2016, when it came to Slovakia for the first time. I have attended every year since, and if I was impressed then, I have to say each subsequent year was better than the one before it. It always covers a bevy of topics, from Python to machine learning, various projects people are working on, best practices in architecture, social and societal impacts of technology (people from slovensko.digital always make an appearance) and more. I especially appreciate the tracks about teaching and education, since that topic interests me a lot and,...
python
tech
conference
2016 May 04
2016 May 04
csv-to-sqlite - copying from CSV files to a SQLite database
csv-to-sqlite is a command line tool that **takes CSV files and dumps their contents into a SQLite database**. The basic gist: for each file, the script creates a database table with the same name, tries to guess the data type, then copies all the data into the database....
tools
python
open source
2016 Mar 15
2016 Mar 15
PyCon SK 2016
The famous PyCon came to Slovakia for the first time. Quite frankly: I’m impressed. For those who don’t know: PyCon means Python Conference, and it’s meant for anyone interested in the programming language. I can’t say I have much experience with community-organized dev events, but the organizers clearly did their homework. I’m not exactly an avid tweeter, but I couldn’t resist: It was obvious immediately after entering #PyConSK that I hadn't seen this many nerds in one place in quite a while. I've missed it. — zblesk (@zblesk) March 11, 2016 That was prompted by...
python
tech
conference
Older