jan-martinek / kiskbase Goto Github PK

(primarily to make it easy to start using the app)

It would be nice to have a place to play with SQL expressions and see the results immediately.

possibly just https://github.com/orthes/medium-editor-insert-plugin

Some problems are already visible & buggy (e.g. hashtag detection in links' anchors)

It would be nice to have a basic support for altering db tables – to be able

• to create a new table (automatically created with autoincremented id)
• to add a column to existing table (int, varchar, text, enum)
• to add an option to enum field
• to hide a column (via column comments?)
  • I'd refrain from deletions
  • this would require removing those columns from query results in entries (something like this
    create temporary table tempselect * fromexample_course;
show full columns from temp;
    works for multiple tables)

It just saves every version now.

Possible syntax: ?13, [13], KB13, @13, #13

Possibility of writing something like "Namespace: Name" as a header to create a tree structure.

Worth considering:

• one level or multilevel tree (simplicity works both ways)
• notation – colon seems to be good, as the names are questions

Use foreign keys to join tables in table functionality