Comments (4)
You could also run this in a Github action which would trigger a redeploy and store it in the repo. I have been playing around with storing the db on a remix server with Simple Transit Site. I am persisting the db in s3 using a cron job and pulling it down in the Dockerfile and then running the Gtfs update.
I know that there are other options like Litestream, but it does not work with the DigitalOcean platform for some reason.
https://github.com/ioTransit/simple-transit-site/tree/main
from node-gtfs.
@laem You are correct - I build the db locally and then check it into the git repo along with the code for the project and then deploy (via git) to Vercel. So it is all bundled together. Whenever there is an update to the GTFS, I make a new commit to the repo.
That might not work well with very large agencies GTFS or for GTFS that changes very frequently.
from node-gtfs.
I'd like to add support for more databases other than sqlite3, perhaps using Drizzle or Prisma.
I have had success deploying to Vercel by including sqlite generated from node-gtfs as part of the repo in a read-only fashion (following the baked-data pattern https://simonwillison.net/2021/Jul/28/baked-data/ )
from node-gtfs.
Thanks ! So if I understand well, you have a server (or your local computer) where you're building your db, and then on Vercel you're downloading (through git or S3) a prepared version of your DB to be consumed without any writes.
In other words, no importGTFS
on the edge platform ?
from node-gtfs.
Related Issues (20)
- Can I use the command line for query operations? HOT 6
- GTFS-R TripDescriptor HOT 5
- Working with Docker Database locked HOT 4
- Dropping/Clearing database HOT 1
- Deployment on errors HOT 5
- Invalid default csv parser option "relax" in import script. HOT 2
- Performance improvements HOT 4
- Possible performance improvement: DuckDB HOT 3
- Changing internal maxInsertVariables has significant impact on total import time HOT 4
- Agency_id defined in agency.txt but not in routes.txt results in invalid GTFS export HOT 1
- Not running with Deno HOT 7
- occupancyStatus from vehicle_positions HOT 6
- Persistent trip_updates when running getStopTimeUpdates HOT 13
- Deleting the db to avoid id collisions HOT 3
- Propagate RT delays to missing stop_sequences HOT 6
- updateGtfsRealtime doesn't work if one URL is down HOT 2
- Disable clean stale GTFS-Realtime data by default HOT 10
- Zip File Containing Multiple GTFS Static Zip Files HOT 3
- import.js throws an error because attribution_id is missing but the spec says it's optional HOT 3
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from node-gtfs.