Am 08.12.2012 22:09, schrieb Gilles Ganault:
Ok, but where are the large number of tools that would do that?
Features:
- very fast, very basic spreadsheet (not based on Excel or
Libre/OpenOffice)
I think you will have to be more specific with regards
to "spreadsheet-like functionality".
Do you need Formulas in individual cells (difficult
with a DB-Table-Backend) or just for "entire columns"
(a bit easier then with a DB-Table-based-"DocFormat")...
Do you need individual "Formats" (BackGround-Colors, or
Font- Types/Colors/Sizes/Weights as well as "Format-Strings
to render Double- or Date-Values" appropriately) ...
at cell-level ... or just for entire columns...?
If no such special Formatting is needed, then the
term "DataGrid" is the more common one, since
"real SpreadSheet functionality" is usually associated
with the extended requirements (at individual cell-level)
I've listed above.
- saves data in SQLite
Even with "all the extended formatting", just mentioned
above, you could of course save everything which makes
up such a "real spread-sheet-document" against a single
SQLite-DB-File as your choice of "Document-storage".
But the result would then be in its own kind of special
"DB-Document-Format" - involving more than one table
per document-page (in case you want to use efficient
storage with a kind of "applied normalization").
To store more than just the "Raw-Column-Data" in only
a *single* table would require a lot of "sparsely
populated, 'kind of hidden' extra-Columns"...
And since in your first posting you wrote:
"I need to enter a bunch of items into a table
that I can later read from a web app."
I wonder, whether you expect the webapp to visualize
your (then retrieved at the [Web]serverside I assume)
SQLite-Data with all the "pretty spreadsheet-like
formatting" - or just "datagrid-like column-based
Text-Formatting"?
If it is "Rich-Offline-Formatting of Table-like views"
to finally feed a WebApp (after uploading such an
Offline-created Doc.) - then there's either the HTML-
export-Option of OpenOffice for example - or you can
use the Browser- or HTML/JS-based stuff out there,
which helps to create such rich formatted table-views
directly (for example HTML/JS-based WYSIWYG-Editors
with a good Table-Plugin - or e.g. the Google-Docs-
Spreadsheet).
...just to mention some "Web"-options, which don't involve
storing the Document in an SQLite-File.
If you want more DataGrid-like Web-Editing in your
Browser, then there's also a lot of "DataGrid-like"
JS-Components (e.g. direct jQuery-based ones - or
those included in the larger JS-based Toolkits, like
in the Ext-Framework for example).
Those would require a serverside serialization of
(SQLite)-DataContent into XML or JSON usually -
to be more easily "bindable" to the JS-based Grids.
- very easy to create new tables + columns
- lets the user edit rows/columns as easily as in Excel
- data can be sorted by any column
- access to SQL a plus, but must not be required, as the app is meant
to non-techies
This last block of your requirements is already addressed
(more or less) by many of the already existing "SQLite-Admin-Apps"
out there, a few of them also offering "In-Table-Cell-Editing
of raw Column-Data" - but as said - this would be what is known
as "DataGrid-Mode", it's not "real SpreadSheet-Functionality".
But as others have already mentioned - if your requirements are
"somewhat special" (outside the Standard-usecase) - and the
Browserbased JS-Frameworks or -components are not "your thing" -
then use some existing Grid- or Spreadsheet-components for
your language of choice - there's real spreadsheet-components
out there - as well as all kind of different DataGrid-components
(for the Windows-World these would come as Dlls, OCXes or
Delphi-VCLs or .NET or Java-based components).
The normal DataGrid-components can be bound with only a few
lines of code, to work directly also against SQLite-Backends...
The SpreadSheet-Components usually support DB-Backend-Binding
as well (on Windows usually over ADO or ADO.NET) - but as
soon as you want to use their full formatting-options, you
will have to use their proprietary SpreadsheetDoc-Format -
though most of them also offer "Excel-Export".
Olaf
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
