Re: [sqlite] Bug

> SQLite version 3.7.5 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> CREATE TABLE t1 (a INT); > sqlite> CREATE TABLE t2 (b INT); > sqlite> CREATE TABLE t3 (a INT); > sqlite> SELECT * FROM t1 JOIN t2 ON t1.a = t2.b AND a /* obviously > t1.a */ != 1 JOIN t3

Re: [sqlite] Hello.. I want to translate SQlite.org into Korean language version.

org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > Artur Reilin sqlite.yuedream.de ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] uuid generation in sqlite

ions can generate globally unique identifiers using this function together with hex() and/or lower() like this: hex(randomblob(16)) lower(hex(randomblob(16))) Artur Reilin sqlite.yuedream.de ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Deleting the sqlite journal file?

> We've thought about that before, but never could come up with a reasonable > suggestion. > Something like an hash key in every db and also in a journal, if it is created, the same key as well. So if the db hash key and journal hash key doesn't match, the journal will not be used.

Re: [sqlite] Merry Christmas

Discussion of SQLite Database >> Subject: Re: [sqlite] Merry Christmas >> >> +1 >> >> On Dec 25, 2010, at 12:31 AM, Artur Reilin wrote: >> >>> Merry Christmas to the whole mailing list and your families :) >>> >>> >>> Artur Reilin >

[sqlite] Merry Christmas

Merry Christmas to the whole mailing list and your families :) Artur Reilin sqlite.yuedream.de ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] does sqlite differ between char, varchar and text?

). (Yeah, I know SQLite(2) is old and such, but I'm still at the position, that I only can use this version for my site.) with best wishes Artur Reilin sqlite.yuedream.de ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin

Re: [sqlite] new user

a similar question already somewhere in the archives. Artur Reilin sqlite.yuedream.de ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite Documentation v2

> Artur Reilin <sql...@yuedream.de> ïèñàë(à) â ñâî¸ì ïèñüìå Fri, 10 Dec 2010 > 23:51:31 +0600: > >>> SQLite Documentation (unofficial, HTML Help version) has been updated. >>> >>> Changes: >>> >>> - keywords list (index) extended with ma

Re: [sqlite] SQLite Documentation v2

ht-click on the > file in Explorer, then click "Unblock") - thanks to Luuk34 for the tip. > Thanks. Now I can search for all the things. > Also thanks to Artur Reilin for nice feedback and advises about the docs. > :) > Enjoy! > > -- > Regards, > Serge Igitov Th

Re: [sqlite] SQLite Documentation

3.zip" file. > Feel free to use it if you like. Any comments/suggestions are welcome. > And thank you for the SQLite :) > > Regards, > Serge Igitov (Dagdamor) > www.phpc.ru > ___ > sqlite-users mailing list > sqlite-users@sq

Re: [sqlite] query question

> Artur Reilin <sql...@yuedream.de> wrote: >> CREATE TABLE [challenge_players] >> ( >>[player_id] INTEGER PRIMARY KEY , >>[player_name] TEXT >> ) >> >> CREATE TABLE [challenge_wins] >> ( >>[round_id] INTEGER PRIMARY KEY ,

[sqlite] query question

tried to do a joined select to get the both tables together. I want to sort them after how much wins a player has. Something like: player_id = 1; player_name = testuser; player_wins = 3; I hope you have an idea for me. with best regards Artur Reilin sqlite.yuedream.de

Re: [sqlite] Inserting images (gif) in Blob field (with php)

he whole folder in database. So thanks to you both for the information. Now we have an image example input in the archives. ;) With best wishes. Artur Reilin sqlite.yuedream.de ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Inserting images (gif) in Blob field (with php)

nths. (nothing found anyways) With best wishes Artur Reilin sqlite.yuedream.de ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Suggestion for project: Chat

> On Tue, Aug 24, 2010 at 10:23:55PM +0530, Roger Binns wrote: >> On 08/24/2010 09:51 PM, Artur Reilin wrote: >> > I thinking about coding a chat with sqlite. >> >> The hard part of implementing chat is not storing the messages, but >> rather dealing w

[sqlite] Suggestion for project: Chat

chat system xD. With best wishes Artur Reilin sqlite.yuedream.de ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] partial index?

thing, that I don't get is: Why should the rows be hidden? If the index ist just used to cover some special values, it didn't hide others. If you create an index on some columns, it didn't hide the other columns, or? Artur Reilin sqlite.yuedream.de __

Re: [sqlite] Reserve database pages

(from an earlier reserve) is not fully filled, you have an empty place there. it fills this one and goes to the other free place. So at the end it doesn't change anything. Am i right? Artur Reilin sqlite.yuedream.de ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Problem with time

= to much columns i think. with best wishes Artur Reilin sqlite.yuedream.de ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Searching in multiple tables .

> INTEGER Object > TEXT Keyword > REAL Value > > Or perhaps you'd prefer to give each object a name: > > TEXT Object > TEXT Keyword > REAL Value Or both create table objects ( object_id integer, object_name text, object_keyword text, object_value real ); with best wishes Artur

Re: [sqlite] Mozilla History Autodelete

org:8080/cgi-bin/mailman/listinfo/sqlite-users > > Artur Reilin sqlite.yuedream.de ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Repairing a Database.

Software > www.HomeDesignerSoftware.com<http://www.homedesignersoftware.com/> > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > Artur Reilin sqlite.yuedream.

Re: [sqlite] Wiki need some update for SQLiteUsers

o longer exists". It's quit annoying... I think I will register on the wiki and clean some of these Sites. With best wishes Artur > > On 3 Aug 2010, at 12:09pm, Artur Reilin wrote: > >> I watching through the wiki to found things that are not correct and >> s

[sqlite] Wiki need some update for SQLiteUsers

to much poker/casino links.) Also there are many programs, which are outdated and not longer continued. Is it allowed to update all whose links? With best wishes Artur Reilin sqlite.yuedream.de ___ sqlite-users mailing list sqlite-users@sqlite.org http

[sqlite] Error in the documentation

Hello ^^ On the end of this site: http://www.sqlite.org/cvstrac/wiki?p=ManagementTools Is an error with the entities. http://www.areanda.com > http://www.areanda.com > This is written at the end. With best wishes Artur Artur Reilin sqlite.yuedr

Re: [sqlite] german locale: queries calculated float fields deliver wrong dec.sep.

ibrary for accessing SQLite converts numbers from and to your > locale format for numbers. > > Simon. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/ma

Re: [sqlite] What is the sqlite3 script suffix?

e3 databases. > -- > ( Kees Nuyt > ) > c[_] > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > Artur Reilin sqlite.yuedream.de __

Re: [sqlite] sqlite documents in pdf format

n is to convert html into pdf. > > -- > Regards, > Peng > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > Artur Reilin sqlite.yuedream.de _

Re: [sqlite] sqlite documents in pdf format

rg:8080/cgi-bin/mailman/listinfo/sqlite-users > > Artur Reilin sqlite.yuedream.de ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] bug report: unhelpful error message when directory permissions are wrong

nen > www.sange.fi > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > Artur Reilin sqlite.yuedream.de ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Feature request: hash index

Yep. A big change... Artur :3 - Am 05.04.2010, 16:11 Uhr, schrieb Roger Binns : > On 04/05/2010 05:45 AM, Alexey Pechnikov wrote: >> Is anyone interested in this feature? > > Wouldn't it require changing the file format? > > Roger >

Re: [sqlite] Is there an optimization for "IS NULL" operator in a SELECT query ?

"Select count(id) from table where text!='' or text!=NULL" is the same, right? As i see you want to count all rows, right? I don't know if it is faster to only count one column instead of *, but I using it the one-column-count way. Perhaps this helps too? Artur --- Am 28.02.2010,

Re: [sqlite] temp directory?

I meaned the php envirement variable. the TMP env for the temporally path of apache. But it doesn't work. But that's not the thing of sqlite3, then the thing that I use sqlite 2.8.17 databases and there the variable doesn't work. The Pragma temp_store and temp_store_directory works only

Re: [sqlite] OT: Sqliteman and its future

Hi Petr Vaněk, i really like the sqliteman, but there are some things that's not so great. - It seems that it don't support my databases (that are sqlite 2.8.17). I cannot open anyone of it. It says everytime, that this is probably not an database. But it is sure. - The insert of lines in

Re: [sqlite] Better information on how to use the sqlite list

If you set the setting, that you receive e-mails from this mailing list, then you can simply answer the mails, which you get. To add a question or a topic to the mailing list, simple write a e-mail to sqlite-us...@sqlite.org. That's all. - Artur - -- Am 03.01.2010,

Re: [sqlite] Storing large numeric values

02.01.2010, 11:55 Uhr, schrieb Simon Slavin <slav...@bigfraud.org>: > > On 2 Jan 2010, at 10:11am, Artur Reilin wrote: > >> According to this I have also a question. I use some values for some >> gamedata and use the played days, hours, minutes and seconds and put >

Re: [sqlite] Storing large numeric values

According to this I have also a question. I use some values for some gamedata and use the played days, hours, minutes and seconds and put them in one column. I use . as an seperator. Does it still is an integer or do i need to change the column type to text or blob? Using 4 columns - one

Re: [sqlite] Mozilla's method

If you are using something like an log system it would be better in this way, but in apps like an shop what wouldn't be so great. (thinking about ebay with the bets and such..) But the idea itself is nice. Am 02.01.2010, 00:14 Uhr, schrieb Olaf Schmidt <s...@online.de>: > > &

Re: [sqlite] Mozilla's method

But that means, if there is a power off or an system crash, your data which you send at this moment, goes nirvana. But indeed it would be faster and also would save the hard disc from some writing operations. Am 01.01.2010, 23:33 Uhr, schrieb Olaf Schmidt : > > "Bert Nelsen"

Re: [sqlite] SQLitedb problem

Because the data was deleted. If the data was deleted it doesn't mean, that the data is not more in the database. It just not overwritten or not cleaned by an vacuum command. Is that so hard to believe? Artur -- Am 28.12.2009, 19:09 Uhr, schrieb Othman Guessous

Re: [sqlite] Bulk Insertions allowing duplicate records even primary key existed

Hi Durga, double entries in the database shouldn't work. Seems to be a bug. Are these double entries have the same content? Or is it different? As I see your are inserting the same data through to different ways, right? Artur - Am 28.12.2009, 14:04 Uhr, schrieb Durga D

Re: [sqlite] SQLitedb problem

And I also don't think there is existing a application, that was made to read unused date in an SQLite database file. Deleted data is deleted. If you still want this data, then use an editor and copy the data out. If your sqlite application browser don't show these data, then all is said,

Re: [sqlite] SQLitedb problem

Are these data got deleted recently? Then it was only not overwritten yet. Artur -- Am 28.12.2009, 12:13 Uhr, schrieb Othman Guessous : > Hello, > > I wait for your help. Please can you answer to me ASAP. > > Thanks, > Othman. > > On Mon, Dec 21, 2009

Re: [sqlite] requesting 2 tables about one select

pe.id = siterate.type > where sitetype.status!=1 > > This supposes that for every entry in siterate, there exists an entry in > sitetypes with sitetype.id = siterate.type > > It seems to me that you might want to read up on SQL. > > Martin > > Artur Reilin schrieb: &g

Re: [sqlite] Corrupted database (image is malformed): always the same size

; > Simon. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > Artur Reilin sqlite.yuedream.de ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] requesting 2 tables about one select

terate > join sitetype on sitetype.id = siterate.type > where sitetype.status!=1 > > This supposes that for every entry in siterate, there exists an entry in > sitetypes with sitetype.id = siterate.type > > It seems to me that you might want to read up on SQL. > > Martin >

[sqlite] requesting 2 tables about one select

name,type from '.$databasename.'siterate where status!=1 order by name',$db); And i like that my query, that makes the type integer from siterate into the name text from sitetypes. Thanks forward for helping me. with best wishes Artur Reilin sqlite.yuedream.de

Re: [sqlite] Invitation to connect on LinkedIn

ttps://www.linkedin.com/e/isd/936554437/zokwXfFf/ > > > > -- > (c) 2009, LinkedIn Corporation > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > Ar

Re: [sqlite] The next release of SQLite....

ttp://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] Location of Sqlite Files

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 > > Artur Reilin sqlite.yuedream.de ___ sqlite-users mailing l

Re: [sqlite] temp directory?

ch the user under which the application is running, > has read and write access. > > Artur Reilin wrote: >> >>> You can try setting a temp or tmp or tempdir environment variable on >>> the >>> server, however, as I said in the previous post, I am not sure if i

Re: [sqlite] temp directory?

> You can try setting a temp or tmp or tempdir environment variable on the > server, however, as I said in the previous post, I am not sure if it > will work. > > Probably the safest and most robust way would be to have your code call > the pragma temp_store_directory directly after opening the

Re: [sqlite] temp directory?

sqlite is way old... so I'm > very unsure if anything I've suggested is of any use. I know the > environment variable did not work in 3.5.9, but does in 3.6 and up. > > Artur Reilin wrote: >> I can, but doesn't there exists an another way? >> >> >>> I

Re: [sqlite] temp directory?

I can, but doesn't there exists an another way? > I believe you can specify the directory in which temporary files will be > created. This is done with pragma temp_store_directory. I think you > can also set this in compilation. > > Artur Reilin wrote: >> >>>

Re: [sqlite] temp directory?

mations from the database. > Can you create a new blank database which is not malformed ? The database isn't malformed and it work right, but it seems not to work if i use oop. > Simon. with besth wishes Artur Reilin sqlite.yuedream.de ___ sqlite-

Re: [sqlite] temp directory?

> > On 19 Nov 2009, at 8:05am, Artur Reilin wrote: > >> My host have sqlite support vor sqlite 2.8.17 and i can use it. But i >> have >> to give chMod 0777 to the directory where i use sqlite. Not only on the >> directory, that contains the sqlite database. let m

[sqlite] temp directory?

directory. Is this normal and can i change this? with best wishes Artur Reilin sqlite.yuedream.de ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] german documentation

man. > > Though I would not like to do this work - there might be a community for > it ... > > Marten > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/

Re: [sqlite] german documentation

Hi, i changed the text to an newer version. Is this one better? http://sqlite.yuedream.de/Allgemein,Besonderheiten.html If you see something other strange. let me please know it, that i can change that to. with best wishes Artur Reilin >> Hi, >> that's bad if i sound li

Re: [sqlite] german documentation

ad translated? Yeah, it is a double exercise for me. In SQLite and in English. It helps me to improve both. with best wishes Artur Reilin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] german documentation

translator... > > sorry, but you ask for a feedback. > > beste wishes > > Marcus > > >> >> with best wishes >> >> Artur Reilin Hi, why i do this? There are more reasons why i do this. Because i translate this, i read all sites of the documentation and that's

[sqlite] german documentation

Hello, sorry for the double mail, but i cannot post to my old post. The german documentation is now on: http://sqlite.yuedream.de What do you think? Is the design good? with best wishes Artur Reilin - Artur Reilin sqlite.yuedream.de

Re: [sqlite] sqlite3_analyzer with 3.6.19 distribution

> > On Nov 12, 2009, at 4:36 PM, Artur Reilin wrote: > >> I also wonder, why the analyzer isn't working. I doesn't work for me. > > In what respect is it malfunctioning? > I've tried to use it in command line, but it didn't work; starting or put databases there, also don'

Re: [sqlite] image upload to db trouble

> On Fri, 13 Nov 2009, Artur Reilin wrote: > >> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> >> From: Artur Reilin <sql...@yuedream.de> >> Subject: Re: [sqlite] image upload to db trouble >> >>> //echo $image

Re: [sqlite] image upload to db trouble

rl')"); > > $db->query("DELETE FROM images WHERE id='$i'"); > } AS i know, if you want to put images in your db you need blob columns and these are supported in sqlite3. or i understand something wrong? Artur Reilin sqlite.yuedream.de _

Re: [sqlite] sqlite3_analyzer with 3.6.19 distribution

re is no reason the 3.6.0 version will stop working. > > Dan. > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > Artur Reilin sqlite.yuedream.de ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] any keyword

ent > team have a plan including the 'any/all' keyword implementation? I think > it should be > useful for many users. > Regards > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bi

[sqlite] german version of the site and buttons (again)

Hi again. I worked a little bit and i now have a beta version of the german variant: http://www.bilderload.com/bild/17772/capture09112009112707QWAQG.jpg Looks this okay? with best wishes - Artur - ___ sqlite-users mailing list