Skip to main content

Map a single RDBMS table to a bag.

Project description

mappingsql is TiddlyWeb StorageInterface implementation that maps an RDBMS table as a bag, with each row representing a tiddler.

It has many limitations (on purpose):

  • It is READ ONLY

  • It only supports one bag.

  • It has no support for recipes.

  • It has no support revisions.

  • It has limited support for search.

You tell tiddlywebconfig.py what database you want to look at, what table you want to map, and what bag name you want that table to think of itself as. The column name ‘id’ is mapped to tiddler.title unless overridden by the configuration setting of ‘mappingsql.id_column’. Any column names that map to Tiddler attributes are applied. Otherwise, columns are mapped into tiddler.fields.

Search support is used primarily with MySQL and its full text indexing system. You may turn on this support with ‘mappingsql.full_text’ set to True.

This is experimental alpha software, reading and understanding the code is recommending before using. There is additional information in the module docstring.

TODO:

  • Make mapping of columns to tiddler attributes optional.

  • Cast column data to unicode with flair.

This work was created by Chris Dent <cdent@peermore.com> for Peermore Limited, working for Yellowcar Limited, under the auspices of the wiki-data project of Avox.

It is license under the BSD license. See COPYRIGHT for more information.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

tiddlywebplugins.mappingsql-0.5.tar.gz (8.3 kB view details)

Uploaded Source

File details

Details for the file tiddlywebplugins.mappingsql-0.5.tar.gz.

File metadata

File hashes

Hashes for tiddlywebplugins.mappingsql-0.5.tar.gz
Algorithm Hash digest
SHA256 e26101fbec614d71c4a509b8e3fddecc8ba5268d0586a49cd784b63c4d3f4cf3
MD5 f37ee530339ee4f57642e08ef7e26da1
BLAKE2b-256 aa28c5e3e1de6070b91a69402afc9d802e82d11c898f1bb9d50565aa7b35f72d

See more details on using hashes here.

Provenance

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page