Skip to content

  • Projects
  • Groups
  • Snippets
  • Help
    • Loading...
    • Help
    • Submit feedback
    • Contribute to GitLab
  • Sign in
haskell-gargantext
haskell-gargantext
  • Project
    • Project
    • Details
    • Activity
    • Releases
    • Cycle Analytics
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
    • Charts
  • Issues 160
    • Issues 160
    • List
    • Board
    • Labels
    • Milestones
  • Merge Requests 8
    • Merge Requests 8
  • CI / CD
    • CI / CD
    • Pipelines
    • Jobs
    • Schedules
    • Charts
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Members
    • Members
  • Collapse sidebar
  • Activity
  • Graph
  • Charts
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
  • gargantext
  • haskell-gargantexthaskell-gargantext
  • Issues
  • #362

Closed
Open
Opened Jul 01, 2024 by Przemyslaw Kaminski@cgenie
  • Report abuse
  • New issue
Report abuse New issue

Import/export in SQLite format

This allows us to import and export multiple data at the same time: dashboard (files), docs, terms, etc.

And I think it doesn't require much rewrite since we have the base table in CSV/TSV already, we just need to pack it into sqlite.

The import could support "partial" data, i.e. if docs table is there, import it, if not, just skip.

We could even export whole corpus with sqlite.

Possibilities are numerous and the format is very versatile. With sqlitebrowser or dbeaver it's also easily inspectable and editable.

https://www.sqlite.org/appfileformat.html

https://www.sqlite.org/aff_short.html

Edited Feb 19, 2025 by Przemyslaw Kaminski
Assignee
Assign to
None
Milestone
None
Assign milestone
Time tracking
None
Due date
None
1
Labels
To deploy
Assign labels
  • View project labels
Reference: gargantext/haskell-gargantext#362