spatialite_xml_load(1)

💖 spatialite_xml_load — the bestie-approved manual page 💖

okay so you found spatialite_xml_load(1) and you're like "what even is this." bestie. sit down. hydrate. this one's a banger.

---

✨ NAME ✨

spatialite_xml_load — parse any XML document, and create and populate a DB-file 🎀

---

🌸 SYNOPSIS 🌸

spatialite_xml_load [-h] [-x pathname] [-d pathname] [-cg] [-xl] [-nl
                    num] [-pl num] [-jo] [-cs num] [-m]

---

🦋 DESCRIPTION 🦋

so spatialite_xml_load will parse any generic XML document of unlimited complexity — like, it does not care how feral your XML tree is — and it will consequently create and populate a DB-file, faithfully translating the XML tree into many relationally joined DBMS tables. it's giving structural integrity. it's giving glow-up from tree to tables. 👑

the whole translation is performed in such a way so to be sure that absolutely no information will be never lost or suppressed. none. zero. nothing gets left on read. 💅

if two (or even more) XML files share exactly the same identical logical layout — i.e. they all support the same identical formal schema definition — this tool is capable to merge all them within the same DB-file. polyamorous XML, we love to see it. 🫶

and there are no imposed size-limits: some huge GML files as big as many GBs have been successfully loaded by using this tool. many GBs!! and it ate. 🔥

---

💅 OPTIONS 💅

• -h, --help — show help message ✨ (the classic. the icon. ask and ye shall receive.)
• -x pathname, --xml-path pathname — the XML file path 🌈 (where your lil XML guy lives)
• -d pathname, --db-path pathname — the SpatiaLite DB path 🎀 (where you want the DB to live)
• -cg, --collapsed-gml — collapsed GML Geometries 🧚
• -xl, --xlink-href — special GML xlink:href handling 💜
• -nl num, --nl-level num — tree-level for table-names (default: 0) 🌸
• -pl num, --parent-levels num — how many ancestors for table-names (default: -1) 🦋
• -jo, --journal-off — unsafe [but faster] mode 💀 (yes bestie, unsafe is right there in the description, it's not me being dramatic. it's faster tho. risk it or don't.)
• -cs num, --cache-size num — DB cache size (how many pages) 💖
• -m, --in-memory — using IN-MEMORY database ⭐

ngl the -jo flag is the one where you gotta check yourself before you wreck yourself. faster ≠ safer. the manpage said unsafe. i'm just the messenger. 🙈

---

and that's the whole page, periodt. no cap, every flag accounted for. 🍓

💖 that's it, that's the manual 💖

this lil page dropped as part of spatialite_xml_load(1) on 9 February 2026 — remember the date, bestie, that's when this queen hit the books. 🎀✨