Lunrtick
Joined 6 years ago
Karma
49
Submissions
32
Member since
Apr 5
Recent submissions
Comment · 2 years ago
That's a good point! I suppose in Python that could be a guard in the column definition function.
Comment · 2 years ago
They could also have done default=uuid.uuid4 to have a new id each time, or default=lambda : str(uuid.uuid4()). It's not really related to whether or not it's a database default.
It seems quite unfair to place the blame on SQLAlchemy here, or even Python.
Even a statically typed language wouldn't prevent this kind of issue - the author of the code is the only person who can decide when they mean "use this exact string each time" or "use this function to give me a new string each time".
I suppose a column description API could follow the dataclass style definition, with different argument names for default and default_func. That would (I think) prevent this from happening.
Comment · 2 years ago
That would be nice. I've been using Keepass2android for years now though, and it's been really great!
Comment · 3 years ago
I've tried a bunch, but many of the prettier ones don't have Linux versions. I've been using DBeaver (https://dbeaver.io/) for years now though - it's occasionally a little rough around the edges, but overall it's really amazing!
It uses jdbc drivers for database support, so it can handle basically anything.
Comment · 4 years ago
I've been using Postale for a for a few years now, it's been very solid and the pricing is reasonable!
Comment · 4 years ago
The author of SQLAlchemy (which recently released great async support) wrote a great post about how async can actually lead to a small decrease in performance compared to the older threading model, at least for db related functions in a web backend context. [1]
For websockets or lots of network calls, you can't really beat async though.
[1] https://techspot.zzzeek.org/2015/02/15/asynchronous-python-a...
Comment · 4 years ago
Have you tried Django Ninja? https://django-ninja.rest-framework.com
It's most of FastAPI (auto docs generation, great Pydantic integration, etc) but for Django.
Comment · 4 years ago
May I ask what context you use it in? It looks like it strikes the right balance between simplicity and descriptive power - kinda like a statically typed python.
The web side of it seems rather different from a Flask or FastAPI setup, and it obviously doesn't have SQLAlchemy (which I really like). Do you have any recommendations on that front?
Comment · 5 years ago
Seveneves by Neal Stephenson. Excellently written like all his books, but the complete loss of hope (realistic as it was) was far too depressing - I like my SciFi as escapist as possible
Comment · 5 years ago
That sounds extremely frustrating. Maybe a good workaround is a custom domain?
Comment · 5 years ago
I'm currently loving FastAPI and Sqlalchemy, but I have been looking for TypeScript equivalents - TS is such a nice language to work with.
What libraries are you using? I haven't found anything that seems to match the easy OpenAPI schema generation and validation that FastAPI and Pydantic provide.
Comment · 5 years ago
DigitalOcean does offer Timescaledb in the their managed postgres offering AFAIK, along with quite a few other extensions (PostGIS etc)
Comment · 5 years ago
My occasional accidental Google search for programming related things has been filled with spammy sites - I wouldn't quite describe them as "no content", but there really wasn't much of it. DDG isn't really better, but I definitely wouldn't say it's worse, at least for my searches.