Re:The first rule of Microsoft Excel: Don’t tell anyone you’...
by CJefferson on Monday October 24, 2022 @11:29AM
(#33317998)
I would love that to be true, but I'll be honest -- I consider myself a good programmer, but a couple of times I've tried Python + SQLite and ended up just giving up and using csv or JSON.
Is there a nice library which makes it easy to use SQLite in Python even close to as easy as Excel? Or even as easy as Python lists? Anything which requires me to fill my Python code with SQL strings is (in my opinion) disqualified.
Re:The first rule of Microsoft Excel: Don’t tell anyone you’...
by erikcw on Monday October 24, 2022 @01:36PM
(#33319741)
I recently inherited a codebase that uses Pony ORM[0]. Might be worth taking a look if you want your interactions to look as similar to vanilla python expressions as possible.
Is there a nice library which makes it easy to use SQLite in Python even close to as easy as Excel? Or even as easy as Python lists? Anything which requires me to fill my Python code with SQL strings is (in my opinion) disqualified.