RSSAmplifier

Blog

Refactored scope

ominian.comRSS feed ↗10 posts

Latest posts

linux wine, how to add a DllOverride from the console

wine reg add 'HKEY_CURRENT_USER\Software\Wine\DllOverrides\' /v "*goofy.dll" /d "native,builtin" /f I don t know if the star is needed but the /f is basically force without confirmation. Single quotes are required because of the forward slashes.

Filtering and ordering by date with SQLAlchemy

You want the extract command which is documented here -> https://docs.sqlalchemy.org/en/14/core/sqlelement.html#sqlalchemy.sql.expression.extract The list of options are generally the same regardless of dialect/SQL server so a reference of types can be seen here for SQLite3 https://github.com/sqlalchemy/sqlalchemy/blob/main/lib/sqlalchemy/dialects/sqlite/base.py#L1229 A common base extract type…

Process finished with exit code -1073740791 (0xC0000409) – PySide2 & PyQT5

I am working on a WinAmp clone called PySongMan(ager) and kept getting a stackoverflow bug. Drilling my code downward, simplifying it as I went, I got a script like: Which kept throwing a 0x0 409 error which is a stack overflow error. Finally, somewhat by accident, I figured out my mistake. The good code looks like: [ ]

Flask class routing example

I ve written several web frameworks in my life and while I don t have the desire to keep up with current technology trends, I still like to dabble. book.py is the best example of what this does versus page.py which shows more advanced use cases.

Portable/reusable flask app skeleton

I have a lot of Flask apps running in the background on my home server to do various tasks (home wiki, some CRM stuff, etc) and I end up making the same structure over and over so I figured I would simplify the process and make a repo with just the skeleton of an app. [ ]

Data migration with SQLAlchemy and Alembic

I needed to optimize an unruly table filled with floats but I also didn t want to lose my data. Unfortunately the documentation on the alembic website doesn t mention anything or give any hints on how to do a data migration versus just a schema migration. Fortunately I was able to run a symbolic debugger against [ ]

Non-blocking python subprocess

I am working on a pet project to compress a terabyte of video into a slimmer format. While I have been able to automate working with ffmpeg, I didn t like the fact that I couldn t follow along with the subprocess running ffmpeg. I tried a few different ideas of how to watch ffmpeg but also [ ]

Slimmed down twisted compatible reloader script

Working on txweb again, I decided to give it a real flask/django style reloader script. Directly inspired by a href= https://blog.elsdoerfer.name/2010/03/09/twisted-twistd-autoreload/ >this /a> blog post I decided to cut down on the extraneous bits and also change what files it watched. https://gist.github.com/devdave/05de2ed2fa2aa0a09ba931db36314e3e

DCDB post-mortem

I went into writing DCDB with little or no plan besides building it around dataclasses. The result is a bit rough and precarious. That said I think I am going to progress onward with making a DCDB2 library that will change a few things. The first would be to completely separate the DCDB tables themselves [ ]

Unit-testing sqlalchemy with pytest

Inside of my tests directory I added a db directory. Given the logic above, it spawns an entire new database for each test function so that I can go back and verify my database. For someone elses code, you just need to swap out sal2 with the module name holding your sqlalchemy base and associated [ ]