jsyang/foldingbikecollection.com

Code to generate pages of the foldingbikecollection.com site

foldingbikecollection.com

Code to generate pages of the foldingbikecollection.com site

• Steal blurbs for Why here:
  • https://justyna.typepad.com/bike_chicago/folding_bikes/

Helpful notes

• sql.js for in-browser read-only queries to reduce load
• SQLite for web apps
  • USE TRANSACTIONS FOR WRITES
  • Queue transactions up
  • Then flush them periodically (COMMIT)
  • Use write ahead logging (WAL) with statement PRAGMA journal_mode=WAL;

better-sqlite3

• better-sqlite3 help notes
• api reference

Setting up for yarn viz

• SchemaSpy download: https://github.com/schemaspy/schemaspy/releases
• SQLite JDBC driver: https://bitbucket.org/xerial/sqlite-jdbc/downloads