Re: [sqlite] free excel-like COLORFUL gui for sqlite
Sqlfan: If you really want something to imitate Excel, rather than just using Excel itself and the very capable VBA it includes, one option would be Borland Delphi, using Ralf Junker's Disqlite3 as the wrapper to Sqlite3 and any one of a number of third-party shareware grid components, easily tracked down via Google. Disqlite3 comes with at least one example using such a component. I suspect, however, that you wouldn't get away with a free "personal use" version of either - not if you are working for a client. I don't think any of us understand why you need a GUI front end to replace Excel when Excel does all the display work for you, and your client is happy with it. Likewise you haven't mentioned how you would write your own GUI. If you are actually capable of doing that, my feeling is that you might as well just get on with it because anything else is going to be a compromise. Michael Hooker On 08/01/2008 16:32:08, Mag. Wilhelm Braun ([EMAIL PROTECTED]) wrote: there are a number of front ends to sqlite - I use sometime tksqlite. http://reddog.s35.xrea.com/wiki/TkSQLite.html maybe not exactly what you want - but it might be a starting point. regards W.Braun [EMAIL PROTECTED] wrote: > Still not sure why you want to use SQLite here, but I think to get what > you want you will have to code > it yourself. > > RBS > > >> Let me be more clear. There's very little data, and I want to help my >> client >> be able to expand his business, so the first step is automating what >> he's >> been doing by hand. I can get the excel data into sqlite no problem -- >> and >> wish to do so in order to START doing automated stuff with the data -- but >> would like to PRESENT (and only present) the data in the familiar >> spreadsheet manner. >> >> This is a general problem: many people use excel as a database only >> because >> of how nice it looks once they add coloring, and because it's easier to, >> say, have the three address fields as three columns, even though >> logically - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] free excel-like COLORFUL gui for sqlite
SQLite is not an end-user tool (nor is any other database except *perhaps* Access, but even then it just gets people into trouble). What you want is not a free gui for SQLite but a custom application that does what the user needs and uses SQLite as it's data storage mechanism. This certainly will not be free, it will require custom programming and you should evaluate whether the cost is worth the savings that the new application will bring to the company (and the answer very often is no). Perhaps there is an off-the-shelf product which may or may not be free that does what you want which would be a much cheaper option than custom development. It may not use SQLite but I don't see how that is a major requirement for your situation anyways. HTH, Sam --- We're Hiring! Seeking a passionate developer to join our team building Flex based products. Position is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] free excel-like COLORFUL gui for sqlite
Regarding Moving colorful spreadsheet to sqlite. -- Would Christian Werner's free ODBC interface allow you to use the same spreadsheet to access an sqlite database? http://www.ch-werner.de/sqliteodbc -- Lots of automation can be performed within Excel spreadsheets (and, I imagine, OpenOffice spreadsheets) without changing to a different database, right? Donald - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] free excel-like COLORFUL gui for sqlite
I'm not big on either Excel or ODBC, so I can't help with the details, but... There's an ODBC driver for SQLite you could install on your customer's system, and I'm pretty sure Excel can render data from an ODBC data source. So, if what you really want is to view query result data in Excel, it seems you could start here: http://www.sqlite.org/cvstrac/wiki?p=SqliteOdbc -Clark - Original Message From: sqlfan <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Tuesday, January 8, 2008 2:50:00 AM Subject: Re: [sqlite] free excel-like COLORFUL gui for sqlite Let me be more clear. There's very little data, and I want to help my client be able to expand his business, so the first step is automating what he's been doing by hand. I can get the excel data into sqlite no problem -- and wish to do so in order to START doing automated stuff with the data -- but would like to PRESENT (and only present) the data in the familiar spreadsheet manner. This is a general problem: many people use excel as a database only because of how nice it looks once they add coloring, and because it's easier to, say, have the three address fields as three columns, even though logically it should be a separate table Addresses. So, I'd like to have the same familiar input view without having the client worry about the details (which column is really what table, etc) and also to be able to color it as he has done to date. So, is there is a free gui frontend to sqlite that will do it, or do I have to code one myself? Thanks! bartsmissaert wrote: > > If it is so good then why would you want to use > SQLite? Holiday data can't be that much, so I would > think Excel can cope with that fine. > If you really want to move the data from Excel to > SQLite then you will need a VB wrapper. > > RBS > >> >> I have a client who's using a colorful excel sheet as a database. It's >> colorful, well-structured, and a joy to use. He has no code working on >> the >> data though -- it's just used for holding data, like a ledger book! >> >> My question is how I can put his information into a sqlite database but >> give >> him a very similar interface -- the same, well-structured, colorful, >> spreadsheet view? I don't want him to even have to worry about which >> column >> is actually in which table-- just have it look like an excel sheet. >> >> This is very basic and easy, and I'd hate to have to reinvent the wheel >> coding it -- is there a free sqlite gui that can present such a colorful >> spreadsheet view? >> >> Thank you! >> -- >> View this message in context: >> http://www.nabble.com/free-excel-like-COLORFUL-gui-for-sqlite-tp14686423p14686423.html >> Sent from the SQLite mailing list archive at Nabble.com. >> >> >> - >> To unsubscribe, send email to [EMAIL PROTECTED] >> - >> >> >> > > > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > > > -- View this message in context: http://www.nabble.com/free-excel-like-COLORFUL-gui-for-sqlite-tp14686423p14686909.html Sent from the SQLite mailing list archive at Nabble.com. - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] free excel-like COLORFUL gui for sqlite
there are a number of front ends to sqlite - I use sometime tksqlite. http://reddog.s35.xrea.com/wiki/TkSQLite.html maybe not exactly what you want - but it might be a starting point. regards W.Braun [EMAIL PROTECTED] wrote: Still not sure why you want to use SQLite here, but I think to get what you want you will have to code it yourself. RBS Let me be more clear. There's very little data, and I want to help my client be able to expand his business, so the first step is automating what he's been doing by hand. I can get the excel data into sqlite no problem -- and wish to do so in order to START doing automated stuff with the data -- but would like to PRESENT (and only present) the data in the familiar spreadsheet manner. This is a general problem: many people use excel as a database only because of how nice it looks once they add coloring, and because it's easier to, say, have the three address fields as three columns, even though logically it should be a separate table Addresses. So, I'd like to have the same familiar input view without having the client worry about the details (which column is really what table, etc) and also to be able to color it as he has done to date. So, is there is a free gui frontend to sqlite that will do it, or do I have to code one myself? Thanks! bartsmissaert wrote: If it is so good then why would you want to use SQLite? Holiday data can't be that much, so I would think Excel can cope with that fine. If you really want to move the data from Excel to SQLite then you will need a VB wrapper. RBS I have a client who's using a colorful excel sheet as a database. It's colorful, well-structured, and a joy to use. He has no code working on the data though -- it's just used for holding data, like a ledger book! My question is how I can put his information into a sqlite database but give him a very similar interface -- the same, well-structured, colorful, spreadsheet view? I don't want him to even have to worry about which column is actually in which table-- just have it look like an excel sheet. This is very basic and easy, and I'd hate to have to reinvent the wheel coding it -- is there a free sqlite gui that can present such a colorful spreadsheet view? Thank you! -- View this message in context: http://www.nabble.com/free-excel-like-COLORFUL-gui-for-sqlite-tp14686423p14686423.html Sent from the SQLite mailing list archive at Nabble.com. - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - -- View this message in context: http://www.nabble.com/free-excel-like-COLORFUL-gui-for-sqlite-tp14686423p14686909.html Sent from the SQLite mailing list archive at Nabble.com. - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] free excel-like COLORFUL gui for sqlite
Still not sure why you want to use SQLite here, but I think to get what you want you will have to code it yourself. RBS > > Let me be more clear. There's very little data, and I want to help my > client > be able to expand his business, so the first step is automating what he's > been doing by hand. I can get the excel data into sqlite no problem -- > and > wish to do so in order to START doing automated stuff with the data -- but > would like to PRESENT (and only present) the data in the familiar > spreadsheet manner. > > This is a general problem: many people use excel as a database only > because > of how nice it looks once they add coloring, and because it's easier to, > say, have the three address fields as three columns, even though logically > it should be a separate table Addresses. So, I'd like to have the same > familiar input view without having the client worry about the details > (which > column is really what table, etc) and also to be able to color it as he > has > done to date. So, is there is a free gui frontend to sqlite that will do > it, or do I have to code one myself? > > Thanks! > > > > bartsmissaert wrote: >> >> If it is so good then why would you want to use >> SQLite? Holiday data can't be that much, so I would >> think Excel can cope with that fine. >> If you really want to move the data from Excel to >> SQLite then you will need a VB wrapper. >> >> RBS >> >>> >>> I have a client who's using a colorful excel sheet as a database. It's >>> colorful, well-structured, and a joy to use. He has no code working on >>> the >>> data though -- it's just used for holding data, like a ledger book! >>> >>> My question is how I can put his information into a sqlite database but >>> give >>> him a very similar interface -- the same, well-structured, colorful, >>> spreadsheet view? I don't want him to even have to worry about which >>> column >>> is actually in which table-- just have it look like an excel sheet. >>> >>> This is very basic and easy, and I'd hate to have to reinvent the wheel >>> coding it -- is there a free sqlite gui that can present such a >>> colorful >>> spreadsheet view? >>> >>> Thank you! >>> -- >>> View this message in context: >>> http://www.nabble.com/free-excel-like-COLORFUL-gui-for-sqlite-tp14686423p14686423.html >>> Sent from the SQLite mailing list archive at Nabble.com. >>> >>> >>> - >>> To unsubscribe, send email to [EMAIL PROTECTED] >>> - >>> >>> >>> >> >> >> >> >> - >> To unsubscribe, send email to [EMAIL PROTECTED] >> - >> >> >> > > -- > View this message in context: > http://www.nabble.com/free-excel-like-COLORFUL-gui-for-sqlite-tp14686423p14686909.html > Sent from the SQLite mailing list archive at Nabble.com. > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > > > - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] free excel-like COLORFUL gui for sqlite
Let me be more clear. There's very little data, and I want to help my client be able to expand his business, so the first step is automating what he's been doing by hand. I can get the excel data into sqlite no problem -- and wish to do so in order to START doing automated stuff with the data -- but would like to PRESENT (and only present) the data in the familiar spreadsheet manner. This is a general problem: many people use excel as a database only because of how nice it looks once they add coloring, and because it's easier to, say, have the three address fields as three columns, even though logically it should be a separate table Addresses. So, I'd like to have the same familiar input view without having the client worry about the details (which column is really what table, etc) and also to be able to color it as he has done to date. So, is there is a free gui frontend to sqlite that will do it, or do I have to code one myself? Thanks! bartsmissaert wrote: > > If it is so good then why would you want to use > SQLite? Holiday data can't be that much, so I would > think Excel can cope with that fine. > If you really want to move the data from Excel to > SQLite then you will need a VB wrapper. > > RBS > >> >> I have a client who's using a colorful excel sheet as a database. It's >> colorful, well-structured, and a joy to use. He has no code working on >> the >> data though -- it's just used for holding data, like a ledger book! >> >> My question is how I can put his information into a sqlite database but >> give >> him a very similar interface -- the same, well-structured, colorful, >> spreadsheet view? I don't want him to even have to worry about which >> column >> is actually in which table-- just have it look like an excel sheet. >> >> This is very basic and easy, and I'd hate to have to reinvent the wheel >> coding it -- is there a free sqlite gui that can present such a colorful >> spreadsheet view? >> >> Thank you! >> -- >> View this message in context: >> http://www.nabble.com/free-excel-like-COLORFUL-gui-for-sqlite-tp14686423p14686423.html >> Sent from the SQLite mailing list archive at Nabble.com. >> >> >> - >> To unsubscribe, send email to [EMAIL PROTECTED] >> - >> >> >> > > > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > > > -- View this message in context: http://www.nabble.com/free-excel-like-COLORFUL-gui-for-sqlite-tp14686423p14686909.html Sent from the SQLite mailing list archive at Nabble.com. - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] free excel-like COLORFUL gui for sqlite
If it is so good then why would you want to use SQLite? Holiday data can't be that much, so I would think Excel can cope with that fine. If you really want to move the data from Excel to SQLite then you will need a VB wrapper. RBS > > I have a client who's using a colorful excel sheet as a database. It's > colorful, well-structured, and a joy to use. He has no code working on > the > data though -- it's just used for holding data, like a ledger book! > > My question is how I can put his information into a sqlite database but > give > him a very similar interface -- the same, well-structured, colorful, > spreadsheet view? I don't want him to even have to worry about which > column > is actually in which table-- just have it look like an excel sheet. > > This is very basic and easy, and I'd hate to have to reinvent the wheel > coding it -- is there a free sqlite gui that can present such a colorful > spreadsheet view? > > Thank you! > -- > View this message in context: > http://www.nabble.com/free-excel-like-COLORFUL-gui-for-sqlite-tp14686423p14686423.html > Sent from the SQLite mailing list archive at Nabble.com. > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > > > - To unsubscribe, send email to [EMAIL PROTECTED] -