Skip to content

Haskell library that creates SQL databases from org-mode data

License

Notifications You must be signed in to change notification settings

rzetterberg/orgmode-sql

Repository files navigation

orgmode-sql

Travis status

A Haskell library that takes org-mode documents parsed with orgmode-parse, converts the data into a relational model and insert it into a SQL database (SQLite, PostgreSQL or MySQL)

The idea is to create a foundation that can be used to build interesting applications that use org-mode data. SQL was chosen because it's ideal for this kind of data and because it leaves the door open for use in other languages and tools.

Initially only SQLite will be tested and supported, but the plan is to be able to also use PostgreSQL and MySQL.

The current status of the first 1.0 release of this library is:

╭──────────────────────╮ ╭──────────────────────╮
│ Parsing              │ │ Database creation    │
│┌────────────────────┐│ │┌────────────────────┐│
││████████████████████││ ││████████████████████││
│└────────────────────┘│ │└────────────────────┘│
│                 100% │ │                 100% │
╰──────────────────────╯ ╰──────────────────────╯
╭──────────────────────╮ ╭──────────────────────╮
│ Common queries       │ │ Exporting            │
│┌────────────────────┐│ │┌────────────────────┐│
││████████████████████││ ││██████████████████  ││
│└────────────────────┘│ │└────────────────────┘│
│                 100% │ │                  90% │
╰──────────────────────╯ ╰──────────────────────╯
╭──────────────────────╮ ╭──────────────────────╮
│ Complex queries      │ │ Shitty ASCII-art     │
│┌────────────────────┐│ │┌────────────────────┐│
││████████████        ││ ││██████████████      ││
│└────────────────────┘│ │└────────────────────┘│
│                  60% │ │                70%   │
╰──────────────────────╯ ╰──────────────────────╯

When the feature status is 100% a 1.0 release will be created with a stable API. After that semantic versioning will be used.

Specification

Uses the Stackage LTS 3.7 package set to provide a stable dependecy tree.

Uses the persistent package for database operations.

Basically this library is not very impressive, it only serves as glue between other libraries that are impressive.

About

Haskell library that creates SQL databases from org-mode data

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published