💾 Archived View for bbs.geminispace.org › u › AnoikisNomads › 1021 captured on 2023-07-22 at 18:22:33. Gemini links have been rewritten to link to archived content
-=-=-=-=-=-=-
Re: "Exporting Bubble data in a "raw" format?"
JSON is fine. It is easy enough to reimport well-structured JSON into a relational database if needed -- or use import raw JSON into a RDBMS and use JSON_* SQL functions directly.
seriously though, I believe that is a usecase you do not optimize for
2023-05-25 · 8 weeks ago
1. SQLite3 database file
████▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁ 16%
2. SQL database dump (text file with SQL)
▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁ 0%
3. JSON file with structured data
███████████████████▁▁▁▁▁ 79%
4. YAML file
█▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁ 5%
5. TOML file
▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁▁ 0%
19 votes were cast.
i'd like to contribute and agree w/ some ppl in the comments in reference to XML
2023-05-28 · 8 weeks ago
JSON (and to a lesser extent CSV) is pretty much ubiquitous for this kind of thing in my opinion, and is use-case-agnostic (which SQL is not)
I'm in favor of JSON for the sake of its simplicity and universality.
@Addison I agree, and it's the same reasoning I had for voting `json`. Either json or csv are both easy to parse in any language so making sense of the raw data outside the context of a database is possible.
I think the results are starting to look pretty clear. I will do a JSON export and consider an SQLite file as a secondary option.
2023-05-29 · 8 weeks ago
Exporting Bubble data in a "raw" format? — In addition to the human-readable Gempub archives, I've been considering various options for exporting your data out of Bubble in case someone wants to get their data out for other purposes. For example, one might want to use their posts as a basis for a personal capsule, or run some scripts to post-process them somehow. What would be the best "raw" machine-readable export format? Any good alternatives not listed?