h3rald / litestore Goto Github PK

Allow file uploading by browsing local filesystem and/or drag & drop.

Implement methods to manage datastores.

?modified-before=<timestamp>
?modified-after=<timestamp>
?created-before=<timestamp>
?created-after=<timestamp>

Implement a simple (and thread-safe) logger.

Some command line options have no effect.

Provide complete documentation, both as standalone document and integrated in the app.

Move all custom fields out of the nimble file.

Error: unhandled exception: Invalid field: appame [ENimble]

As of the latest minor version:

• it is no longer possible to sort by id, created, modified.
• an error is returned when retrieving a single element, in some cases

Implement support for searching text files within the app.

Running litestore -d:dir delete deletes documents and tags but not searchdata contents. Additionally, the total documents count is not updated.

/tags/?like=$format*

Implement document management (simple key/value store and simple queries)

If a document is an image, display it instead of showing its base64-encoded contents.

Man, what a gem of a project.

Thank you for open sourcing this.

😻

At present, it is not possible to edit the document ID in the upload dialog after it is set for the first time, and it is not possible to "cancel" an upload (clearing all fields of the form).

• Tag lists do not wrap.
• Insufficient margin for content.

When creating a new document, auto-set the language of the editor based on the document ID.

Provide the possibility to add/remove non-system tags from a document.

Search does not work if a folder is specified (ambiguous column: id).

Make sure that all requests provide a feedback to the user in case of errors (e.g. via a flash message).

Override some of marked rendering methods to support Discount class blocks and pseudo-protocols.

By default, when running LiteStore with -d option specified, the directory contents should be served by LiteStore web server.

• Add default_page column to info table
• Increment db Schema version
• Add --default:<doc_id> option to set/unset default page
• Add logic to open default document in browser at startup if default is set

Is it possible to use Litestore as a prototype-DB for a Nim web-framework?

I am currently tinkering with Jester and I would like to add/edit/delete JSON (via the Jester-backend).

So instead of having Litestore be a client-facing datastore (as the documentation shows), I would instead like to use litestore in this manner:

Client <-> Jester-REST-API <-> litestore-DB

Is this possible to achieve?

If yes, are you able to share a small example in the readme file? It may help a lot of people that want to prototype small webapps with Jester+Litestore

Thanks!

?sort=-modified~created

• Add paginator
• Use panels instead of tables

Implement a CLI for LiteStore

**, --, __, etc.

The executable defaults to data.db no matter what the -s or --store value is
Is the same for both the x86 and x64 builds.
Version 1.0.1

There are some mistakes/typos in titles when copying and pasting from info page.

Steps to reproduce the bug:

1. Add two tags to a document
2. Remove both tags

A 400 - Bad Request "Index out of bounds" error is returned.

• Keep track of datastore version
• Cache document count

Implement tagging/untagging operatins

Implement methods to:

• recursively "pack" the contents of a directory into a data store
• "unpack" a previously-packed directory (removing also the corresponding contents from the datastore)

Implement a built-in web server for LiteStore and expose all the most common operations via a REST API.

LiteStore should support Flickr-style machine tags.

Examples:

  http://localhost:9500/docs?sys.type=text;*.subtype=*;
  http://localhost:9500/docs?sys.format=binary;myapp.something=%22something%20else%22

• Sort by relevance
• Retrieve highligting

Access-Control-Allow-Origin: *

• Access-Control-Allow-Origin is not set correctly.
• Access-Control-Allow-Headers does not allow authorization.

Was wondering if you'd be ok with a PR that cleaned up whitespace in *.nim?

Thanks!

Enable LiteStore to "mount" a local directory and keep it mirrored both on the database and the filesystem.

Implement fulltext search query methods for documents

Display data in the Info page in a more user-friendly way.

Apply the following changes to improve performance for large (> 1GB) SQLite database.

Modify compilation flags

   {.passC: "-DSQLITE_ENABLE_FTS4=1 -DSQLITE_DEFAULT_LOCKING_MODE=1".}

Configure PRAGMAs when opening the database

   discard result.db.tryExec("PRAGMA locking_mode = exclusive;".sql)
   discard result.db.tryExec("PRAGMA journal_mode = WAL;".sql)
   discard result.db.tryExec("PRAGMA page_size = 4096;".sql)
   discard result.db.tryExec("PRAGMA cache_size = 10000;".sql)
   discard result.db.tryExec("PRAGMA synchronous = NORMAL;".sql)

Execute commands on data store via command line

• vacuum
• optimize/rebuild

Import optimizations

1. DROP INDEX for docid
2. Import data
3. CREATE INDEX for docid
4. OPTIMIZE
5. VACUUM

Additional indexes

     CREATE INDEX tags_document_id ON tags(document_id);
     CREATE INDEX tags_tag_id ON tags(tag_id);
     CREATE INDEX documents_id ON documents(id);