Re: [sqlite] visual basic and sqlite
My only experience with VB6 and SQLite was using LiteX (http://www.assembla.com/wiki/show/litex). I was trying to avoid ODBC so tried this wrapper as it seemed to be a standalone dll. The catch is (as I learned later) that you need to register the dll (via regsvr32) when you install the application. Other than that, it worked pretty well. // -- Enrique Ramirez Irizarry Lead Developer Indie Code Labs http://www.indiecodelabs.com On Thu, Nov 6, 2008 at 9:31 AM, stormtrooper [EMAIL PROTECTED] wrote: I recommend http://www.ch-werner.de/sqliteodbc/ Keith Raziedahanin KASIM wrote: I want to develop a simple application using VB 6.0 and sqlite Where should i start? I want to craete a embedded database into this small application. Anyone can advice and guide me. Thank you in advance -- Hanni ONYX Enterprise Sdn Bhd ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- View this message in context: http://www.nabble.com/visual-basic-and-sqlite-tp19895863p20361047.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] query performance comparison with access
I'm no expert, but I believe I recall reading on one of the SQLite docs that the performance of Joins can be a bit slower than on other DB systems. Seeing as you have a couple of tables being joined, this could be the case. I also think I recall reading some posts in this list about people changing their joins into subselects and gaining some performance. Then again, I'm no expert. // -- Enrique Ramirez Irizarry Lead Developer Indie Code Labs http://www.indiecodelabs.com On Mon, Oct 27, 2008 at 7:03 AM, L B [EMAIL PROTECTED] wrote: Hi all, I have a 500mb database in access, migrated to sqlite. The structure is: --this table has 100 records CREATE TABLE CATALOGUES ( IDCATALOGUE INTEGER PRIMARY KEY AUTOINCREMENT, CATALOGUENAME TEXT, IDPERSONALDATA INTEGER, TYPE INTEGER, ACTIVE INTEGER ); CREATE INDEX IDX_CATALOGUES_IDCATALOGUE ON CATALOGUES (IDCATALOGUE); CREATE INDEX IDX_CATALOGUES_ACTIVE ON CATALOGUES (ACTIVE); CREATE INDEX IDX_CATALOGUES_TYPE ON CATALOGUES (TYPE); CREATE INDEX IDX_CATALOGUES_IDPERSONALDATA ON CATALOGUES (IDPERSONALDATA); CREATE INDEX IDX_CATALOGUES_IDCATALOGUE ON CATALOGUES (IDCATALOGUE); --this table has 3 000 records CREATE TABLE CATALOGUES_PERSONALDATAS ( IDCC INTEGER PRIMARY KEY AUTOINCREMENT, IDCATALOGUE INTEGER, IDPERSONALDATA INTEGER, AMOUNT INTEGER, REDUCTION TEXT, DTDELIVERED DATETIME, ); CREATE INDEX IDX_CATALOGUES_PERSONALDATAS_DTDELIVERED ON CATALOGUES_PERSONALDATAS (DTDELIVERED); CREATE INDEX IDX_CATALOGUES_PERSONALDATAS_IDCC ON CATALOGUES_PERSONALDATAS (IDCC); CREATE INDEX IDX_CATALOGUES_PERSONALDATAS_IDPERSONALDATA ON CATALOGUES_PERSONALDATAS (IDPERSONALDATA); CREATE INDEX IDX_CATALOGUES_PERSONALDATAS_IDCATALOGUE ON CATALOGUES_PERSONALDATAS (IDCATALOGUE); --this table has 2 500 000 records!! CREATE TABLE CRONOCATALOGUES ( IDCRCA INTEGER PRIMARY KEY AUTOINCREMENT, IDCATALOGUE INTEGER, DT DATETIME, NUMBER INTEGER, DTFROM DATETIME ); CREATE INDEX IDX_CRONOCATALOGUES_DTFROM ON CRONOCATALOGUES (DTFROM); CREATE INDEX IDX_CRONOCATALOGUES_IDCATALOGUE ON CRONOCATALOGUES (IDCATALOGUE); --this table has 800 000 records CREATE TABLE PERSONALDATAS ( IDPERSONALDATAINTEGER PRIMARY KEY AUTOINCREMENT, IDTYPE INTEGER, NAME TEXT COLLATE NOCASE ); CREATE INDEX IDX_PERSONALDATAS_IDTYPE ON PERSONALDATAS (IDTYPE); I cannot obtain similar performances on sqlite, having a 40-50% difference. (9 seconds vs. 13 seconds on windows xp, average results, after first executions (OS cache) ) The query in access is: --IN ACCESS SELECT DISTINCT TBL.*, PERSONALDATAS.NAME FROM ( SELECT CATALOGUES.IDCATALOGUE, CATALOGUES.TYPE, VENDORS.NAME AS VENDORNAME, CATALOGUES.CATALOGUENAME, MAX(CRONOCATALOGUES.DTFROM) AS MAXDT FROM PERSONALDATAS AS VENDORS INNER JOIN CATALOGUES ON VENDORS.IDPERSONALDATA = CATALOGUES.IDPERSONALDATA INNER JOIN CRONOCATALOGUES ON CATALOGUES.IDCATALOGUE = CRONOCATALOGUES.IDCATALOGUE WHERE CATALOGUES.ACTIVE=0 GROUP BY CATALOGUES.IDCATALOGUE, VENDORS.NAME, CATALOGUES.CATALOGUENAME, CATALOGUES.TYPE ) AS TBL INNER JOIN CATALOGUES_PERSONALDATAS ON (TBL.CATALOGUES.IDCATALOGUE=CATALOGUES_PERSONALDATAS.IDCATALOGUE) INNER JOIN PERSONALDATAS ON (PERSONALDATAS.IDPERSONALDATA=CATALOGUES_PERSONALDATAS.IDPERSONALDATA) WHERE CATALOGUES_PERSONALDATAS.DTDELIVEREDTBL.MAXDT ORDER BY VENDORNAME In sqlite, same query is really to slow (several minutes, even if i put an index in the text field PERSONALDATAS.NAME). So after several tries and days, best performances I get is with (but it is still 40% slower): --IN SQLITE SELECT DISTINCT TBL3.*, PERSONALDATAS.NAME AS VENDORNAME FROM ( SELECT TBL2.IDCATALOGUE AS IDCATALOGUE, TBL2.TYPE AS TYPE, TBL2.IDPERSONALDATA AS IDPERSONALDATA, TBL2.MAXDT AS MAXDT, PERSONALDATAS.NAME AS VENDORNAME ,CATALOGUES.CATALOGUENAME AS CATALOGUENAME FROM ( SELECT TBL.IDCATALOGUE AS IDCATALOGUE, TYPE, IDPERSONALDATA, TBL.MAXDT AS MAXDT FROM CATALOGUES INNER JOIN ( SELECT MAX(DTFROM) AS MAXDT, IDCATALOGUE FROM CRONOCATALOGUES GROUP BY IDCATALOGUE ) AS TBL ON CATALOGUES.IDCATALOGUE=TBL.IDCATALOGUE AND CATALOGUES.ACTIVE=0 ) AS TBL2 INNER JOIN PERSONALDATAS ON TBL2.IDPERSONALDATA = PERSONALDATAS.IDPERSONALDATA INNER JOIN CATALOGUES ON TBL2.IDCATALOGUE = CATALOGUES.IDCATALOGUE ) AS TBL3 INNER JOIN CATALOGUES_PERSONALDATAS ON TBL3.IDCATALOGUE=CATALOGUES_PERSONALDATAS.IDCATALOGUE INNER JOIN PERSONALDATAS ON PERSONALDATAS.IDPERSONALDATA=CATALOGUES_PERSONALDATAS.IDPERSONALDATA WHERE CATALOGUES_PERSONALDATAS.DTDELIVEREDTBL3.MAXDT ORDER BY TBL3.VENDORNAME Cannot find a way to get same performances. What's wrong with my
Re: [sqlite] How to install SQLite on a shared linux hosting
I have a similar setup than you (Linux host, I have no control over the system, just the files in my directory) and I have been able to successfully use SQLite with PHP. You can choose to create your databases from within PHP code, or alternatively use a graphical frontend (like for example the firefox extension called SQLite Manager) to create the database file and upload it to a directory in your web host. You can start here http://www.php.net/manual/en/ref.sqlite.php reading on the different functions to interact with SQLite from within PHP code. Hope this helps! // -- Enrique Ramirez Irizarry Lead Developer Indie Code Labs http://www.indiecodelabs.com On Fri, Oct 17, 2008 at 7:52 AM, Graeme Pietersz [EMAIL PROTECTED] wrote: On Friday 17 October 2008 16:39:32 [EMAIL PROTECTED] wrote: only compiled and linked into an application. There is no server. Martin, thank you for the answer. I do not really understand compiled, linked into an application and there is no server. Use Google. There are lots of explanations out there. You should know these if you are installing software on servers. They are far too technical terms. In simpe terms: Sqlite does not run by itself, it needs to be incorporated into another piece of software. You said you are using PHP. It usually includes sqlite. If not, ask your hosting provider. Graeme But, judging from your short answer, I believe that there is no way to use it to store/retrieve data for my site. Am I right? Luigi ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Include a double quote inside a string-literal
Did you remember to put single quotes around your string? Your example shows double quotes: this is \not working\ vs 'this is \not working\' // -- Enrique Ramirez Irizarry Lead Developer Indie Code Labs http://www.indiecodelabs.com On Fri, Oct 17, 2008 at 9:53 AM, Aladdin Lampé [EMAIL PROTECTED] wrote: Hi! Is it possible to include a \ (double quote) inside a string-literal? I wanted to use a string-literal like this is \not working\ but sqlite's SQL parser doesn't seem to accept this. Is it the intended behaviour or did I do something wrong? Thanks for your help. Aladdin _ Inédit ! Des Emoticônes Déjantées! Installez les dans votre Messenger ! http://www.ilovemessenger.fr/Emoticones/EmoticonesDejantees.aspx ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Trigger for updating timestamp-field
Just in case you also run into this: I had to do this recently on a project of mine and found out that datetime('now') (on Windows) doesn't give me the actual time since it uses UTC. To get the actual local time, use datetime('now','localtime'). For the rest of the date/time documentation, you can refer to http://sqlite.org/lang_datefunc.html Hope it helps, // -- Enrique Ramirez Irizarry Lead Developer Indie Code Labs http://www.indiecodelabs.com On Fri, Oct 17, 2008 at 9:21 PM, P Kishor [EMAIL PROTECTED] wrote: On 10/17/08, Kristofer Hindersson [EMAIL PROTECTED] wrote: Hi, I've recently started to play around with SQLite and I'm currently trying to create a trigger for updating a timestamp field inside a table (SQL-syntax for the creation of the table is included below.) Could someone please tell me how I should go about writing such a trigger. I'd like the [updated]-field to be set to the current timestamp everytime an entry is updated/modified. Thanks! /Kris CREATE TABLE IF NOT EXISTS Entries ( entryID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, title VARCHAR(50) NOT NULL, created TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, signature VARCHAR(25) NOT NULL, body TEXT NOT NULL); CREATE TRIGGER add_date AFTER INSERT ON Entries BEGIN UPDATE Entries SET updated = datetime('now') WHERE entryID = new. entryID; END; -- Puneet Kishor http://punkish.eidesis.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Malformed schema error on sqlite3odbc.dll with version 0.79
I'm not 100% sure about this, but I think SQLiteODBC is a third party project. You might have better luck contacting the original developer (http://www.ch-werner.de/sqliteodbc/) // -- Enrique Ramirez Irizarry Lead Developer Indie Code Labs http://www.indiecodelabs.com On Wed, Oct 15, 2008 at 2:30 PM, Richard Kim [EMAIL PROTECTED] wrote: Hi guys, We are using sqlite as our database and noticed some weird odbc driver problem. eb1malformed database schema (deleteUserGroupsByUsers) - no such table: main.Users (11) If I open the database with other tool such as sqlite studio, or firefox plug in, there is no problem - the schema check seems to be okay, and all the tables are there.. etc. Also If I use S3ODBC.dll, we don't see ths issue of the malformed database schema either. It happens only if I use sqlite3odbc.dll with version 0.79. Is this known bug ?? Thanks Richard K ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] how to connect to existing db with sqlite3.exe
You mean a command like ALTER TABLE? Maybe check the SQL Syntax available to SQLite (http://sqlite.org/lang_altertable.html) On Tue, Sep 30, 2008 at 4:09 PM, Ryan Walker [EMAIL PROTECTED] wrote: Hi, I have a database file in windows that I want to connect to with sqlite3.exe so I can add a column to a table. Not sure how to so it. There doesn't appear to be any relevant command when I enter .help. Thanks, Ryan -- Ryan Walker www.WebCommunicate.net: Insights and resources for effective websites. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- // -- Enrique Ramirez Irizarry Lead Developer Indie Code Labs http://www.indiecodelabs.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] datatype - serial
He probably comes from the world of posgresql, where an 'autoincrement' variable is called a serial. On Mon, Sep 22, 2008 at 1:06 PM, Seun Osewa [EMAIL PROTECTED] wrote: INTEGER PRIMARY KEY AUTOINCREMENT 2008/9/22 Victor Hugo Oliveira [EMAIL PROTECTED] hi everybody, SQLite 3 doesn't have a 'serial' datatype? If not is there a simple way that i can implement myself (i'm not a very experient programmer)? thanks Novos endereços, o Yahoo! que você conhece. Crie um email novo com a sua cara @ymail.com ou @rocketmail.com. http://br.new.mail.yahoo.com/addresses ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Seun Osewa http://www.nairaland.com/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- // -- Enrique Ramirez Irizarry Lead Developer Indie Code Labs http://www.indiecodelabs.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Network shares
Did you take a moment to read the documentation on the subject? http://www.sqlite.org/faq.html#q5 On Mon, Sep 22, 2008 at 9:37 PM, Dave Dyer [EMAIL PROTECTED] wrote: In modern working environments, network shares are not an abnormality. Sqlite Network shares work by default for pcs. If sqlite network shares don't work by default for macs, it looks like sqlite is broken or macs are broken. I suppose that's why apple made it unbroken by default in the software they ship. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- // -- Enrique Ramirez Irizarry Lead Developer Indie Code Labs http://www.indiecodelabs.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] unsubscribe - switch to digest
You have to follow http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users and set it up in your options. On Tue, Sep 23, 2008 at 12:39 PM, chris newgent [EMAIL PROTECTED] wrote: Could I be removed from the regular mailing list please. I am trying to sign up for the digest. Design simplicity eliminates engineering complexity. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- // -- Enrique Ramirez Irizarry Lead Developer Indie Code Labs http://www.indiecodelabs.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Simple Suggestions
On Sat, Sep 20, 2008 at 2:07 PM, ivo welch [EMAIL PROTECTED] wrote: * sqlitebrowser is very buggy under linux when it comes to importing csv files. often, nothing happens. sometimes, trying a second import works. just buggy. sqlitebrowser is a third party application made by someone external to the original author of SQLite. If I may, I can try and recommend the GUI client that has worked for me flawlessly. http://code.google.com/p/sqlite-manager/ is a Firefox addon for managing SQLite Databases. It has a very active developer, and can be made to run with XULRunner or other XUL enabled applications if Firefox isn't your kind of browser. -- // -- Enrique Ramirez Irizarry Lead Developer Indie Code Labs http://www.indiecodelabs.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Network concurrency question
Another question I have is do I understand correctly that an SQLite database, on a network share, has no problems with many readers, the problem starts with many writers. Is this correct? Thanks, TD Yes, you'll have problems with many writers since each network file system implementation differs from operating system to operating system. I believe there was a recommendation in the documents about implementing your own VFS layer in these cases if you need multiple writers in a network share. Might want to take a look at: http://www.sqlite.org/faq.html#q5 -- // -- Enrique Ramirez Irizarry Lead Developer Indie Code Labs http://www.indiecodelabs.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] best language match for SQLite?
On Tue, Sep 16, 2008 at 12:20 PM, [EMAIL PROTECTED] wrote: And of course, Perl is always best. :) Of course; but VB (VB6) is just a bit better. RBS Almost fell out of my chair laughing. But in all seriousness, if you're into ADO.Net, the System.Data.SQLite wrapper by Robert Simpson will make you feel right at home. -- // -- Enrique Ramirez Irizarry Lead Developer Indie Code Labs http://www.indiecodelabs.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] performance degradation from 3.6.1 to 3.6.2
List stripped the attachment. On Mon, Sep 15, 2008 at 12:27 PM, Steve Friedman [EMAIL PROTECTED] wrote: Attached is an example program that demonstrates a significant performance degradation when migrating from 3.6.1 to 3.6.2. It can be compiled with gcc -Wall -O3 trial.c sqlite3.o -o trial -lpthread Steve Friedman ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- // -- Enrique Ramirez Irizarry Lead Developer Indie Code Labs http://www.indiecodelabs.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Trim everything that is entered into database
I'm guessing he means like automatically (IE using triggers). Which also would be my answer (use triggers). On Tue, Sep 9, 2008 at 1:52 PM, P Kishor [EMAIL PROTECTED] wrote: On 9/9/08, Josh Millstein [EMAIL PROTECTED] wrote: Hello, Is there anyway to perform a trim to everything that is entered into a table instead of trimming before I put data in? aren't perform a trim to everything that is entered into a table and trimming before I put data in the same actions? Thanks, Josh -- ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Puneet Kishor http://punkish.eidesis.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- // -- Enrique Ramirez Irizarry Lead Developer Indie Code Labs http://www.indiecodelabs.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] GCC give a warning while passing a struct as the, user data to the callback function of sqlite3_exec()
Looking at your address I can see you also use gmail. Threading for this message is working fine for me. Are you using the web client or an external mail program? On Tue, Aug 19, 2008 at 8:58 AM, Midmay [EMAIL PROTECTED] wrote: Greetings, As Michael Knigge has suggested, you may just rename the parameter to something else and then have something like MyStruct* data = (MyStruct*)foo; as the first line in your callback() function. Got it. Sorry but I make a mistake before, the '3rd argument' ought to be '4th argument', so the question should be: It means that while passing the 4th argument in sqlite3_exec(), the argument has been casted to void* ? However, thank you for your explanation for the callback function. I have another problem now, it sounds silly but... Each time I reply, it create a new topic, but not listing the reply under the original mail. How to make my reply mail is exactly list under the original mail somebody posted? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- // -- Enrique Ramirez Irizarry Lead Developer Indie Code Labs http://www.indiecodelabs.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] GCC give a warning while passing a struct as the, user data to the callback function of sqlite3_exec()
I noticed what you mean (to reply to my own post). I just noticed the original subject and this thread's subject are different: (original) [sqlite] GCC give a warning while passing a struct as the user data to the callback function of sqlite3_exec() (this thread) [sqlite] GCC give a warning while passing a struct as the, user data to the callback function of sqlite3_exec() Notice the comma? Maybe you modified it by mistake. Gmail uses subjects to thread messages. Hope this helps, On Tue, Aug 19, 2008 at 8:58 AM, Midmay [EMAIL PROTECTED] wrote: I have another problem now, it sounds silly but... Each time I reply, it create a new topic, but not listing the reply under the original mail. How to make my reply mail is exactly list under the original mail somebody posted? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- // -- Enrique Ramirez Irizarry Lead Developer Indie Code Labs http://www.indiecodelabs.com -- // -- Enrique Ramirez Irizarry Lead Developer Indie Code Labs http://www.indiecodelabs.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Using SQLite as an application file format (C++)
Although most of the online documentation for SQLite is OK, I had to go all the way and buy The Definitive Guide to SQLite by Michael Owens to answer most of my nuts and bolts inquiries on the matter. Most of what you describe seems to be doable without too much hassle. On Mon, Aug 18, 2008 at 2:32 PM, D. Richard Hipp [EMAIL PROTECTED] wrote: On Aug 18, 2008, at 2:17 PM, Darren Landrum wrote: An object of the class Preset will have the functions to load a database into memory Why do you want to load the database into memory? Why not just open it and use it off of disk? D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- // -- Enrique Ramirez Irizarry Lead Developer Indie Code Labs http://www.indiecodelabs.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLITE_prepare/bind to exnter data or just query?
flakpit [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I've been using the column_text type to get back a block of text and it's being truncated at the first CR/LF pair in the text block and I can't help thinking that I could have avoided this somehow by entering it with a prepared statement. Or am I completely wrong? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users Depends on where you're looking at your block of text. Are you using a GUI SQLite Manager of sorts, or maybe peeking at the variable's contents from a dev IDE? -- // -- Enrique Ramirez Irizarry Lead Developer Indie Code Labs http://www.indiecodelabs.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite + .net cf
Have you looked into the ADO.NET provider from http://sqlite.phxsoftware.com/? It also works on the .Net Compact Framework. On Sat, Jul 26, 2008 at 6:09 AM, Tom Lancaster [EMAIL PROTECTED] wrote: Hi, i'm considering using sqlite as a replacement for sql server ce in a mobile device that periodically syncs with a web server. I wish to use sqlite because I will be able to assemble the whole new database for the mobile device on the web server and send it back in its entirety. What I would like to know from others who might have experience is: would I need to restart my mobile application in order to see the new database. I ask because sqlite is an embedded thing rather than a database server; perhaps data is cached in-memory. Thanks for you help, Tom ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- // -- Enrique Ramirez Irizarry ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Overall question about transactions
Hello to all, I've been working on DBMS systems for a couple of years now (namely MS-SQL and MySQL) and I find SQLite's usage of transactions to be quite unique and interesting. I've been reading on different websites about them and one particular site (which sadly I can't remember) confused me a bit. They were recommending that transactions be used even on select statements if they were consecutive. I find this confusing since I thought transactions were only useful if you are making changes and want a mechanism to rollback changes if errors occur. So from what I gather, pseudocode like this should theoretically work correcty: Start Transaction; Query the database; Do the needed operations on the resultset; Query the database with a different query; Do the needed operations on the resultset; Commit Transaction; My questions are then, 1) is this correct? 2) if no changes are being made to the database, what is being commited? 3) is the 'optimization' coming from preventing SQLite from generating a new transaction for each query? And an off-topic question if I may, is there a way to browse through archives of older mailings? I'd hate to ask questions that have been answered thousands of times. Cheers, -- // -- Enrique Ramirez Irizarry ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users