[sqlite] How to persist MAX_PAGE_COUNT?
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;" --> returns 20 5) Quit sqlite.exe 6) Reopen store01.sqlite using sqlite.exe 7) Execute "pragma MAX_PAGE_COUNT;" --> returns 1073741823 (default)!! Why? How can I persist the MAX_PAGE_COUNT value so that the database size remains what I want it to be? Further, from sqlite3_analyzer output can I get the MAX_PAGE_COUNT value. Thanks, Yuva
Re: [sqlite] User defined functions and SQL Expressions
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". Kind >of weird. Does Sqlite handle SQL expressions inside the parentheses? I also >tried this but without success: > > UPDATE Employees SET EncryptedName = ENCRYPT(LastName) + ', ' + >ENCRYPT(FirstName) > >Thx >-brett I think the + sign forces SQLite into thinking this is a numerical expression ( + ) of which the outcome is zero, because from a numerical viewpoint all the terms have value zero. In other words: The contatenation operator is || , not +. -- ( Kees Nuyt ) c[_] - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] User defined functions and SQL Expressions
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 parentheses? I also tried this but without success: UPDATE Employees SET EncryptedName = ENCRYPT(LastName) + ', ' + ENCRYPT(FirstName) Thx -brett This message was sent using IMP, the Internet Messaging Program. - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] 4invalid UTF-8 sequence
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 isaias cabrera <[EMAIL PROTECTED]> wrote: 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 = '', login = 'id99', cust = 'CoCo', proj = 'Tape Binder OpMan', PClass = 'Quote', PSubClass = 'PM', bdate = '2007-12-05', ddate = '2007-12-05', edate = '', pm = 'josé', pmuk = 'First, Name', lang = 'de-DE', vendor = '', vEmail = '', invoice = '0.0', ProjFund = '177', PMTime = '1.50', A_No = 'B9OPMSL0', wDir = 'D:\Projects\CoCo\000871-CoCo-Tape-Binder-OpMan\Quote', BiliDir = '', TMDir = 'T:\Projects\_TMs\CoCo-TMs\actual', DeliveryDir = '', paid = 'n', paidDate = '', notes = 'Operator Manual', status = 'o', pages = '', ta = '', fromLang = 'en-US', techPM = '', termPM = '', Xtra0 = '', Xtra1 = '', Xtra2 = 'y' WHERE id = 1601; threw an exception, DBIException: near "bs": syntax error as you can see, there is no syntax error above. What I would like to do is to turn on some debuging utility inside the DBs to see what it is receiving and why the DB is refusing the execute call, if it is, at all. I will post this problem to the DDBI newsgroup and see if they also could help me. Any help or ideas are appreciated. thanks, josé - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] 4invalid UTF-8 sequence
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 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 = '', login = 'id99', cust = 'CoCo', proj = 'Tape Binder OpMan', PClass = 'Quote', PSubClass = 'PM', bdate = '2007-12-05', ddate = '2007-12-05', edate = '', pm = 'josé', pmuk = 'First, Name', lang = 'de-DE', vendor = '', vEmail = '', invoice = '0.0', ProjFund = '177', PMTime = '1.50', A_No = 'B9OPMSL0', wDir = 'D:\Projects\CoCo\000871-CoCo-Tape-Binder-OpMan\Quote', BiliDir = '', TMDir = 'T:\Projects\_TMs\CoCo-TMs\actual', DeliveryDir = '', paid = 'n', paidDate = '', notes = 'Operator Manual', status = 'o', pages = '', ta = '', fromLang = 'en-US', techPM = '', termPM = '', Xtra0 = '', Xtra1 = '', Xtra2 = 'y' WHERE id = 1601; threw an exception, DBIException: near "bs": syntax error as you can see, there is no syntax error above. What I would like to do is to turn on some debuging utility inside the DBs to see what it is receiving and why the DB is refusing the execute call, if it is, at all. I will post this problem to the DDBI newsgroup and see if they also could help me. Any help or ideas are appreciated. thanks, josé - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] 4invalid UTF-8 sequence
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 = '', login = 'id99', cust = 'CoCo', proj = 'Tape Binder OpMan', PClass = 'Quote', PSubClass = 'PM', bdate = '2007-12-05', ddate = '2007-12-05', edate = '', pm = 'josé', pmuk = 'First, Name', lang = 'de-DE', vendor = '', vEmail = '', invoice = '0.0', ProjFund = '177', PMTime = '1.50', A_No = 'B9OPMSL0', wDir = 'D:\Projects\CoCo\000871-CoCo-Tape-Binder-OpMan\Quote', BiliDir = '', TMDir = 'T:\Projects\_TMs\CoCo-TMs\actual', DeliveryDir = '', paid = 'n', paidDate = '', notes = 'Operator Manual', status = 'o', pages = '', ta = '', fromLang = 'en-US', techPM = '', termPM = '', Xtra0 = '', Xtra1 = '', Xtra2 = 'y' WHERE id = 1601; threw an exception, DBIException: near "bs": syntax error as you can see, there is no syntax error above. What I would like to do is to turn on some debuging utility inside the DBs to see what it is receiving and why the DB is refusing the execute call, if it is, at all. I will post this problem to the DDBI newsgroup and see if they also could help me. Any help or ideas are appreciated. thanks, josé - To unsubscribe, send email to [EMAIL PROTECTED] -
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] Need help in sqlite3
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 DRH that he and his co-workers have developed extensive TCL and software modules to test the SQLite3 DBMS so I think duplicating those tests would probably not be of interest to you. I designed a SQLite3 DBMS API for my employer. I had to write my own tester to test my API. If you need something like what I've implemented, I suggest that you will most likely have to write it yourself. Lee Crain -Original Message- From: ssridhar07 [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 08, 2008 2:18 AM To: sqlite-users@sqlite.org Subject: [sqlite] Need help in sqlite3 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 archive at Nabble.com. - 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] For Better Performance
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 size = 1K cache size = 2k The processor speed is 600 Mhz. I am using joins method in sqlite.The records are the meta data information of the audio files. How i can improve my search and insertion speeds? any change in the above parameters will help? Thanks and Regards, A.Sreedhar. - 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] For Better Performance
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 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 meta data information of the audio files. How i can improve my search and insertion speeds? any change in the above parameters will help? Thanks and Regards, A.Sreedhar. - 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] -
[sqlite] free excel-like COLORFUL gui for sqlite
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] -
[sqlite] Need help in sqlite3
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 archive at Nabble.com.
[sqlite] For Better Performance
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 meta data information of the audio files. How i can improve my search and insertion speeds? any change in the above parameters will help? Thanks and Regards, A.Sreedhar.
[sqlite] How to persist MAX_PAGE_COUNT?
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 MAX_PAGE_COUNT =100; PRAGMA MAX_PAGE_COUNT; Am I missing something? Regards, Yuva sqlite3.dll dated 14.Dec.2007 (3_5_4)