[sqlite] How to persist MAX_PAGE_COUNT?

2008-01-08 Thread Yuvaraj Athur Raghuvir
Hello, When I set the MAX_PAGE_COUNT and retrieve the value in the same connection, I get what I set. However, when I use a new connection to the database, I get the default value. Also if I close all connections and restart, I am getting the default value. Statements used: PRAGMA

[sqlite] For Better Performance

2008-01-08 Thread Sreedhar.a
Hi, I am using sqlite for meta data storage of audio files. I am storing the sqlite database in hard disk. The sector size of FAT file system is 512 bytes. Hard disk rpm is 4200 Page size = 1K cache size = 2k The processor speed is 600 Mhz. I am using joins method in sqlite.The records are the

[sqlite] Need help in sqlite3

2008-01-08 Thread ssridhar07
Dear All, I need help in sqlite3. i want to test the sqlite 3 database . any test tool is there to test database?? pls help me Thanks in Advance. -- View this message in context: http://www.nabble.com/Need-help-in-sqlite3-tp14685105p14685105.html Sent from the SQLite mailing list

[sqlite] free excel-like COLORFUL gui for sqlite

2008-01-08 Thread sqlfan
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

Re: [sqlite] free excel-like COLORFUL gui for sqlite

2008-01-08 Thread sqlfan
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

Re: [sqlite] free excel-like COLORFUL gui for sqlite

2008-01-08 Thread bartsmissaert
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

Re: [sqlite] For Better Performance

2008-01-08 Thread Daniel ├ľnnerby
Please read the following pages: http://www.sqlite.org/cvstrac/wiki?p=PerformanceTuning http://www.sqlite.org/cvstrac/wiki?p=PerformanceTuningWindows Sreedhar.a wrote: Hi, I am using sqlite for meta data storage of audio files. I am storing the sqlite database in hard disk. The sector size

Re: [sqlite] free excel-like COLORFUL gui for sqlite

2008-01-08 Thread bartsmissaert
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

Re: [sqlite] For Better Performance

2008-01-08 Thread John Stanton
Your disk is slow (large latency). Speeding that up to 7,500 or 15,000 RPM will help. Sreedhar.a wrote: Hi, I am using sqlite for meta data storage of audio files. I am storing the sqlite database in hard disk. The sector size of FAT file system is 512 bytes. Hard disk rpm is 4200 Page

Re: [sqlite] free excel-like COLORFUL gui for sqlite

2008-01-08 Thread Mag. Wilhelm Braun
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

RE: [sqlite] free excel-like COLORFUL gui for sqlite

2008-01-08 Thread Griggs, Donald
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,

RE: [sqlite] Need help in sqlite3

2008-01-08 Thread Lee Crain
Your request for assistance is too broad. Can you narrow it, be more specific? For instance: Do you want to test the use of a specific SQLite3 database that you've designed, test the software that you've created to access it, test the SQLite3 DBMS, or what? I know from reading forum emails from

Re: [sqlite] free excel-like COLORFUL gui for sqlite

2008-01-08 Thread Clark Christensen
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

RE: [sqlite] free excel-like COLORFUL gui for sqlite

2008-01-08 Thread Samuel R. Neff
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

Re: [sqlite] free excel-like COLORFUL gui for sqlite

2008-01-08 Thread Michael Hooker
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

[sqlite] 4invalid UTF-8 sequence

2008-01-08 Thread jose isaias cabrera
Greetings! I have developed an application that uses a local and a shared folder SQLite3 DBs and the D SQLite3 wrapper is failing on execute commands. For example, this UPDATE command, UPDATE LSOpenJobs SET ProjID = '871', subProjID = '865', parent = '209', children = '',

Re: [sqlite] 4invalid UTF-8 sequence

2008-01-08 Thread Ken
The only occurence of the string "bs" in your code is at the table name LSOpenJobs Maybe the DBI layer is not passing everything since there is a carriage return after the SET? HTH Ken jose isaias cabrera <[EMAIL PROTECTED]> wrote: Greetings! I have developed an application that uses a

Re: [sqlite] 4invalid UTF-8 sequence

2008-01-08 Thread jose isaias cabrera
One more question on this... What if I don't send UTF-8 characters? From: "Ken" who said, The only occurence of the string "bs" in your code is at the table name LSOpenJobs Maybe the DBI layer is not passing everything since there is a carriage return after the SET? HTH Ken jose

[sqlite] User defined functions and SQL Expressions

2008-01-08 Thread brettg
Hello. I've written a UDF named ENCRYPT. I want to do something like this: UPDATE Employees SET EncryptedName = ENCRYPT(LastName + ', ' + FirstName) The UDF gets called, but not with my data - rather something like "0.0". Kind of weird. Does Sqlite handle SQL expressions inside the

Re: [sqlite] User defined functions and SQL Expressions

2008-01-08 Thread Kees Nuyt
On Wed, 09 Jan 2008 11:21:43 +1000, [EMAIL PROTECTED] wrote: >Hello. I've written a UDF named ENCRYPT. I want to do something like this: > > UPDATE Employees SET EncryptedName = ENCRYPT(LastName + ', ' + FirstName) > >The UDF gets called, but not with my data - rather something like "0.0".

[sqlite] How to persist MAX_PAGE_COUNT?

2008-01-08 Thread Yuvaraj Athur Raghuvir
Hello, I am not able to persist the MAX_PAGE_COUNT on the database I am using. OS : Windows Version: 3_5_4 dated 14.Dec.2007 1) Create a database - say store01.sqlite 2) Open store01.sqlite using sqlite.exe 3) Execute "pragma MAX_PAGE_COUNT = 20;" 4) Execute "pragma MAX_PAGE_COUNT;" -->