Cookbook /
Txtdb (Csv based database)
Summary:Txtdb (A simple csv based database)
Version: 2.2.1-alpha-4-20241027
Prerequisites: PmWiki 2.2.122+, PHP 5.6.40+
Status:Active/Alpha
Maintainer:VKrishn
Questions answered by this recipe
- A simple csv based database, capable of being queried using sql.
Txtdb (A simple csv based database)
Txtdb-sample1(Form based queries) | Txtdb-sample2(Wiki directive based queries) | Txtdb-sample3(Data output as List) | Txtdb-sample4(Data output as List) | Txtdb-sample5(Data output as Pmwiki PageVars) | Txtdb-sample6(Data output as Pmwiki PageVars)
Description
- To create simple wiki based database.
- This package is presently experimental and in alpha state.
Notes
Some of the potential uses of Txtdb
- Site wide or group wide database can be created.
- Page wise database can be set.
- Txtdb's can be used to explain terms in any other language. Thus helping in creating a multilanguage page.
- Txtdb page can be shared among users or easily copied on to a new/different website/page.
- SQL style query can be done using Txtdb.
Release notes
See also
Contributors
- Original Author of "txtdb lib": c-worker.ch
- Site: http://www.c-worker.ch
Demo:
- Please see links at the beginning of this page. see above
| Requirements | ||
| Package/Apps | Minimum | Last test |
|---|---|---|
| Php | 5 >= 5.6.40 | 8.1.6+ |
| PmWiki | 2.2.122 | 2.3.37 |
| Browser | Most browsers built after 2014 with JavaScript support + CSS2+ | |
Help/Manual
Files/Download
Changelog
October 27, 2024 =================== TxtDb version 2.2.1-alpha-4 --------------------------- -- Minor bug fix, re-enable $result->reset(). -- Add opt cschar for dbtable. -- Code clean. October 20, 2024 =================== TxtDb version 2.2.1-alpha-3 --------------------------- -- Add defaults. -- Redo @suppression/isset codes. -- Move php-txt-db-api to lib folder. -- Add new adapter sqlite/memdb. -- Improve error handling. -- Update docs, improve sample pages. -- Code clean. February 15, 2023 =================== TxtDb version 2.2.1-alpha-2 --------------------------- -- Added class simpletable to table output. January 16, 2023 =================== TxtDb version 2.2.1-alpha-1 --------------------------- -- Make compatible with php 7.2x. -- Make compatible with php 8.0.x. -- Minor bug fix. -- Code clean. April 07, 2016 =================== TxtDb version 2.2.0-alpha-7 --------------------------- -- Make compatible with php 5.5x. -- Minor bugs fixes. February 12, 2010 =================== TxtDb version 2.2.0-alpha-6 --------------------------- -- Output as 'sessionvar'. -- Output as raw 'array'. -- Output as raw 'serialize'. -- Call/Moved txtdb lib call from within markup's function call. -- Renamed option 'OutputId' to 'id'. -- Renamed option 'OutputClass' to class. February 02, 2010 =================== TxtDb version 2.2.0-alpha-5 --------------------------- -- Improved transpose behaviour. -- Transpose available in pagevars. -- Two different ouputs from same id txtdbDraw call(But different OutputId). -- Included sample_table.txt for reference. January 31, 2010 =================== TxtDb version 2.2.0-alpha-4 --------------------------- -- Minor correction in markups. -- Support for multiline data in pmwiki's simple table format -- OutputId and OutputClass for txtdbDraw. -- Added 'List' output type. -- Added behaviour 'transpose' for table and list output. -- Improved form support. January 21, 2010 =================== TxtDb version 2.2.0-alpha-3 --------------------------- -- Fixed, now allows both Pmwiki simple-table and txtdb table format to display together. -- Added, Output from query can be used as Pmwiki PageVariables. -- Improved code logic. January 19, 2010 =================== TxtDb version 2.2.0-alpha-2 --------------------------- -- Added wikitable output option for (:txtdbDraw:) directive. -- Added options to read PmWiki 'simple table' as a database table. January 12, 2010 =================== TxtDb version 2.2.0-alpha-1 --------------------------- -- Initial Release. -- Version num start made to coincide with Current PmWiki version.
Author
- V.Krishn
Comments
User notes? : If you use, used or reviewed this recipe, you can add your name. These statistics appear in the Cookbook listings and will help newcomers browsing through the wiki.