TO DO List¶
LIBRE already has an extensive set of functionality but there are things and functionality everybody would like to see added, here is a list of those things.
Database sources¶
- Add DB Source support
- Pony ORM
Datastore¶
- Multiple DataStores support
- File-based DataStore
- DataStore router support
- DjangoStorage DataStore support
Documentation¶
- Getting started
- Add better sample source files
- Examples using existing public data
Filebased sources¶
- Add compressed file support
- Skip blank lines?
- Switch from column widths to column ranges
- Toggable auto update via inotify, polling or python-watchdog
- Add internal support for open ranges for rows “10-“
- Migrate Spreadsheet regex import and skip solution to other filebased sources
- Add row number exclusion support during import
General¶
- Add Relationship support
- Specify number of versions to keep, deleting old ones
- Add instructions to sources, per source type
- Add row number exclusion support during import
- Stored JSON data index support
- JSON source descriptor export and import
- Rename ‘timestamp’ to ‘version’ and allow user defined version strings
- Data translation
- Remap JSON names
- Password reset view
Renderes¶
- Add D3 renderer
- Add Google Maps renderer
Job processing¶
- Add Celery support or subprocess
LQL¶
- Views support
- Dataset Namespaces
- Result reformating to allow including metadata in HTTP response
- { “result”: {“a”: 1, “b”: 2}, “count”: 2, “limit”: 100, “response_time”: “100ms”}
- LQL based pagination (size and page number) (Andres Colón)
- Expand the _fields directive to support dot and index notations
- Sorting
- _order=<field name>,<field name>
- sort(+field_name,-field_name)
- Ascending (field name)
- Descending (-field name)
- Add regex support
- _match
- Annotations
- Limiting
- _limit=<soft limit of elements>
- Skipping results
- _skip=<number of elements>
- _first
- _last
- _one
- Return error if more than one
- Combined
- _limit=(count, start, maxCount)
- Joins between datasets
- _join=<data set name>,<join type>,<current set field>__<foreign set field>,<current set field>__<foreign set field>
- _relation=(field, subquery)
- Field selection
- _select=(field_name, field_name)
- _distinct
- _excludes
Output¶
- Add support for generating output formats other than JSON
- Shapefiles
- GeoJSON - DONE
- CSV
- Excel
- XML - DONE
- NIEM
- Fixed width
Web services sources¶
- Add caching support to WS Sources
- TTL support
Unsorted¶
- Empty but valid queries should return HTTP404 or HTTP200 with ‘{“status”: “Not found”}’
- Show required argument for WS
- Result count
- Fix upload_to
- Calculate geometries area, size, lenghts in pin template
- Delete stored source files when a source is deleted
- Delete stored source files when a new file is uploaded
- Fix JsonField not returning dates or times only datetimes
- Move _fields parsing to allow being parsed on get_one method
- Optimize AND type join
- Use islice
- Data store browser
- Add support for item-based and result-based evaluation
- Add support for JSON Pointer
- Add support for displaying map titles
- Add support for dynamic icons for the map renderer
- Add support for RQL
- Add support for JSON Query
- Add support for JSONgrep
- Migrate DatabaseSource’s get_one and get_all solution to other source classes
- Icon preview in admin
- Add webhooks support
- Regex support for Fixed width sources
- Add view type source
- Improve _flatten predicate
- Add dumb result caching
- Hash query + hash of sources = key: value = result
- Add custom response header values
- X-LIBRE-count
- X-LIBRE-query
- response = Response(result) response[‘X-LIBRE-count’] = count return response
- Improve sort with Sort generators
- Dynamic icons
- Add renderer directives text box entry in the query builder
- Add password change views and templates
- Update Twitter bootstrap version used to 3.0