sqlacodegen
malten
sqlacodegen | malten | |
---|---|---|
7 | 4 | |
1,761 | 26 | |
- | - | |
7.5 | 5.9 | |
5 days ago | 3 months ago | |
Python | Go | |
GNU General Public License v3.0 or later | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
sqlacodegen
-
Ask HN: Most interesting tech you built for just yourself?
- load the tables
this makes it really easy to bootstrap the entire db from a folder of parquet files for testing with sqlite and then makes it easy to move to prod on postgres/sqlserver etc. Before I go to prod i still have to add constraints and keys and indexes but that doesn't take too long. then we can use something like alembic on the big sqlalchemy tables definition file to do db migrations.
it's kind of like this: https://github.com/agronholm/sqlacodegen but solving an inverse problem.
basically it bootstraps the db and schemas and gets me like 95% of the way there. my quality of life is better with it.
-
Open Source Data Exploration tools/approach?
`sqlacodegen` (https://github.com/agronholm/sqlacodegen) has helped me in the past, plus the ERD diagram tool in dbeaver (https://dbeaver.com/2022/06/30/two-ways-to-use-erd-in-dbeaver/)
-
SQLAlchemy classes from a pre-existing schema
Convert it into a sqlite db and use something like sqlacodegen to generate the needed tables/models?
- Flask SQLAlchemy | Difference between relationship and ForeignKey and which to use when?
-
How to Use Flask-sqlalchemy with Existing MySQL Views
maybe you want to use sqlacodegen to create the classes or tables for you?
-
Change website from manual SQL query building to using Flask-SQLAlchemy
I've not used this myself, but you could use sqlacodegen to generate your SQLAlchemy models from the existing tables. From there you would update your queries to work with the models. If you go this route, I'm curious to know how sqlacodegen works out, so please follow up.
-
Package that compares an SQLAlchemy ORM to a pre-existing database schema?
I'll be using sqlacodegen to initially populate my ORM, but as the live schema changes I need to be able to run a test on my ORM and see where my table objects are no longer up-to-date.
malten
-
Ask HN: What do you do to combat loneliness and isolation?
What kind of community would you like to be a part of?
Do you see yourself as a leader or a follower?
Thank-you for working on Malten:
https://malten.com/
-
Ask HN: Most interesting tech you built for just yourself?
Lots of things. But one I am coming back to is called Malten (https://malten.com). It was essentially a place for me to blackhole my thoughts anonymously rather than putting them on twitter. Recently as I've seen ChatGPT take off it's made me revisit the project and create an integration for it (not yet publicly hosted). Ideally I'd just be able to voice my thoughts to an AI now in a private manner. Let's see.
https://github.com/asim/malten for anyone who wants to run it themselves.
-
Cryptboard.io – Anonymous encrypted web clipboard and chat
I built something similar but it wasn't intended as a clipboard. Mostly for anonymous chat but I personally ended up using it as a clip board. The difference. We don't persist anything on the server side, it's totally in memory and you can create new streams that have shorter ttls.
Website: https://malten.xyz
Source code: https://github.com/asim/malten
What are some alternatives?
vimwiki - Personal Wiki for Vim
hacker-scripts - Based on a true story
iptv-filter
FordACP-AUX - Ford CD changer emulator with AUX playback control using Arduino UNO
carpet_localisation
judo - Simple orchestration & configuration management
exhibitor - Snappy and delightful React component workshop
mathb - Share mathematics on the web with LaTeX and Markdown
Mycodo - An environmental monitoring and regulation system
SaunaControl - Makes a Sauna think it's a web server.
dizquetv - Create live TV channels from your own media. Access the streams using the simulated HDHomerun tuner or the generated M3U URl.
scheme-for-max - Max/MSP external for scripting and live coding Max with s7 Scheme Lisp