Gentoo Archives: gentoo-user

From: Matti Nykyri <matti.nykyri@×××.fi>
To: "gentoo-user@l.g.o" <gentoo-user@l.g.o>
Subject: Re: [gentoo-user] CSV or mysql table as spreadsheet-like web page
Date: Tue, 24 Mar 2015 16:30:11
Message-Id: 3A084D9E-4D91-4FAD-9F93-D966FBE5CFB3@iki.fi
In Reply to: [gentoo-user] CSV or mysql table as spreadsheet-like web page by hw
1 > On Mar 24, 2015, at 17:21, hw <hw@×××××××××××××××××××××.de> wrote:
2 >
3 > Hi,
4 >
5 > how would you go about creating a web page from either a CSV file or a table in a mysql database which presents the data to a user and lets them edit some of the data, preferably with the ability to use formulas like you can in a spreadsheet to do some calculations on the fly?
6
7 A php script that does that kind of table drawing is really easy :) Editing the content is harder... You have to think how you wan't to do it. Htlm has its limitations :/
8
9 > Once editing the data is finished, it should all be saved to a table in a database or as a CSV file.
10
11 Design it so that you know for certain which cells the user has edited so you don't need to overwrite the entire table even if the table has changed in between.
12
13 Many things depend on the size of your table. Raw non-relational database is really easy to interface even with html. Excel can do a table with 2^16 rows and few hundred columns. With mysql you can easily do like a million rows :) design the database so that it has a separate value for the user typed cell content and another for the displayable result of the content.
14
15 > Is there some php script or the like which can do this or get me started?
16
17 Well i would never use HTML for real work, it is for free-time (facebook etc). Qt has has a really good frontend for working with mysql table. It is fast and supports getting rows asynchronously in the background and in the specified range. With a qt frontend the gui looks much better and unified than with a web-browser.
18
19 --
20 -Matti