git/list[1] front-page[2] threads[3] people[4] search[5] about
 

Re: How do you best store structured data in git repositories?

From
jamesmikedupont@googlemail.com <jamesmikedupont@googlemail.com>
Date
Dec 4, 2009, 08:00 UTC
Message-ID
<ee9cc730912040000u76337d40n4fd8e0eda7ca6bb4@mail.gmail.com>
In-Reply-To
<32541b130912031745i60dc918dk3e510ef1a3b28526@mail.gmail.com>
 On Thu, Dec 3, 2009 at 7:14 PM, David Aguilar <davvid@gmail.com> wrote:
 > JSON's not too bad for data structures and is known to
 > be friendly to XML expats.
 >
 > http://json.org/
I am currently working on two projects in this direction :
1. mediawiki on git, using mediawiki markup files. I apologise that I
have not made progress on that lately, because I have had inspiration
on my older project
2. the gcc rdf introspector, storage of the files in rdf. It is
working now with a mysql database, using the librdf mysql driver, and
running on a catalyst framework using jquery/jstree on the front end.

None of those formats are perfect, the sizing of the files is important. I am returning individual nodes in json on the cataylst server and that works to deliver the AST nodes from the compiler to the jstree front end. But these fetches to the front end should be longer and contain direct components of the fetched node. I think that a cluster of nodes should be pulled together to make a more optimal system.

here is just my two cents:

if you are using a distributed git data repository as your central repository, then think about a database page. Imagine that you would have pages of data being retrieved and compared.

Would it not make sense to split your pages something that would be swapped into memory directly, or with very little parsing, and then used?

So, in effect, you would design the sizing of the pages and the page contents around the usage model, since git is a low level storage system.

I dont know what would be available if some database manager system like mysql or postgres could be taught to store table pages in git.

just some ideas,
mike
Previous: Avery PennarunNext: Sebastian Setzer
Message 5 of 7 in “How do you best store structured data in git repositories?”
  1. Sebastian SetzerDec 2, 2009
  2. Avery PennarunDec 2, 2009
  3. David AguilarDec 4, 2009
  4. Avery PennarunDec 4, 2009
  5. jamesmikedupont@googlemail.comDec 4, 2009
  6. Sebastian SetzerDec 7, 2009
  7. David AguilarDec 8, 2009

Read the whole thread, see it on lore, or plain text.

$ cat FOOTERMessages come from the public archive at lore.kernel.org/git, fetched every hour. The front page is chosen and written each morning by an AI editor and can be wrong; the threads themselves are the record. About and API. For agents: an MCP server at https://gitlist.dev/mcp, and any thread, story or person page as Markdown by adding .md to its URL (or sending Accept: text/markdown). Details in /llms.txt.