sqlacodegen
sqlacodegen | carpet_localisation | |
---|---|---|
7 | 2 | |
1,736 | 3 | |
- | - | |
7.7 | 0.0 | |
5 days ago | over 2 years ago | |
Python | Jupyter Notebook | |
GNU General Public License v3.0 or later | OSI Approved |
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.
carpet_localisation
-
Ask HN: Most interesting tech you built for just yourself?
I made a robot location tracking system specifically for use on the carpet at my office.
The carpet was an arrangement of 4 particular colors tiled in squares, so I manually made a carpet map (a few hours in excel!), wrote a carpet color classifier to run from under-robot camera data, then integrated with a particle filter for location tracking. Write up is here:
https://github.com/tim-fan/carpet_localisation/wiki/Carpet-L...
I wrote it only ever expecting usage in this particular office, but if anyone has a similar carpet and a robot that needs localizing, please reach out!
-
Ask HN: What Are You Working On?
ROS package with gazebo simulation : https://github.com/tim-fan/carpet_localisation_ros
What are some alternatives?
vimwiki - Personal Wiki for Vim
StravaInky - Displaying Strava stats on a Inky Impressions e-ink display
iptv-filter
SaunaControl - Makes a Sauna think it's a web server.
exhibitor - Snappy and delightful React component workshop
feedpaper - Exploring a calmer way to read information feeds
Mycodo - An environmental monitoring and regulation system
Orchestroller - Use an Xbox controller to play classic SNES samples
dizquetv - Create live TV channels from your own media. Access the streams using the simulated HDHomerun tuner or the generated M3U URl.
cardboard - 💽 Cloud storage + management platform for analog video files
HTFanControl - 4D Theater Wind Effect - DIY Home Theater Project
requiz - Alternative Quizlet frontend - just switch the quizlet.com in a URL with requiz.net