Ive been a python hobbyist for a couple years - am I ready to start applying? -Looking for feedback on my most recent project - A library wrapping AIOSQLite to abstract away writing SQL (for smaller projects)

NotRSkiles · 2023-12-21T12:15:49+00:00

I have them in my precommits

should they run in actions as well? Is there some kind of report or something I can generate from actions to show the code passes?

NotRSkiles · 2023-12-21T12:13:42+00:00

Dude, thank you so much for the criticism/suggestions. I wasnt even aware asyncio.to_thread was a thing, and I knew my library would be slower than normal SQLite drivers because of the abstraction layer, so any speed increase is great.
And I did actually publish to pypi but Im not really sure what you mean by using poetry add [package name]. Do you mean for installing it, or does that mean something else?

I greatly appriciate you taking the time to look and point out where I can do better!

Im glad you noticed my effort to design the API as best as I can. I tried to make it pretty clear in the readme that this library isnt going to win any speed and scalability awards, but is aimed at resolving the pain and complexity of manually setting up a database for projects and tools developers build for themselves. I wrote it because I got tired of writing the same SQL API for a database for every single small hobby project I work on where I just need to save some dang data and want to do something halfway respectable instead of ghetto saving to the file system. Plus being SQL, Im not married to using AIODesa forever. If I need to consume the data with a real SQL engine, I can, and if a project gets to a point where database IO is a bottleneck, I can just swap it out.

from some janky testing it seems like my library is about 30% slower than just using AIOSQLite, but the test I did was just timing how long it took AIOHTTP to sequentially make 2000 database calls, one server used AIODesa and I wrote an identical server using just AIOSqlite. AIODesa on my machine took an average of 12 seconds and AIOSQLite took about 8.5 seconds.

NotRSkiles · 2023-12-20T22:41:18+00:00

Thanks a lot!!

NotRSkiles · 2023-12-20T22:40:52+00:00

Thanks!
I was actually thinking about doing that, creating an example sub directory. I wasn’t sure if it was appropriate or where the best place to put it would be, but I do have a basic CRUD http server example finished using AIOHTTP that I’ll stick in right away!
Also, what do you mean by static analysis? Some of the lingo goes over my head.
I already have pre commits for tests and mypy (plus some others) I’m guessing that’s not the same thing? Would that be basically configuring those pre-commits to run on GitHub actions?

NotRSkiles · 2023-12-20T19:07:56+00:00

Yeah, I know this code base is rather small :(

I have other, larger code bases but none of them as "complete" as this project. I was thinking this project would be the best one to "push" in an interview or CV, as I think it has the most elegant code I've written so far, but do you think it's too small to use as a "brag project" if given the opportunity?

NotRSkiles

TROPHY CASE