Re: [sqlite] How do I do this join on multiple columns?

yaconsult wrote: > SQL newbie here. I have data in a couple of tables that I need to relate. > But I don't know how to relate on more than one column. I'll not go into > detail about why the data is formed the way it is - it comes from other > programs. > > For example, let's say there are a

Re: [sqlite] Performance impact for heavy accessing the database file

On Mon, Mar 2, 2009 at 9:24 PM, Eversogood wrote: > Hi, > > How is the SQLite performance when a lot number of concurrent users access > the database file? > why? what have you experienced? Puneet. ___ sqlite-users mailing list

[sqlite] Performance impact for heavy accessing the database file

Hi, How is the SQLite performance when a lot number of concurrent users access the database file? Thanks, Ev ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3_finalize and threading (was sqlite_master table and SQLITE_MISUSE)

On Mar 2, 2009, at 9:52 PM, Lukhnos D. Liu wrote: > Hi, > > I posted a question a few days ago on the cause of getting > SQLITE_MISUSE when I called sqlite3_prepare_v2. I thought I both ruled > out the possibilites advised by the replies and solved the probelm by > finalizing statements on the

[sqlite] sqlite3_finalize and threading (was sqlite_master table and SQLITE_MISUSE)

Hi, I posted a question a few days ago on the cause of getting SQLITE_MISUSE when I called sqlite3_prepare_v2. I thought I both ruled out the possibilites advised by the replies and solved the probelm by finalizing statements on the sqlite_master table earlier. Well the problem didn't get

Re: [sqlite] How do I do this join on multiple columns?

Rich Shepard wrote: > On Mon, 2 Mar 2009, yaconsult wrote: > > >> SQL newbie here. >> >If you'll be doing a lot of coding in SQL, take a look at Joe Celko's > other books. He's been writing on database issues for more than a quarter > century, and I remember reading his columns in DBMS

Re: [sqlite] How do I do this join on multiple columns?

Hi ya (well that's the only name you give ;-) ) > SQL newbie here. I have data in a couple of tables that I need to > relate. > But I don't know how to relate on more than one column. > For example, let's say there are a couple of tables: > > server login name last_login email ... > > and we

Re: [sqlite] How do I do this join on multiple columns?

On Mon, 2 Mar 2009, Rich Shepard wrote: > Two books you should seriously consider purchasing are Rick van der Laan's Correction: his name is Rick van der Lans. Rich -- Richard B. Shepard, Ph.D. | IntegrityCredibility Applied Ecosystem Services, Inc.|

Re: [sqlite] How do I do this join on multiple columns?

On 3/03/2009 12:48 PM, yaconsult wrote: > SQL newbie here. I have data in a couple of tables that I need to relate. > But I don't know how to relate on more than one column. I'll not go into > detail about why the data is formed the way it is - it comes from other > programs. > > For example,

Re: [sqlite] How do I do this join on multiple columns?

On Mon, 2 Mar 2009, yaconsult wrote: > SQL newbie here. Allow me to offer a recommendation rather than a solution to your problem. (I'd want more information on the attributes in each table before suggesting a SELECT statement.) Two books you should seriously consider purchasing are Rick

[sqlite] How do I do this join on multiple columns?

SQL newbie here. I have data in a couple of tables that I need to relate. But I don't know how to relate on more than one column. I'll not go into detail about why the data is formed the way it is - it comes from other programs. For example, let's say there are a couple of tables: server

Re: [sqlite] Data Modeling Tools

On Mon, 2 Mar 2009, Mike McGonagle wrote: > I am working on a project that is based around SQLite as a data format (so > to speak), and as such, I would like to be able to show others various > diagrams of the data models. Are there any programs that will work with > SQLite directly? Or any

[sqlite] Data Modeling Tools

Hello all, I am working on a project that is based around SQLite as a data format (so to speak), and as such, I would like to be able to show others various diagrams of the data models. Are there any programs that will work with SQLite directly? Or any generic tools that anyone could suggest?

Re: [sqlite] INSERTing OR REPLACEing Together or one at a time

"Martin Engelschalk" wrote... > Hi, > > If you could post how it does fail, exactly, maybe we can help > > Martin I wish I could... the wrapper that I have is very old and I have put too much time on this to update, right now. I am sure it is the wrapper, since most times it works and

[sqlite] Is snapshot backup supported for SQLite2?

Hello Folks, I am dropping by to get a definitive answer to a question recently raised. Can anyone here tell me definitively if backing up SQLite2 by taking a snapshot of a live database is supported? The particular operating system is Solaris 10 but I am curious about any platform where

Re: [sqlite] Joins

On Mon, 2 Mar 2009 13:59:13 -0500, "Fazoogled" wrote: >I used to have a good cheat sheet on Joins that I cannot find anywhere. Must >have been cleaning house and had a \delete' attack. But I'm going to need it >for a little exercise I'm doing at home where I have a many to

[sqlite] Joins

I used to have a good cheat sheet on Joins that I cannot find anywhere. Must have been cleaning house and had a \delete' attack. But I'm going to need it for a little exercise I'm doing at home where I have a many to many table with a 'connector' (what I call it) table in between. I'm going to be

Re: [sqlite] INSERTing OR REPLACEing Together or one at a time

Ok. That is what I am doing now. Every so often, it fails, for some reason. It could be a network problem, but I don't think so. Anyway, thanks for the help. josé - Original Message - From: "Martin Engelschalk" To: "General Discussion of SQLite

Re: [sqlite] Random Syntax changed in 3.6.11?

Hello, DRH, On Mon, Mar 2, 2009 at 6:32 PM, D. Richard Hipp wrote: > The RANDOM() function takes zero arguments.  This has always been the > case.  But 3.6.11 has begun to enforce that rule.  Prior to 3.6.11, > the error was ignored. Oh. That explains it. Thanks -- Alberto

Re: [sqlite] Random Syntax changed in 3.6.11?

Hi, in http://www.sqlite.org/lang_corefunc.html the random() function is documented as taking no arguments, So, use SELECT word FROM dict ORDER BY RANDOM() LIMIT 1; I tried an older version of sqlite (can't say which, but 3.*), and could call random() with 0, 1, 2, 3 and 4 parameters. I would

Re: [sqlite] Random Syntax changed in 3.6.11?

On Mar 2, 2009, at 1:16 PM, Alberto Simões wrote: > Hello > > I am using random as: > > SELECT word FROM dict ORDER BY RANDOM(term) LIMIT 1; > > And I am getting: > > DBD::SQLite::db prepare failed: wrong number of arguments to function > RANDOM()(1) at dbdimp.c line 271 at OpenDict.pm line 64.

[sqlite] Random Syntax changed in 3.6.11?

Hello I am using random as: SELECT word FROM dict ORDER BY RANDOM(term) LIMIT 1; And I am getting: DBD::SQLite::db prepare failed: wrong number of arguments to function RANDOM()(1) at dbdimp.c line 271 at OpenDict.pm line 64. (yes, using it through DBD::SQLite, but I do not think that is the

[sqlite] INSERTing OR REPLACEing Together or one at a time

Greetings. which command is safer to use: Command #1: BEGIN; INSERT OR REPLACE INTO LSOpenProjects SELECT * FROM c.LSOpenProjects WHERE ProjID = 2000; COMMIT; BEGIN; INSERT OR REPLACE INTO LSOpenSubProjects SELECT * FROM c.LSOpenSubProjects WHERE ProjID

Re: [sqlite] View - What happens internally

Thank you Igor and Dan. Now I am clear about the concept. On Sat, 28 Feb 2009 20:07:45 +0530, Dan wrote: > > On Feb 28, 2009, at 8:44 PM, Lloyd wrote: > >> >> Hi, >> >> When we create a view what happens internally in sqlite? Does it >> select >> all the data from the

[sqlite] memory allocation in sqlite3

hi, i have a project about memory statistics, and i must get transition of memory during execution of sql statement, i used Hook API to hook SqliteMalloc, SqliteRealloc and SqliteFree, but it is well with sqlite2, and sqlite3 fail thanks, -- Nguyen Duc Chinh Email: ducchin...@gmail.com Mobile:

Re: [sqlite] Sqlite write ( HELP )

On Mar 2, 2009, at 1:12 PM, Rajesh Nair wrote: > Hi all > > When I use INSERT INTO stmt how fast sqlite writes it in to the > database. Is it depends up on the OS. Will the record be written to > the database on returning from the exec of INSERT stmt? Results should be in the db when the