[X3D-Ecosystem] SAI for SQLite or ORM

[John Carlson]

Note that I am already storing JSON in a SQLite database with 3 tables, I
just don’t have versioning or dirtied fields yet.   I also don’t have a way
to transform the database back into X3D JSON, I currently export a D3.js
JSON format for graphs/networks (for a visual encoding).   Let me know if
you are interested in seeing the X3D D3.js JSON encoding.   I have a
database dump service, here:
https://coderextreme.net/productconfig/server.php Here’s the SQLite
database:
https://coderextreme.net/productconfig/EntityRelationship.sqlite3

I had hoped to include versioning without additional tables.  We will see.

On Wed, Apr 2, 2025 at 3:24 PM John Carlson <yottzumm at gmail.com> wrote:

> I am thinking I want to add a database flavor of x3d.py and X3DJSAIL, so
> that i can load and save scenes as a relational database, not as a complete
> document, but broken up into 3 tables (entity, entity type, and
> relationship). or hundreds of tables.   I would also like to save dirtied
> fields and receive modifications in the scene from the database or a peer.
>
> Also, there’s going to be an aspect of versioning, assuming that the
> database won’t be garbage collected.
>
> Aaron, I’m copying you because you’ve extended exports in x3d.py and you
> might have some ideas.
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://web3d.org/pipermail/x3d-ecosystem_web3d.org/attachments/20250402/3d4cca07/attachment.html>