search

TIDES-transit / TIDES

Transit ITS Data Exchange Specification for historical transit operations data
https://tides-transit.github.io/TIDES
Apache License 2.0
25 stars 4 forks source link

🚀💻 Additional Serialization Formats #219

Open e-lo opened 6 months ago

e-lo commented 6 months ago

Describe the feature you want and how it meets your needs or solves a problem

As a TIDES developer dealing with millions of rows, I want to be able to store data in a format that is easily queryable via an index (or several of them) so that it doesn't take forever to access my data.

As a TIDES developer at an agency that has an enterprise data storage system in (name that format), I want to be able to store my TIDES data in that same system so that I don't have to maintain multiple systems.

Describe the solution you'd like

This could be dealt with a few ways:

  1. TIDES could be explicitly serialization format agnostic.
  2. TIDES could be explicitly inclusive of data serialization formats that can be directly exported to csv in TIDES format
  3. TIDES could explicitly support additional serialization formats.

Describe alternatives you've considered

Additional context

mpaine-act commented 6 months ago

Frictionless Data supports many serialization data formats.

https://framework.frictionlessdata.io/docs/formats/sql.html