> Works fine for me on both Linux and Windows7, for SQLite version 3.7.16.2
> and 3.7.17 (beta).
It also works for me on linux. I'v looked what is happening on vista and it
doesn't crash but silently exists. fgets() in local_getline() is returning 0
when n is 0. My problem with small nField on
Table was created by copying data from other database:
C:\>sqlite3.exe db
SQLite version 3.7.16.2 2013-04-12 11:52:43
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> attach 't68286' as x;
sqlite> create table tabela_analityczna as select *, 1 from
x.tabela_analit
select * from tab
id | a | mtime |
+--++---+--
1 | 1 | 3 |
1 | 2 | 2 |
1 | 3 | 4 |
1 | 4 | 2 |
1 | 5 | 7 |
2 | 6 | 1 |
2 | 7 | 0 |
2 | 8 | 4 |
2 | 9 | 1 |
2 | 10 | 2 |
select id, a, min(mtime) over(partition by id order
SQLite version 4.0.0 2012-07-07 12:21:48
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> create table t(a);
sqlite> insert into t values(123);
sqlite> insert into t values(123.0);
sqlite> insert into t values(12323);
sqlite> insert into t values(12323.0);
sqlite> s
> Do other SQL database engines not have this same limitation?" Are MySQL
> and PostgreSQL and Firebird and MS-SQL and Oracle creating phantom
> indices on-the-fly to help them do joins faster, for example?" Or do
> their optimizers do a better job of finding ways to use indices in a
> join?"
> These are simulated malloc() failures. They are important for embedded
> devices (which tend to run out of memory) but not so much on Solaris.
> When was the last time you remember that malloc() really failed on a
> workstation or a server?
It's very easy to cause malloc failure on 32
I find those diagrams less readable than text version. There are
other problems besides my personal preferences:
- text cannot be copied from pictures
- syntax cannot be viewed with text-only browsers
- site loads a little longer (there are still people that don't use broadband)
-
> Hi! I need to download sqlite (exe), dll and source code of sqlite 3.4.2 but
> I don't find it. Does someone know where to get it ?
This will show when every sqlite version was released.
http://www.sqlite.org/cvstrac/timeline?d=1&e=2008-Sep-26&c=0&px=&s=9&dm=1&dt=1&m=1&x=1
Checkout from cvs
> Is there a performance hit assosiated with manifest typing?
I'm not sure about performance, but I assume that static typing might reduce
memory usage (especially with small caches). Internally every type in sqlite is
stored in structure that takes 64 bytes (little more on 64 bit systems).
Dif
> See http://www.sqlite.org/cvstrac/tktview?tn=2574
>
> Apparently VC++ does not like for you to declare a constant
> with file scope before the constant is defined. I do not
> know how to work around this problem. Perhaps someone who
> better understands the quirks of VC++ can help.
VC doesn'
> The code changes are not that complex. The hard part is getting
> me to agree to such a change. Surely by now you have come to
> better understand my views toward static typing
Isn't this decision already made? Strict affinity mode is mentioned on
official SQLite site suggesting that it
> I'm writing an article about SQLite and I'd love to get some comments
> from users about why you use it. Performance? Features? Reliability?
> Cost?
- no restrictions, like only 1 LONG VARCHAR in the table, numer of columns,
maximum network packet size and similar (actually there are some
re
> Change the 5000 to 5 and it crashes here on linux too.
I guess your compiler's default stack limit is big. I tested real query on
linux too and it crashed really fast. But satck size was limited by default
java's value, not gcc's limit.
> Maybe
> we need to limit the number of SELECT sta
> There have been some recent changes to try to address this
> by placing various limits on number of columns, length of
> SQL expressions, length of SQL statements etc. See:
>
> http://www.sqlite.org/cvstrac/fileview?f=sqlite/src/limits.h&v=1.6
Nice. Limit is much better than a crash. But I h
> Excuse me for make this question but have you
> normalized your database? Try to design/define it in at least 3NormalForm.
My application's doesn't create any databases itself. It allows users to
store any data. And users need to be able to store any number of columns in
1 table (the mos
> >> Does
> >> using separate databases and attaching them improve concurrency (by
> >> providing finer-grained locking)?
> >
> > Yes it does. You can open a connection to a memory database, store each
> table
> > in a separate database and attach them if needed. I'v already changed
> > sqlite t
Joe Wilson napisaĆ(a):
> Please respond to the mailing list in the future.
Sorry. Different client. I didn't notice the adress.
> At least there's a known workaround, so no problem.
Workaround is not a solution.
>
> > > hence your problem.
> >
> > Sure it is. Just like any bug or missing feat
I'v read in change log that some stack allocted memory were moved to the heap,
but I think that there is still to much allocated memory on the stack.
After creating a table with 2000 columns, jdbc driver created a query that run
out of stack. Default java's stack limit is low, but it wasn't hard
> My project is working with Tomcat, SQLite and javasqlite.
> http://www.ch-werner.de/javasqlite/
>
> http://www.ysalaya.org
>
> Since a few weeks Tomcat server crashes very often: error 505
> and I need to restart it manually. It is installed on FreeBSD 5.4.
>
> Please see the Tomcat log file
> When you have a connection with multiple attached databases and the
> connection acquires an exclusive lock, does it always lock all attached
> databases or does it keep track of which databases require the lock?
1st process:
C:\Documents and Settings\Administrator\Pulpit>sqlite3.exe a.db
SQLi
> Sqlite lets us advance our storage
> capabilities into a more flexible world.
Sure, but it's not allways a good thing. Usually one column stores related
data.
Related data mostly have the same type. Entering a value of different type is
an error
which is silently ignored. Allowing different
> I for one would be in favor of an option to enforce strict
> typing (compile time option).
"SQLite version 3 will feature two other affinity modes, as follows:
Strict affinity mode. In this mode if a conversion between storage classes is
ever required, the database engine returns an error and
> SQLite does not have a dedicated DATE type.
I know that, but why it does't create appropriate column definition ?
create table tab(col date);
creates a table with "date" type.
create table tab2 as select * from tab;
also.
This type does't do much, but it can be queried with sqlite3_column_dec
Hello
I'm wandering if CAST is supposed to work?
Documentation says that it "changes the datatype of the into the type specified
by ".
However I don't observer any change. It even alters data in not obvious way:
SQLite version 3.3.17
Enter ".help" for instructions
sqlite> create table tab(col
I haven't used SQLite for that yet (I will in the near future) but with mysql
my longes statement was at least several megabytes.
I create statements automatically. I think so far the longes created
statement was a PCA trafsformation from table with about 2000 columns
(would have been more if m
> When testing, it is my usual practice to compile with
> -DSQLITE_NO_SYNC=1 which turns off disk syncing. This
> very definitely makes the tests run way faster. I
> wonder if the Makefiles you are using are not setting
> this option by default on windows but are on linux?
On windows this opti
Is there a reason why ALTER TABLE ADD can add only one column?
I'v changed the parser to allow any number of columns - I'm calling
sqlite3AlterFinishAddColumn() for every column. It seems to work.
Am I missing some problem, or nobody wanted more columns before?
Wiktor Adamski
> I know this is the behavior for MySQL, but not sure about SQLite.
I'v heard about some version of mysql that didn't return rows in the same
order (but haven't seen it myselt). So unless this behaviour is documented
in mysql manual, it's not a good idea to rely on this. Actually I'v seen
only
> The offending lines are
> tclsqlite.c:
> EXTERN int Sqlite3_Init(Tcl_Interp *interp){
> Tcl_InitStubs(interp, "8.4", 0);
> Tcl_CreateObjCommand(interp, "sqlite3", (Tcl_ObjCmdProc*)DbMain, 0,
> 0);
I simply removed EXTERN from source and there were no other compile errors.
But there were ot
> Hello All
> iam java starter and love sqlite . when i download java wraper for sqlite
> this is good work in windows but it cant work in linux .i have this
> exception "not found libraryjsqlite.so" Althought, i download sqlite.so and
> rename to it .where is solution
export LD_LIBRARY_PATH=di
> I have been unable to get this package to compile under Linux. Do you use it
> in Linux, or Windows?
I remember I also had problem compiling this. It didnt find some executable.
I'v downloaded missing executable, put it in PATH and there were no other
problems.
But actually it isn't necessary
> Where can I get 3.3.9 and earlier source code?
http://www.sqlite.org/sqlite-source-3_3_0.zip
...
http://www.sqlite.org/sqlite-source-3_3_9.zip
But it would be nice to have direct link on the website, or even better to
have tags for all releases in CVS.
---
> If you use LIMIT/OFFSET without an
> explicit ORDER BY, you are relying on an implementation detail.
Yes, but SQLite is an implementation. If it returns rows allways in the same
order I don't see why it shouldn't be acknowledged - one mention in a
documentation would make it a feature, and I
> I believe that the SQL spec doesn't
> specify the order of returned rows if you don't specify an order.
SQL doesn't, but SQLite might. Without maintaining order OFFSET (also not
part SQL standart) without ORDER BY wouln't make much sense.
---
> Can somebody who understands or regularly uses windows please
> look into it for me.
It seems like changing
nByte = GetFullPathNameW(zWide, 0, 0, &zNotUsedW) + 1;
to
nByte = GetFullPathNameW(zWide, 0, 0, &zNotUsedW) + 3;
corrects the problem.
According to documentation even that + 1 isn't ne
Hi
Can someone tell me why attach cannot be called within transaction? It does
change internal structures, but id doesn't change any tables. And even if it
would have, I think changing tables in the same connection should be allowed.
Wiktor Adamski
--
Hi
I need SQLite to be able to acces several tables at the same time. I'v decided
to do this by creating a new database for each table. So far I'v changed
sqlite3StartTable() function - it calls attachFunc() and then changes name to
name.name. It worked - master database is not changed, and n
37 matches
Mail list logo