World: r3wp

Petr, the new SQLite 3.5.3 release states:


Fix a long-standing bug in INSERT INTO ... SELECT ... statements 
where the SELECT is compound.

Maybe that's the problem?

gee, what are they doing? 50KB more size of dll to fix few bugs? 
They should aredy fix their docs whee they claim that other engine 
libraries start at 450KB ... they are nearly there too ...

... and they definitely should completly remove their claim that 
1 file for db is an advantage. That is the most serious obstacle 
of sqlite ... simplicity comes via ability to easily backup ... one 
file per index, table ...

Robert - tried that. Sadly it does not fix the issue. I will try 
to get to their ml and post the finding. Maybe I am doing something 
incorrectly, otoh I think that corruption should never happen, even 
if query would be nonsense :-)

Well, simplicity lies in the eyes of the beholder ... just having 
to back up a single file seems pretty easy to me ...

me too

if that size is not necessarily 100MB and you don't need to back-up 
all the files all the time ....

..then why don't you just back up the tables that you ?

..want ????

you can, by creating some code to do so, not by simply looking into 
the directory and using default OS facilities.

well, SQLite is really cool, but simply noone can defend that one 
argument to me. I also communicated that "defficiency" on their ml, 
and simply put - it is the way it is. 'Attach function is just nasty 
workaround, nothing more. But - I talk about some 5% of feature, 
which would I found usefull, I will use sqlite anyway, as simply 
put there is no simple replacement to what it provides ...

I didn't think that you needed to write any code to backup individual 
tables in SQLite but just supply the table name as a parameter to 
the .dump command.

I believe you can do this from the command line with SQLite3.

It seems I found a bug :-) http://www.sqlite.org/cvstrac/tktview?tn=2832

I ask here too, I want to adopt a database system for my rebol projects: 
which are the advantages of SQLLite over RebDB ? Why should adopt 
the first or the latter ?

I ask here too
 No need to cross post. We can all see the messages.

SQLite has one main advantage - it supports SQL like syntax - you 
can join tables. I can't imagine living without those features anymore.

RebDB is also mostly - in memory only database. It does not live 
on hd. So - SQLite has one advantage here - it supports locking over 
file-shared SQLite database.

Sorry Henrik my intentions where not to SPAM, I have later found 
the SQL lite group than the RebDB. Promise I'll write only once starting 
from now. Don't be upset :-)

That is still not full-fledget SQL server - those provide you with 
network independent access ...

Pekr, joining tables and having the data on disk are already two 
good points for SQL Lite. Obviusly I need Rebol/Pro licence before 
using it.

not necessarily.

I ahve read in the doc that Rebol/Pro is necessary. Could you explain 
?

Well - there is btn-sqlite (better than nothing) driver on rebol.org 
It works, with one bad effect - black console window appearing during 
the shell call. Just recently I put it on high priority list for 
W.7.6 to be fixed - all is needed is to set one flag for shell call 
....

I hope that it gets fixed.

Thanks pekr, I'll take a look at it. Next year, when I'll have more 
knoledge in RebGUI and Rebol2 I need to start a project which needs 
a database but it will be a single user project so SQL lite.is good 
enough.

Next year you will be using R3 :-)

Then I'll give me Rebol/Pro or the whole command/sdk as present.

NO, I want to use R2. I will be using R3 only for small projects 
and to help the comminity into debugging ! Have you already read 
what I think about people complaining R3. Your is a provocation !!! 
:-)))))

To GiuseppeC there is a simple server based on SQLite look at SQLIte 
Wiki/SQLiteNetworks/uSQLiteServer a protocol to this is also in rebol.org.


Anyway I can tell you a secret not to tell anybody: try to use rebface.exe 
from public available REBOL/SDK 2.7.5 BETA . It seems the /Pro restriction 
is not applied there for some reason and SQLite protocol works sweet 
for me there.

You can got  an idea run "local database backend" in one rebface 
process and application in another on rebol version of your choice. 

THANKS ASHLEY FOR A GOOD JOB.

Now I expect a totally free Rebol/Command :-)

You don't need /Command SQLite, just library access and you get that 
in /Pro. There are other advantages to /Command though.

I know. I will buy the /pro version next year and the whole package 
when my application will be ready.

(Hoping in a free upgrade to R3)

Petr, congrats to really find a bug. I think I have been hit by this 
one too.

I will make an update of the SQLite engine. I'm still using a rather 
old one.

New version released ... hehe, my ticket is part of the announcement 
:-) http://www.sqlite.org/news.html

what's sqlite's domain?

what do you mean by "domain"?

I can confirm it fixes data corruption for my case. Nice fix!

do you mean domain of usage? or?

domain of use

single user apps. Or fileshared ones. Embedded space. Advantage against 
mySQL embedded - SQL interface, free. Not easily used for server 
solutions, although could be solved by some server dispatching requests. 
No installation, just one single dll.

message board??

probably not from what you say.

Why not? It's ACID compliant and SQLite on a server where all file 
ops are local to the DB process seems OK to me.

From "Suggested Uses For SQLite" ( http://www.sqlite.org/features.html
)

Website Database

 Because it requires no configuration and stores information in order 
 disk files, SQLite is a popular choice as the database to back small 
 to medium-sized websites

Stand-in For An Enterprise RDBMS

 SQLite is often used as a surrogate for an enterprise RDBMS for demonstration 
 purposes or for testing. SQLite is fast and requires no setup, which 
 takes a lot of the hassle out of testing and which makes demos perky 
 and easy to launch.

Is there any commonly suggested server mode? I mean tcp server, serialising 
requests, querying db and returning results back to users?

It is usually suggested that you build your own wrapper. REBOL/Services 
would be good for this.

BTW, your new release doesn't seem to be downloading :(