๐พ Archived View for bbs.geminispace.org โบ u โบ skyjake โบ 979 captured on 2024-07-09 at 03:20:46. Gemini links have been rewritten to link to archived content
โฌ ๏ธ Previous capture (2024-05-10)
โก๏ธ Next capture (2024-08-18)
-=-=-=-=-=-=-
Re: "Exporting Bubble data in a "raw" format?"
JSON is probably the easiest to parse and process, but the database ones would enable advanced queries out of the box.
(Considered including XML as a humor option, but I really don't want to deal with XML. ๐คข)
๐น๏ธ skyjake [OP/mod, sysop]
2023-05-25 ยท 1 year ago
1. SQLite3 database file
โโโโโโโโโโโโโโโโโโโโโโโโ 15%
2. SQL database dump (text file with SQL)
โโโโโโโโโโโโโโโโโโโโโโโโ 5%
3. JSON file with structured data
โโโโโโโโโโโโโโโโโโโโโโโโ 75%
4. YAML file
โโโโโโโโโโโโโโโโโโโโโโโโ 5%
5. TOML file
โโโโโโโโโโโโโโโโโโโโโโโโ 0%
20 votes were cast.
๐ค alexlehm ยท 2023-05-25 at 08:34:
I am kind of for XML, even though that is not popular anymore, reading a JSON file is not my favorite thing since it uses more quoting than an XML file with UTF8
๐ค alexlehm ยท 2023-05-25 at 08:35:
not sure how xml works in python for an export
๐ต michaelnordmeyer ยท 2023-05-25 at 11:54:
Doesn't Bubble require a MariaDB? I would expect an export to be importable without much effort again. Otherwise I would prefer JSON.
๐น๏ธ skyjake [OP/mod...] ยท 2023-05-25 at 12:22:
Yeah I'm using MariaDB. Importing is not straightforward regardless of the format, because there's a need to remap ID numbers so they don't conflict with existing ones, and one has to check whether the same data is already present in the database to avoid duplication.
๐ค AnoikisNomads ยท 2023-05-25 at 18:52:
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
๐ flipperzero ยท 2023-05-28 at 00:10:
i'd like to contribute and agree w/ some ppl in the comments in reference to XML
๐ Addison ยท 2023-05-28 at 00:54:
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.
๐ฆ jeang3nie ยท 2023-05-28 at 13:30:
@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.
๐น๏ธ skyjake [OP/mod...] ยท 2023-05-29 at 20:37:
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.
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?
๐ฌ skyjake [mod...] ยท 10 comments ยท 2023-05-25 ยท 1 year ago ยท ๐ณ๏ธ