> 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
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
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
> 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.
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
>
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
).
(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
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
> 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
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
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
> 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 ,
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
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
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
> 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
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
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
__
(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
= 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
> 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
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
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.
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
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
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
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
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
__
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
_
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
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
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
>
"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,
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
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
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,
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
>
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
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>:
>
> &
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"
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
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
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,
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
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
;
> 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
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
>
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
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
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
>>
> ___
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
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
> 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
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
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:
>>
>>>
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-
>
> 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
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
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/
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
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
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
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
>
> 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'
> 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
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 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
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
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
69 matches
Mail list logo