Jump to content

Create community-based / open-source parser library for SQlite DBs etc.


Recommended Posts

When processing data from systems and mobile devices one very often finds file-based databases and data structures. Most popular is SQlite, but there exists others as well (Microsoft EDB, and one could probably even consider plist files to fall into this category). The (table-)structure of these files is application-specific, i.e., varies widely.

My proposal would be to create a template format that allows for two things:

  1. Template-based specification of (SQL) queries. The query results would then be represented as items in Intella (either per line or by SQL 'GROUP')
  2. Definition of mappings of query result fields into custom columns (including type specification, e.g., date, GEO-location coordinates, String, Integer etc.)

Allowing people to share their templates for the various applications (and versions thereof) that they have created templates / parser for, would enable the building of a library.

The advantage would be that otherwise missed information can be added to event time lines and app-specific GEO-location data to be extracted and identified.

  • Like 1
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...