config-tables

Yet another attempt to store relational data in codebase in human-readable and git-friendly format.

tables-intellij-plugin

Intellij language plugin supporting features:

• Autoformatting: when | is entered, it is automatically adjusted
• Manual formatting: Ctrl + Shift + L adjusts all columns width
• Autocompletion
• Breadcrumbs
• Folding: rows are grouped by first column value
• Paste from clipboard: if clipboard text contains \t, it is treated as column separator
• Copy As Table context menu action: copy into clipboard in html/tab-separated format, useful for desktop editors (e.g. Excel)

TODO:

• Copy as SQL Select to generate SQL SELECT by header
• Copy as SQL Insert to generate SQL INSERT for selected rows

common (TBD)

Lexer + standalone parser for .table files

TODO:

• Inner references for long cell values
• Multiple tables in one file

config-tables-maven-plugin (TBD)

Maven plugin to generate SQL scripts from set of tables and metadata