Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

2012-12-10 Thread Noel Frankinet
Lets agree to disagree, sqlite is completely cross-plaform. You could develop a cross plate-form solution in the same time (Qt or Tcl/tk). The 95% market does not hold if you think smart-phone and tablet (a good target for a simple data entry application). If you only want windows, why not uuse

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

2012-12-10 Thread Gilles Ganault
On Mon, 10 Dec 2012 15:07:05 +0100, Noel Frankinet wrote: >It's probably a good way to get something working, but you loose the >cross-platform I know, but Windows is 95% of the market for end-users, cross-platform is a pain to write, they take longer to load and always

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

2012-12-10 Thread Noel Frankinet
It's probably a good way to get something working, but you loose the cross-platform On 10 December 2012 14:47, Gilles Ganault wrote: > On Mon, 10 Dec 2012 11:49:31 +, Simon Slavin > wrote: > >There are lots of people who manipulate data that

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

2012-12-10 Thread Gilles Ganault
On Mon, 10 Dec 2012 11:49:31 +, Simon Slavin wrote: >There are lots of people who manipulate data that way, but they tend to export > their data from the SQLite database into their favourite spreadsheet app, > do the manipulation there, then reimport to SQLite. > This

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

2012-12-10 Thread Simon Slavin
On 10 Dec 2012, at 11:00am, Gilles Ganault wrote: > That's why I thought there could be a need for a datagrid that would > save data in SQLite and provide basic sort/search functions. There are lots of people who manipulate data that way, but they tend to export their

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

2012-12-10 Thread Gilles Ganault
On Sun, 09 Dec 2012 14:15:30 +0100, Olaf Schmidt wrote: >The only thing remaining for a decent workflow, which in >the end is based on SQLite-storage, would then be a small >batch-program or -script, which ensures the SQLite-To-CSV >conversion (the sqlite-commandline-tool could do

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

2012-12-10 Thread Gilles Ganault
On Sun, 9 Dec 2012 07:42:08 -0600, "Michael Black" wrote: >Generally speaking database and spreadsheet functionality are not similar >enough to combine. Thanks for the input. Indee, maybe the two concepts are just too different.

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

2012-12-09 Thread noel.frankinet
Le 9/12/2012 13:40, Gilles Ganault a écrit : On Sun, 9 Dec 2012 11:40:15 +, Simon Slavin wrote: If you think you can make money by providing a basic app, write one and market it. People don't want one. If they have already paid for and learned to use Excel,

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

2012-12-09 Thread Michael Black
back in replies. So that was breaking the topic threading. Michael Black -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Gilles Ganault Sent: Sunday, December 09, 2012 5:14 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Subjec

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

2012-12-09 Thread Olaf Schmidt
Am 09.12.2012 12:40, schrieb Simon Slavin: On 9 Dec 2012, at 11:13am, Gilles Ganault wrote: OTOH, whoever writes that application could always provide two version: Basic (datagrid) and Pro (spreadsheet). If you think you can make money by providing a basic app,

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

2012-12-09 Thread Gilles Ganault
On Sun, 9 Dec 2012 11:40:15 +, Simon Slavin wrote: >If you think you can make money by providing a basic app, write one and market >it. > >People don't want one. If they have already paid for and learned to use >Excel, they'll use that. > If they haven't, they'll use

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

2012-12-09 Thread Simon Slavin
On 9 Dec 2012, at 11:13am, Gilles Ganault wrote: > OTOH, whoever writes that application could always provide two > version: Basic (datagrid) and Pro (spreadsheet). If you think you can make money by providing a basic app, write one and market it. People don't want

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

2012-12-09 Thread Gilles Ganault
On Sun, 09 Dec 2012 00:04:40 +0100, Olaf Schmidt wrote: >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

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

2012-12-09 Thread Gilles Ganault
On Sun, 09 Dec 2012 00:49:03 +0100, Jean-Christophe Deschamps wrote: >What are those $20 suppose to pay for? Licenses by users interested in buying that utility optimized to build lists and sort data much better than in Excel (which isn't meant for that, but people use it

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

2012-12-08 Thread David Bicking
es Ganault <gilles.gana...@free.fr> To: sqlite-users@sqlite.org Cc: Sent: Saturday, December 8, 2012 4:09 PM Subject: Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet? On Sat, 8 Dec 2012 20:58:17 +, Simon Slavin <slav...@bigfraud.org> wrote: >On the other hand, if you put in t

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

2012-12-08 Thread Jean-Christophe Deschamps
Let's see. 100.000 licenses @ $20 = $2.000.000 Cayman S = $65.000 www.gizmag.com/porsche-cayman/25260/ => 30 cars. Kim Dotcom! :-) What are those $20 suppose to pay for? ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

2012-12-08 Thread Gilles Ganault
On Sat, 08 Dec 2012 23:30:09 +0100, Jean-Christophe Deschamps wrote: >Either use a full-blown SQLite DB manager (e.g. the free version of >SQLite Expert among others) or develop a simple script based on an >ad-hoc ListView and SQLite functions using something like AutoIt. >

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

2012-12-08 Thread Olaf Schmidt
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".

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

2012-12-08 Thread Gilles Ganault
On Sat, 8 Dec 2012 22:34:28 +, Simon Slavin wrote: >Google 'sqlite database editor' Thanks. I'll check 'em out, although it's very likely those are meant for computer people, not regular folks. ___ sqlite-users mailing list

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

2012-12-08 Thread Simon Slavin
On 8 Dec 2012, at 9:09pm, Gilles Ganault wrote: > Ok, but where are the large number of tools that would do that? Google 'sqlite database editor' http://sqlitebrowser.sourceforge.net http://saxmike.com/MySoftware/MySoftware.asp

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

2012-12-08 Thread Jean-Christophe Deschamps
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) - saves data in SQLite - very easy to create new tables + columns - lets the user edit rows/columns as easily as in Excel - data can be sorted

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

2012-12-08 Thread Gilles Ganault
On Sat, 8 Dec 2012 20:58:17 +, Simon Slavin wrote: >On the other hand, if you put in the great amount of effort to write >a general tool and clean it up so other people can use it, >it requires enough time that you'll want to charge for your work. >Hence the large

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

2012-12-08 Thread Simon Slavin
On 8 Dec 2012, at 8:08pm, Gilles Ganault wrote: > Thanks Peter. I'll add it to the list of things to check. Maybe what I > had in mind was harder to develop, or simpy no one had any need for > it. They're easy to write but you'll find that everyone wants one that works

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

2012-12-08 Thread Gilles Ganault
On Sat, 8 Dec 2012 09:49:09 -0800, Peter Haworth wrote: >As others have mentioned, there are several third party products out there >that will do something similar to what you want. My SQLiteAdmin tool has a >grid view of data in a table. You can't edit directly in the table but

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

2012-12-08 Thread Peter Haworth
t, Dec 8, 2012 at 9:00 AM, <sqlite-users-requ...@sqlite.org> wrote: > Message: 10 > Date: Sat, 08 Dec 2012 02:36:17 +0100 > From: Gilles Ganault <gilles.gana...@free.fr> > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Subject: Re: Simple SQLit

Re: [sqlite] Subject: Re: Simple SQLite-based spreadsheet?

2012-12-07 Thread Gilles Ganault
On Fri, 7 Dec 2012 20:22:56 -0500, da...@dandymadeproductions.com wrote: >Or perhaps MyJSQLView >Be sure to install Xerial JDBC jar in jre/lib/ext/ > >http://myjsqlview.org >http://www.xerial.org Thanks for the tip. Java + JDBC + SQLite seems a bit heavy, though.