![]() (('cid', None, None, None, None, None, None), It’s all about reading and formatting data.Īs an aside: the cross-platform GUI application “DB browser for SQLite” (whose executable and package name for Linux is sqlitebrowser) is great for fast database exploration.Ĭurs. There’s nothing about writing to a database here. This post is an attempt to collect a high density of basic information that someone looking at an SQL-style database for the first time, and using Python, might find useful early on, based on it being a summary of the things I had to discover in order to make my first simple project work. I do enjoy instant gratification…so it was, without exaggeration, a ridiculous amount of fun. Thanks to great tools written by other people, and succinct and readable documentation for the sqlite3 module, within hours I was looking at images from my filesystem, chosen by their digiKam tags, within a fresh local TiddlyWiki. For this kind of code, reading data and outputting to text files, we don’t really need the flexibility and interactivity of Jupyter or a more conventional IDE, but I’d argue it’s more convenient. If there’s a library for Python to manipulate SQLite databases (which of course there is), then I can play with this in Jupyter Notebook. Then I had an epiphany, because Peter Teuben, in one super-simple Python script, opened his digiKam database and extracted information from it, just like that. I’m sure that would have worked too, but the bit about rewriting tens of thousands of files on my drive was not attractive. I actually thought about getting digiKam to overwrite all my JPEG files to incorporate their metadata, and then using ExifTool to read them. When I initially thought about trying to build a photo album using tags and other metadata that I’d curated in digiKam, the digikam4.db file had such a force field around it that I didn’t really think about extracting data from it. A script by Peter Teuben for accessing digiKam SQLite DB in Python (GitHub).digiKam downloads for Linux, Windows, and Mac ().digiKam photo management software (free and open source!) ().Notes on handling variables in TiddlyWiki.Animation attempt 3: F-Curves are a lot more complicated than I expected.Animation attempt 2 first try with the PitchiPoy rig.Blender fluid simulation: cup of liquid.A basic, basic fluid simulation demo in Blender.Shading sharp edges in Cycles with the Bevel node. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |