Hi, Ted.
You have reached the mailing list for SQLite, the database engine.
SQLite Manager is a completely separate, organizationally unrelated
product, and we probably won't be able to help you with whatever issues
you have with it. You will probably have better luck on the SQLite
Manager
will only be one item (unique :value) selected (LIMIT 1) can
> I make any performance improvements ?
>
--
Cu stima,
Mihai Limbasan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hi, Dave!
That piece of code comes from the macros inserted by the libtool
support. Normally, you should find the macro in
/usr/share/aclocal/lib-ld.m4 (at least on Fedora, Debian, and Gentoo.)
In case it's not there, I've reproduced the M4 macro below. Please note
that it's licensed as
) and use the extra pointer parameter to sqlite3_exec (the
"notused" one in your code) to pass the pointer to your CMainView
instance. Inside the callback you can cast that void pointer back to a
CMainView and invoke the "real" callback function which is a member of
your class.
Microsoft C++ compilers. If they're compatible, then all the
better, but I suspect compatibility will be one way only, i.e. with
MinGW's linker accepting objects produced by the Microsoft toolchain and
not the other way around.
HTH.
Mihai Limbasan
On 07/26/2009 12:46 AM, Roger Binns wrote
Fred,
Unfortunately, .lib (or, for that matter, .obj) files created by Borland
compilers are not compatible with the Microsoft toolchain, and
vice-versa. Borland uses a variant of the OMF object format, and
Microsoft uses a variant of COFF.
On 07/25/2009 08:09 PM, Fred Williams wrote:
> Paul,
Floating point representation issues. This is nothing out of the
ordinary, expect stuff like that to happen in any programming language
on any system. See David Goldberg's seminal paper "What Every Computer
Scientist Should Know About Floating-Point Arithmetic" here for details:
/project/downloading.php?group_id=87946=sqlite-1.1-src.tar.gz
If that version doesn't do the trick, you can try other versions of the
same project from
http://sourceforge.net/project/showfiles.php?group_id=87946_id=91778
Hope this helps.
Mihai Limbasan
On 06/06/2009 04:55 PM, Marcus Hassmann
Most likely you compiled the sources with debugging symbols turned on.
Are the resulting binaries still too big after you've run strip on them?
On 06/04/2009 09:57 PM, Mohey Eldin Hamdy wrote:
> According to http://www.sqlite.org/cvstrac/wiki?p=SizeOfSqlite
>
>with no optimization the
Hi,
A 30 second search on Google yielded
http://www.hwaci.com/sw/sqlite/sqlite-amalgamation-3_4_2.zip
HTH.
On 06/01/2009 02:29 PM, Buu Hao Tran wrote:
> Hi,
> We urgently need SQLite 3.4.2 source code buildable in Windows. Pls help!
> Thanks
> Chan
>
Have you also installed the corresponding development package? Don't
know its name, but typically if you install a package named abcdefgh,
its devel package is named abcdefgh-devel.
On 04/02/2009 10:20 AM, centipede moto wrote:
> I keep getting:
>
> undefined reference to `sqlite3_open'
>
>
You cannot do that. The dot commands are not SQL, and SQLite only
understands SQL. The dot commands are provided by the shell executable.
You could simply look at its source code, see how each specific command
is implemented, and reimplement that functionality in your app.
HG wrote:
> I want
manohar s wrote:
> Hi,
> I am trying to execute "PRAGMA page_size=4096; Vacuum;" on a SQLite DB(Size
> 1.5 GB), On a drive which has 9 GB free space (But my C: has 150 MB free is
> this an issue?). But it is failing with "SQL Error:Database or disk is full"
> error everytime. SQLite version:
Use % (percent instead of * and use _ (underscore) instead of ?
Pramoda M. A wrote:
> Hi All,
>
>
>
> I have to select using wild charcters? How to do it?
>
> For eg: I have to select field which should contain "sqlite"... Then
> *sqlite* is not working...
>
> Pleas help me.
>
>
>
> With
Oh, I understand now. Probably in the Database section.
vade wrote:
> Hello
>
> Thank you Mihai Limbasan.
> For your clarification, Now I'm Preparing my Profile(cv or resume). I just
> want to know where to show this sqlite3 skill.
> whether in Programing skill section or data
vade wrote:
> is sqlite3 is web skill OR database skill?
> can anybody please tell me...
>
> thank you in advance
>
SQLite 3 is a database engine - a library. Part of a computer program.
It's not a skill. A skill is an abstract concept.
Could you perhaps rephrase your question?
.
Hope this helps.
Mihai Limbasan
Rogério Costa wrote:
Hi,
Does any one know what means each of the values that are presented as a result of a
EXPLAIN command? Is there anything like an "query execution cost"?
Thanks
0|Trace|0|0|0|explain select * from a;|00|
1|Goto|0|1
Marian Aldenhoevel wrote:
> Hi,
>
> SELECT COUNT(*) FROM sometable;
>
> Takes 10 seconds on my testcase (340.000 rows, Database on CF, dead slow
> CPU).
>
> Is there a quicker way? Does SQLLite maybe store the total number of
> records somewhere else?
>
> The table only ever grows, there are now
consideration.
Mihai Limbasan
Please be aware
Aaron Smith wrote:
Heya guys,
iv got a database which was made my a program called BluePhoneElite, its a
Mac OS X piece of software which pairs with a mobile phone over bluetooth to
allow messages and calls to be managed from the computer... awesome piece
Stephen Oberholtzer wrote:
On Mon, Oct 13, 2008 at 12:52 PM, Doug <[EMAIL PROTECTED]> wrote:
I'm using SQLite 3.5.6 on Windows and intermittently get SQLITE_CANTOPEN
when doing an insert. When that fails, I can use the debugger to go back
up
and step through the same lines again (using the
Ribeiro, Glauber wrote:
You probably want to open your in-file database, open the :memory:
database, and copy all the data from the file to memory, do your
manipulations in memory, then copy back to file when you're done.
http://www.sqlite.org/cvstrac/wiki?p=InMemoryDatabase has a simple TCL
ble quotes) as the database name
when opening it. Be aware, though, that all tables and their contents
will disappear once you close the database connection.
HTH,
Mihai Limbasan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-b
w wg wrote:
Hi,
I want to get sqlite v3.3.6 , I have noticed the download page ,but I
don't understand cvs.
Can you help me ?
Thank you.
Hi.
If you don't want to bother with learning CVS to check out older
milestones, you could conceivably use your search engine of choice to
look for
Or to simply not release the same resource twice. That is clearly a bug
- the control flow in your application is incorrect if it does this. You
could work around it with the NULL value hack if you're short on time,
but I recommend trying to find out why this happens since bugs like
these
Aravinda babu wrote:
Hi all,
Does sqlite have any mechanism to determine if sqlite3_open has
created a new database or opened an existing database?
sqlite3_open returns SQLITE_OK for both creation and open
How can i check whether it created or opened an existing database ?
Thanks in
Andy Allord wrote:
I am new to SQLite 3 and I am wondering if there is a way to work with
foreign keys and set handling to cascade?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Daniel Larkin wrote:
Thanks for the super fast response! and for the clarification on how
I should be using the linker.
Most welcome.
My test program now compiles and links,
but when I try to run it I get a run time error saying"
"test: error while loading shared libraries: libsqlite.so.0:
Daniel Larkin wrote:
Hi all,
Hi there.
I've been playing around with SQLite through the command line
interface and with php and am very impressed. I'm now trying to use
sqlite with C++ but am running into a small problem when linking.
Firstly I'm using SQLite 2.8, which I compiled from
Igor Tandetnik wrote:
"q10" <[EMAIL PROTECTED]> wrote in
message news:[EMAIL PROTECTED]
Is there a way to drop a constraint from a table, something like this:
ALTER TABLE table_name DROP CONSTRAINT constraint_name?
Unfortunately, this command is not supported by SQLite3. Are there
other
Winanjaya wrote:
could any body please advise.. how to unsubscribe from this list?
TIA
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
You can change subscription options at your
Gilles Ganault wrote:
Hello
I need to write an application to manage appointments. Most of them
are recurrent, with no end-date, while others are one-shots, and the
user must be able to schedule reccurent appointments but be able to
tweak some of them if need be.
To investigate whether
Bruno Moreira Guedes wrote:
> And even with too many 'locking concurrency', I've done some stress
> testing and SQLite still very well. I've thrown the SQLITE_BUSY errors
> to a retry algorithm, which waits a random time in a time range and
> try again until a high number of retries. Using it,
sankar raman wrote:
hi,
this is shankar ,i am using sqlite in my website ,i am facing a problem
that is i a m unable to right the data in sqlite when i upload it in my
server space. but when i use it in local it is working ,i also give
purmision to read and right also.
please reply..
Igor Tandetnik wrote:
"Mihai Limbasan" <[EMAIL PROTECTED]>
wrote in message news:[EMAIL PROTECTED]
The sqlite3_open* family of functions expects the name arguments in
UTF-8 encoding.
Not quite. sqlite3_open16 et al expects UTF-16 encoding. Windows
supports UTF-16 nati
) and does the right thing
in ignoring the invalid characters, which is why you're seeing them as
stripped off.
Please make sure that the strings you are passing are encoded in UTF-8.
--
Multumesc,
Mihai Limbasan
___
sqlite-users mailing list
sqlite-users
kriscbe wrote:
thanks for eplay mihai
i am asking is there any function to check the database is opened or not
opened? in a single thread?
thanks
kris
No, there is no such function because
- you already know whether it's opened or not because you must store
the database connection handle
t;
> > Our software uses SQLite to save our data and we want to warn a user
> > who opens a file that is already opened by another user. I tried a
> > homebrewed approach (keep a table of open connections manually), but
> > ran into a couple places where that won't work.
> >
&
Doug Porter wrote:
Is there a way to get a list of connections that are opened on a
particular SQLite database file?
Our software uses SQLite to save our data and we want to warn a user
who opens a file that is already opened by another user. I tried a
homebrewed approach (keep a table of open
Mihai Limbasan wrote:
Hello there.
I've re-read your mail a few times, however you seem to have forgotten
to actually *ask the question.*
On a sidenote, though: You're storing the database connection in a
local variable (sqlSt) instead of returning it - so when you return
from the function
sqlite-users@sqlite.org
http://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
--
Multumesc,
Mi
Brown, Daniel wrote:
Perhaps, when is the next release due? I'd be interested to see the
differences, if an upgrade reduces memory overhead that significantly it
would be most excellent :)
3.6.2 is (tentatively) due this Monday :)
___
sqlite-users
/listinfo/sqlite-users
You take the header file from the amalgamation source tarball
corresponding to the version you're using?
--
Multumesc,
Mihai Limbasan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman
as shown by
select typeof(value) from test_table;
--
Multumesc,
Mihai Limbasan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
org:8080/cgi-bin/mailman/listinfo/sqlite-users
It's clearly a bug / limitation in the ODBC wrapper - it obviously
parses the SQL you're passing it and doesn't understand trigger syntax,
thus bailing out. You might want to contact the developer and ask
whether there are plans to update the
sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Is it possible that the database file is at the same time in use from a
different process? If yes, try shutting down the other database
consumers and retry then.
--
Multumesc,
Mihai Limbasan
___
Kodok Márton wrote:
Hello,
I use C# to connect SQLite.
connStr = @"Data Source=" + databaseFilePath + ";New=True;Version=3;";
conn = new SQLiteConnection(connStr);
I know I can add a Password=something; string to the connection string in
order to get a locked/encrypted database.
I am
Yes, please remove #3. Now is a particularly good time for it seeing as
the 3.6 line is quite new.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
csabi81 wrote:
> Hi everyone
>
> I want to clone a database: copy all data from original database to the
> destination database with a condition, so not all the entries need to be
> copied. I have tried the following:
> Obtain SQL from mastertable and create the tables in the new database, and
>
What does
ldd /path/to/your/compiled/libSqliteIcu.so
report?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Kevin Tang wrote:
Dear all,
After I upgrade to SQLite 3.6.0, I found that I must add "SQLITE_CORE" in
PreProcessor to build my program.
What is the "SQLITE_CORE" use for??
Thanks,
Kevin Tang.
When defined, SQLITE_CORE prevents the redefinition of some API
functions in sqlite3ext.h. From
kriscbe wrote:
> Thanks Mihai for u r response.
>
> with the help of sqlite3_prepare,sqlite3_step,sqlite3_column_int() functions
> i am getting the values in my c++ program.
> i will try u r way also(for the time being not executed it now)after trying
> that i will send my response
>
If you're
Joanne Pham wrote:
> Hi All,
>
Hi there.
> Currently we are using 3.5.2 version and I would like to use SQLite 3.5.9 for
> our product. Would you please direct me where to find out the release note
> for 3.5.9
http://www.sqlite.org/changes.html
Michael Knigge wrote:
> See page
>
> http://www.sqlite.org/draft/doc/35to36.html
>
>
> "Added the page_count PRAGMA for returning the size of the underlying
> database file in pages."
>
> I guess you mean "... the **count**" and not **size**.
>
Could be phrased better, but as it is
Keith Goodman wrote:
My guess is that that is too OS specific to add to sqlite. If you are
using linux you could try control-l to clear the screen.
I don't think it's too OS-specific - I think it's really outside the
scope of the sqlite3 shell. The shell is really not intended to be a
ugh the compiler pass, adding -Q -v to the command line:
gcc -c -Q -v dummy.c
Another option is checking gcc's specs file, but I think that's much
more cumbersome.
Hope this helps.
Mihai Limbasan
___
sqlite-users mailing list
sqlite-users@sqlite.
Alex Katebi wrote:
> Is there any way to get to all of these docs you mentioned from the home
> page of the sqlite.org?
> Thanks,
> -Alex
You mean, for offline use? If yes, then I'd click on Download, then
scroll down to Documentation, then I'd clock on sqlite_docs_3_5_9.zip:
guyot jerome wrote:
Hi,
I would like to realize the dialect between SQLite and Hibernate but
I need to know the correspondence between the SQLite types and the general
types (e.g.:How a boolean type is represented under SQLite).
What is that somebody can give myself this piece of
winstonma wrote:
> Then I wonder how can I "export" my DB4Designer work to the SQLite database?
>
>
I have no idea - again, please consult the DB4Designer documentation to
find out the available export options.
___
sqlite-users mailing list
Joanne Pham wrote:
> Thank you so much Mihai.
> It worked!!! Once again thanks a ton.
> JL
>
Glad to hear that - have fun!
Mihai
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Joanne Pham wrote:
> Hi All,
> I have the file which has million rows of insert statement to insert the data
> to the database like below:
> insert into tables values(...)
>
> (there are million insert statement to insert to the table)
> (file name is
Mihai Limbasan wrote:
> In your example it wasn't.
Oops, misread what you wrote.
What I mean is that it doesn't matter whether the ID is autogenerated or
not (of
course, if it isn't then the whole issue becomes moot - it in fact
*should* be PRIMARY KEY AUTOINCREM
Igor Tandetnik wrote:
>> Sure. I'll use your examples, just making sure to add an id insertion
>> in the first statement since the id column isn't specified as
>> autoincrement.
>>
>
> But it _is_ specified as INTEGER PRIMARY KEY.
In your example it wasn't. It also wasn't in Martin's original
Igor Tandetnik wrote:
> Can you show an example of a trigger that would make these statements
> work:
>
> insert into snapshot (bumf) values ('one');
> insert into sample(type, used) values ('a', 1);
> insert into sample(type, used) values ('b', 1);
>
> so that, at the end, the two new records in
Igor Tandetnik wrote:
You can't make this happen automatically with SQLite.
Hmm? Of course you can. Just use a trigger:
http://sqlite.org/lang_createtrigger.html
___
sqlite-users mailing list
sqlite-users@sqlite.org
Roger Binns wrote:
Where is the appropriate place to discuss 3.6 issues? For example in my
case I have very strong feelings about error codes vs return values in
the VFS api.
The sqlite-dev mailing list would be a good place.
___
sqlite-users
Dom Dom wrote:
Hi,
I already asked some weeks ago fabforce.net about the ability to connect
sqlite and dbdesigner.
The answer was as follows
Bye
Dominique
Sorry, we never got the SQLite support finished. We now have the successor
application out, MySQL Workbench, and we might add
the software you're trying - you might ask the authors
for how to use it with SQLite.
Mihai Limbasan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
:
http://www.sqlite.org/cvstrac/wiki?p=HowToCompile
Hope this helps.
Mihai Limbasan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
c.panel wrote:
Hello,
I execute a statement and want to have rowid(s) of each row like a :
"select rowid,* from mytable;"
how can I do this with C API ?
thanks !
There's nothing special about selecting ROWIDs in the C API - you just
use the query you posted above like you would use any
Jonas Sandman wrote:
> You are creating 100 prepared statements, which probably takes a lot of
> memory.
> What you really want to do is probably create one statement, get all
> the data out of it, finalize it and then prepare the next statement
> and get THAT data etc.
>
The posted code does
environment, such as
operating system hardware constraints, compiler brand and version, and
so on and so forth.
Mihai Limbasan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
M.Kursad DARA wrote:
Hi folks,
I want to move my sqlite db's to another location and wants to mount on
nfs.
when i try to select some data from my sqlitedb on nfs i'm getting error
below:
SQL error: Database is locked.
What's is the solution.
Thanks.
ps : I googled but cant find
Alex Katebi wrote:
Hi All,
For those of us that use SQLite mostly in-memory. Our context is mostly not
{sqlite3*} database pointer, it is {sqlite3_stmt*}.
Current API?
int sqlite3_set_authorizer(
sqlite3*,
int (*xAuth)(void*,int,const char*,const char*,const char*,const char*),
void
Joanne Pham wrote:
Hi All,
I have the database which has a lot of insertion and deletion.
Is there anyway that I can get the actual database size without running VACUUM.
Thanks,
JP
Hi, Joanne.
I assume that by "actual database size" you mean "the size of the
database file minus the size of
74 matches
Mail list logo