Difference between revisions of "Data Tables"

From Freephile Wiki
Jump to navigation Jump to search
(updated for 2023)
Line 1: Line 1:
Sometimes called a 'Data Grid', Data Tables is a name for systems that present data to the User Interface in a robust way without unnecessary programming.  "Unnecessary programming" is a complicated phrase.  It's good to know the frameworks (e.g. [[jQuery]]), because they're powerful and quite often in demand.  However, you should know how the underlying technology works, and sometimes that is both necessary '''and''' more in demand <ref>https://teamtreehouse.com/forum/html-table-from-json-store-using-pure-javascript-no-jquery</ref>.
+
Data Tables is a term I am using to describe client-side (JavaScript) fancy formatting, sorting and other features of tabular data. Sometimes called a 'Data Grid', Data Tables is a name for systems that present data to the User Interface in a robust way without unnecessary programming.  "Unnecessary programming" is a complicated phrase.  It's good to know the frameworks (e.g. [[jQuery]]), because they're powerful and quite often in demand.  However, you should know how the underlying technology works, and sometimes that is both necessary '''and''' more in demand <ref>https://teamtreehouse.com/forum/html-table-from-json-store-using-pure-javascript-no-jquery</ref>.
  
== Solutions ==
+
==Solutions==
# https://datatables.net/index is a plugin for jQuery that I've used.  It's probably the #1 solution in the category
+
 
# Steve Schwartz created [http://www.dynatable.com/ DynaTable] This is even cooler.  Best of all, it's AGPL licensed, so it's completely free software, and will remain so.
+
#[https://datatables.net/ https://datatables.net/index] is a plugin for jQuery that I've used.  It's probably the #1 solution in the category. This is '''available for MediaWiki.'''
# http://ajaxpatterns.org/Data_Grid is interesting because it discusses the pattern behind this problem, but fairly old (2010 last major edit), and doesn't even mention datatables
+
#Steve Schwartz created [http://www.dynatable.com/ DynaTable] This is even cooler.  Best of all, it's AGPL licensed, so it's completely free software, and will remain so.
# http://lazymofo.wdschools.com/ offers an MIT licensed PHP Data Grid
 
# https://labs.mbrooks.info/demos/Tidy-Table/ is also MIT licensed
 
  
 
There are other solutions that create CRUD interfaces to databases, but they're either not worth mentioning, or I haven't fully researched it.  There used to be a phpGrid that was free (GPL) software, but not now.  phpgrid.org and phpgrid.com definitely are not
 
There are other solutions that create CRUD interfaces to databases, but they're either not worth mentioning, or I haven't fully researched it.  There used to be a phpGrid that was free (GPL) software, but not now.  phpgrid.org and phpgrid.com definitely are not
  
 
+
== See Also ==
{{References}}
+
There is an extension called DataTable2 which has nothing to do with client-side display, formatting and functionality of tabular data. The [[mediawikiwiki:Extension:DataTable2|DataTable2 extension]] in the converse of SemanticMediaWiki. It allows you to store data centrally (many records on a single page) and re-use that data on other pages. {{References}}
  
 
[[Category:Data]]
 
[[Category:Data]]
 
[[Category:UI]]
 
[[Category:UI]]

Revision as of 08:15, 12 April 2023

Data Tables is a term I am using to describe client-side (JavaScript) fancy formatting, sorting and other features of tabular data. Sometimes called a 'Data Grid', Data Tables is a name for systems that present data to the User Interface in a robust way without unnecessary programming. "Unnecessary programming" is a complicated phrase. It's good to know the frameworks (e.g. jQuery), because they're powerful and quite often in demand. However, you should know how the underlying technology works, and sometimes that is both necessary and more in demand [1].

Solutions[edit | edit source]

  1. https://datatables.net/index is a plugin for jQuery that I've used. It's probably the #1 solution in the category. This is available for MediaWiki.
  2. Steve Schwartz created DynaTable This is even cooler. Best of all, it's AGPL licensed, so it's completely free software, and will remain so.

There are other solutions that create CRUD interfaces to databases, but they're either not worth mentioning, or I haven't fully researched it. There used to be a phpGrid that was free (GPL) software, but not now. phpgrid.org and phpgrid.com definitely are not

See Also[edit | edit source]

There is an extension called DataTable2 which has nothing to do with client-side display, formatting and functionality of tabular data. The DataTable2 extension in the converse of SemanticMediaWiki. It allows you to store data centrally (many records on a single page) and re-use that data on other pages. == References ==