Simon de Hartog wrote:
> SQLite has a feature called Manifest typing. As with many features of
> software I run, I wonder whether this feature can be disabled. I prefer
> to use static typing in my databases to prevent stored values not being
> what my code (C++) expects them to be. So in short: is
For myself, I find C and C++ to be the best for use with SQLite (and the
STL makes the set oriented nature of relational databases fit reasonably
well). Mostly though that's because those are the languages I prefer to
work in, rather than in inherent quality of the bindings. Like the man
says
Rajesh Nair wrote:
> Hi
>
> Is there any future plan to develop sqlite in C++.
>
Given that C++ has source and binary compatibility with C, I don't think
there would be any point. I develop in C++ using SQLite quite happily,
and see no reason to stop now.
Clay
___
Farzana wrote:
> Dear All,
>
> We are working in eVC++ environment with SQLite database.We need to populate
> the listbox with the values obtained by executing the query.
> We were able to get the values of the query by using the API’s
> sqlite3_prepare and sqlite3_step.
> But we were able to popu
ectly suitable for beginners, but can take you all the way
to very advanced topics. Probably one of the best computer books I have
purchased.
This isn't an SQLite specific book, by the way. It's fairly generic, so
what you learn here will work elsewhere.
Severin Müller wrote:
> I tried to include sqlite3 in my current C Project.
>
> I downloaded the precompiled library sqlite-3.5.6.so and put it in my project.
> Then, i downloaded the sqlite source and added sqlite3.h to my project.
>
> Now, when i try to compiler, i get the following error mes
Jerry Krinock wrote:
> That's easy enough to detect with API from the OS, but a conflict can
> still occur if they launch and start reading while I am in the middle
> of writing something I don't want to stop. I need to lock the
> database so that they get SQLITE_BUSY until I'm done.
>
> Ho
Seems like it would work, but maybe overkill. What's stopping you from
working out a fairly direct protocol to exchange data with? Sending key,
type, val for all of your IPC seems reasonable. A mem-mapped file, a
local socket or a network socket seem reasonable, depending on the
structure of the
I've fed editable wxGrids with several different data sources. The
principle would be the same with SQLite as with any other. You get the
most control by using the two-layer approach of deriving from
wxGridTableBase. When editing moves to another row you write your
updates/new record.
Clay
sq
I have to say, this discussion has been very informative, although
probably not in a way that would make mr Weick happy. I've certainly
learned a lot about encirq that tells me what I need to know about doing
business with them.
Clay
steveweick wrote:
>
> Good idea... I'll pass it along to the
Tom Parke wrote:
> Where can I find some sample C code for stepping thru a result set and
> for binding variables to columns? I am just beginning to experiment
> with Sqlite3 and I am having a hard time getting aquainted.
http://www.lazarusid.com/sqlite3
>From a Linux Journal article several ye
Andreas Volz wrote:
> Am Sun, 25 Nov 2007 12:11:50 +0100 schrieb Andreas Volz:
>
>> Hello,
>>
>> I used this minimal example code to test my sqlite connection. This
>> works without problems. But now I tried to move the 'db' variable into
>> the private member section of my 'Cache' class to access
[EMAIL PROTECTED] wrote:
>
>(1) http://sqlite.hwaci.com/v1/ No CSS of any kind.
>(2) http://sqlite.hwaci.com/v2/ CSS menus with rounded corners
>(3) http://sqlite.hwaci.com/v3/ CSS menus with square corners
>(4) http://sqlite.hwaci.com/v4/ CSS font specification only
Or more to the point, I changed the URL on the Users page of the wiki, to
reflect the new home: http://www.lazarusid.com/modauthsqlite3.html
Clay Dowling
--
Lazarus Registration
http://www.lazarusid.com/registration.shtml
Nishit,
Much as we believe in helping out new people, I think it is reasonable to
expect that before you ask for helping in using the C interface to SQLite
that you familiarize yourself with C. Looping and logic structures are
something you should learn pretty early on, and if you haven't reached
Check out http://www.lazarusid.com/sqlite3 for a working example.
Clay Dowling
"Severin Müller" wrote:
> Hi
>
> I'm new to sqlite3, and i' have some Problems with my code. I'm trying to
> select data from a table and to save the result in a string. but i
There are two options:
1. D. Richard Hipp sells a version which encrypts the file on disk. This
might be the fastest and easiest route.
2. OpenSSL offers as much encryption as you're likely to need if you're
willing to deal with the paucity of documentation. Linux Journal had a
couple of articl
If you want to use a DLL then you should download the DLL and the source
package. Create an import library against the DLL with dlltool and put
the resulting libsqlite.a into your libs folder. Copy sqlite3.h from the
source distribution into your includes folder.
If you'd rather be statically li
Check the result code of sqlite3_open and use the error message from
sqlite3_errmsg as the message in your exception. Then you'll know what's
wrong.
Clay
Severin Müller wrote:
> Hi
>
>
>
> Im trying to use SQLite3 for my File, but Im having trouble to use the
> library properly.
>
>
>
> I Hav
John Elrick wrote:
>> A much better solution than QuotedStr is to use queries with parameters.
>> If you're going to be running the query multiple times it also gives you
>> a
>> speed boost.
>>
>
> True, however, that assumes you will be running the query multiple times
> in a row, which I haven
John Elrick wrote:
> // Input := 'Let's meet at the pub tonight!';
> MyFormat := 'insert into stuff (title) values (%s)';
> SQL := Format(MyFormat, QuotedStr(Input));
>
> try
> ASQLite3DB1.Database := db;
> ASQLite3DB1.DefaultDir := ExtractFileDir(Application.ExeName);
> ASQLite3DB1.O
m your
application's installer and quite simple to administer. The supporting
utilities are also of excellent quality, so that it's pretty simple to set
up a shortcut that would let your customers do a backup.
Clay Dowling
--
Sim
SQLite was chosen for the following reasons:
1. Easy deployment.
2. Zero configuration.
3. Easy API to access from Delphi.
4. Licensing costs
5. Speed. Speed was the primary deciding factor, because these lookups
must be fast.
Clay Dowli
For all of you who have been wanting to use SQLite3 to manage
authentication on your Apache web servers, I have just released
mod_auth_sqlite3. You may download it from
http://www.lazarusid.com/download/modauthsqlite3-1.0.tar.gz
The module includes both a command line and a web utility for manag
.
There's a problem with that URL. Could you check it, or check your
server? I'd love to read the example, but my browser steadfastly refuses
to resolve an address for cesarodas.com
Clay Dowling
--
Simple Conte
Pavan wrote:
> Hi,
>
> I was googling for c++ interfaces for sqlite and found sqlitemm provides.
> But, i am unable to download the code. Can some one pls point me to link
> from where i can download the c++ interfaces for sqlite.
You can try my wrapper at http://www.lazarusid.com/download/sqdat
f legitimate requests from these machines would be
vanishingly small.
Clay Dowling
--
Simple Content Management
http://www.ceamus.com
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
You have any way to normalize that original source table? It's full of
extents, which is the first sign of badness in a table design and
assured of complicating your life.
Clay
RB Smissaert wrote:
> Yes, I agree it looks messy, but I used to do this in steps and after advice
> I think from Igor
e what Mike has done.
Contact me off list if you need some help learning the native API. I
have a nice example that you can find at Linux Journal by searching on
SQLite.
Clay Dowling
Michael Hooker wrote:
> I have sent Ralf a long reply directly.
>
> No criticism was intended, and ev
technique).
I've included the utility which converts an SQL export to C code. I'll
let you work out the details for the rest.
Clay Dowling
Rob Richardson said:
> Greetings!
>
>
>
> I need to be able to create a database with a known schema from inside a
> program.
sqlite3_column_name would be favorite, assuming that the DBD provider uses
the prepared statements API (which it should be doing).
Clay Dowling
Joe Casadonte said:
> On Wed, 27 Dec 2006, Clay Dowling wrote:
>
>> If you use the SQLite API rather than shelling to the SQLite command
>
If you use the SQLite API rather than shelling to the SQLite command line
utility you may get more satisfactory results. The API between 2.x and
3.x is quite different, but the column headers are readily available.
Clay Dowling
Joe Casadonte said:
>
> When querying multiple tables
es are just pointers, so you can declare
them as such. Everything else is a fundamental type. Now you're good to
go. Combine that with my article in a previous message about how to use
the API and you're on the same footing as the C programmers who use the
library.
Clay Dowling
>
Yes. It's a regular windows DLL, so it will behave like all other Windows
DLLs.
Clay Dowling
[EMAIL PROTECTED] said:
> Can I call the SQLite API (as in the dll SQLite.dll) directly from
> VB or do I need the wrapper? So, could it work from VB with declares
> as I use for t
sebcity said:
>
> Thanks, Could you supply an example?
>
http://www.linuxjournal.com/article/7803
Clay
--
Simple Content Management
http://www.ceamus.com
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
sebcity wrote:
> How would one go about using c++ (Visual Studio.NET) to call and display
> SQLite tables. C++ wrappers?
You could just use the API directly. Myself, I've put a wrapper around
it, but there's nothing saying that you have to.
Clay
--
CeaMuS
http://www.ceamus.com
Simple Content Ma
r wxSQLite since
most of the wxWidgets components are pretty well documented.
Clay Dowling
Lloyd said:
> I have tracked down the problem and found th following.
>
> I have a select statement which stores the result set in a pointer
> variable. If the result set of select statement
you can't check all 600, spot check several which you find at random. And
remember that there's nothing wrong with strcpy and strcat, as long as the
destination buffer is large enough for the string being received. Look
for the allocation of that buffer and see how it's come abo
ss, but you can probably look it up, or even
call the company switchboard and ask for him. If you tell him who you and
what you do he's probably going to listen.
Clay Dowling
--
Simple Content Management
http://www.ceamus.com
eir program is generating these
files, probably because any poor soul stuck on phone support is fairly new
to the company and the product. Phone support in any company has a high
turnover.
Clay Dowling
[EMAIL PROTECTED] said:
> I need advice from the community. The problem
> is seen he
robably the best, but for a
commercial application the licensing fees mean that you have to be well
funded and expect a good return on the product.
Clay Dowling
--
CeaMuS, Simple Content Management
http://www.ceamus.com
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
my machine though, and I have a strong
bias in favor of C.
The plan for this program, when it reaches 1.0, is to make it more
sensitive to the type of change that has been made, so that a different
message is received for changes of ownership, status, and remarks.
Clay Dowling
--
CeaMuS
http://www.
a nice little library I could share with you which sits
on top of an SQLite database.
Clay Dowling
--
CeaMuS
http://www.ceamus.com
Simple Content Management
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
I think first it would be helpful if you had a working pagerank algorithm.
Data storage is not really what makes Google's pagerank and search
engines so impressive, it's the searching and categorization capabilities.
Clay
Cesar David Rodas Maldonado said:
> Some one what to help?
>
> On 9/26/06,
./configure, especially since I build on more platforms than are supported
by default. OpenBSD and FreeBSD are in my mix.
Clay
Martin Jenkins said:
> Clay Dowling wrote:
>> I don't have tcl installed on my systems and I've never had a problem
>> doing the default bui
I don't have tcl installed on my systems and I've never had a problem
doing the default build. I do skip "make test" because I don't have tcl
installed, and because I don't modify my copies of SQLite.
Clay
Martin Jenkins said:
> Clay Dowling wrote:
>>
What I strongly recommend doing, rather than trying to cobble together
your own solution, is to download the source and go through the build and
install -exactly- as decribed in the document.
Clay
Lloyd said:
> 1) I have downloaded the SQLite sqlite-3.3.7.so.gz and saved in the
> desktop director
What level of access is needed from outside of the application? There are
nice GUIs available for SQLite that people could use. There is in theory
ODBC access as well, although my experience with ODBC and SQlite was not
especially happy.
Clay
Allan, Mark said:
> Hi,
>
> After successfully using
oosing non-sequential rowid values is fine for some
point down the road in the unforseeable future, why isn't it fine for now?
Clay Dowling
Dixon Hutchinson said:
> But "AUTOINCREMENT" has slightly different behavior that what I desire.
> The difference is what happens when
ROWID is a reserved word. Each row has one and you don't need to specify
it. In fact you probably shouldn't, since it seems to be causing you
problems.
If you want the column to be explicitly declared in your table, call it
something else like id. If you don't want to do that just use the keywo
John Salerno said:
> I'm asking about an actual file, though, not just a single query. I've
> tried something like what you suggest with the file path, but it
> doesn't work.
>
sqlite database.db < script.sql
>
>
> On 8/23/06, Scott Baker <[EMAIL PROTECTED]> wrote:
>> echo "SELECT * FROM Table"
You will probably have to go through the configure process first, because
a lot of the source files aren't built until after the configure process.
Clay Dowling
Laura Longo said:
> Hi all,
> I would like to view the source code of libsqlite3.so because of a problem
> with sqlite3
Installing gcc is an excellent idea, but I would not be entirely surprised
to learn that the actual failure is in sed. SCO and awk/sed do not have a
happy history, with incompatible changes having been introduced at times.
Clay
Steve Baldwin said:
> Hi,
>
> I'm trying to build SQLite 3.3.7 on SC
. If
they are in the library folders, try rerunning ldconfig, which should
then make them visible when running the program.
Clay Dowling
--
http://www.lazarusid.com/notes/
Lazarus Notes
Articles and Commentary on Web Development
-
Cesar David Rodas Maldonado wrote:
I was thinking a lot in the next month in how can I do the delay insert and
I found something for do that, is basic because I don't have a lot of
knowledge, I'm just start the University.
OK, I need with SQLite to select all the time as possible, and delay the
Clay Dowling wrote:
> 1. Use the sqlite3 interface, not sqlite 2.
>
> 2. Store a 0 or a 1 in the field. Then you can get the value with
> sqlite3_column_int
>
> There's a more complicated answer as well, but I wasn't able to get the
> code assembled before it
l, but I wasn't able to get the
code assembled before it was time to turn in last night.
Clay Dowling
--
CeaMuS
http://www.ceamus.com
Simple Content Management
Cesar David Rodas Maldonado said:
> Hello to everybody
>
> If I have a table with 100.000 unique words I am wondering if SQLite
> select
> if faster an cheaper (RAM, Processor, etc), or If i have to help SQLite
> using a Hash function, and what could be that Hash function?
If you're going to the
an
application you'll want something a little more sophisticated.
Clay Dowling
Joe DiMaggio said:
> Hello,
>
> I need a server-less SQL engine. Unless someone recommends a better tool
> (embedded FireBird? Something else?), I'm thinking of using SQLite.
>
> Problem is, sev
Bogus³aw Brandys said:
> In fact that is as I fairy know how it's implemented in Firebird Classic
> Server (where each server process has separate lock manager I suppose)
> This classic server processes are spawn by xinetd deamon.
> I see sqlite in very similar manner : sqlite library is attache
Halim Issa wrote:
Hi,
I have been trying to get an application that utilizes SQLite to run on our
system, but according to the application developers it fails because SQLite
is incompatible with NFS and thus cannot work on NFS-mounted volumes.
Attempts at locating this bug in the SQLite databa
yuyen wrote:
> Ok, finally I found the problem is that the PHP and Apache are installed
> in local drive and I put the sqlite database file on a remote file
> server which is a Linux / Samba. I can use sqlite3.exe to open that
> remote database with a mapped remote drive. And Insert, Update and
> D
avoid dealing with
them.
Clay Dowling
Kareem Badr said:
> I read the section on the SQLite website regarding the inconsistencies
> of how NULL values are handled in various databases. I didn't see
> anything that mentioned what I am running into, though.
>
> In a nutshell, the
ooking for into an XML file.
Clay Dowling
--
Simple Content Management
http://www.ceamus.com
[EMAIL PROTECTED] wrote:
"Fred Williams" <[EMAIL PROTECTED]> wrote:
How about some form of automated(?) sequence where:
New subscriber submits subscription request.
System sends "query" message to subscriber address.
New subscriber sends "confirmation" message within r
of the list that won't accept
anything with @paypal.com or @ebay.com, not just at signup time but when
the messages are received.
As to how he pulled it off, there's probably an auto-responder on those
addresses.
Clay Dowling
--
http://www.lazarusid.com/notes/
Lazarus Notes
Articles and Commentary on Web Development
the size of the record.
Clay Dowling
[EMAIL PROTECTED] wrote:
Hi to all
Today I inserted as a Test 100 Records in my DB. I repeat therefor
100 times the same "Insert into...". The Job starts and I wait,
and wait, and wait.
I say, Programm hangs or died, because I do a Mistake in
e parser to realize the problem. Have you tried
using the 16 bit character functions instead? The 8 bit functions could
be choking on the essen.
Clay Dowling
--
Simple Content Management
http://www.ceamus.com
generic for an existing tool.
However writing a tool for your specific situation should be fairly easy.
If you're comfortable with C I strongly recommend looking at libxml2
(http://www.xmlsoft.org), which makes XML parsing very easy.
Clay Dowling
--
Simple Content Management
http://www.ceamus.com
they were speaking in the context of SQL Server, I found that what
they said applied very well to SQLite.
Clay Dowling
--
CeaMuS
http://www.ceamus.com
Simple Content Management
Deepak Kaul said:
> 1. Calling sqlite_exec within my C++ program
Good for one-off statements, like DDL. If you have to generate the SQL
and deal with parameters though, this option is no good.
> 2. Calling sqlite_prepare, sqlite3_step and sqlite3_finalize within my
> C++ program
Best for mu
David,
What you're looking for is an editable data grid. They're common
components and fairly easy to find. They're also typically a pain in the
tail. If you're comfortable with C++ you might look at wxWidgets and
their built-in datagrid.
Clay
David Bicking said:
> This is probably off-topic
PalmSource been good enough to purchase a support contract?
Clay Dowling
--
Simple Content Management
http://www.ceamus.com
h is reading the file on Windows with the
sqlite3 command line program. That would be the authoritative source.
Clay Dowling
--
CeaMuS
http://www.ceamus.com
Simple Content Management
27;t as nice, but if the prepared statement
interface isn't available it's a good alternative.
Clay Dowling
--
Simple Content Management
http://www.ceamus.com
can provide additional
security, but the database file itself can't.
Clay Dowling
--
CeaMuS
http://www.ceamus.com
Simple Content Management
at in a situation like this
you'd be better off looking at something like PostgreSQL, that can handle
multiple network clients. SQLite is a great tool, but it's not the only
tool. Use the right tool for the job, and a file-based database is rarely
the right tool when network access is nee
permissions 770 with the owner or
the group being the web server's owner or group, and the group or the
owner being the user.
>From there keeping miscreants out of the file becomes the domain of the
web application accessing that file. The app writer can give as much or
as little access as desired.
Clay Dowling
--
Simple Content Management
http://www.ceamus.com
ut you can save yourself the trouble of rewriting your database
access by making a slight modification to your code. This assumes, of
course, that you aren't already using transactions.
Clay Dowling
--
Simple Content Management
http://www.ceamus.com
[EMAIL PROTECTED] said:
> "Clay Dowling" <[EMAIL PROTECTED]> wrote:
>>
>> Can I get a reliable rowid from [sqlite3_last_insert_rowid()]
>> while I'm in the middle of a transaction
>>
>
> Yes. Why would you think otherwise?
Because I wor
I'm using SQLite in a performance-intensive data conversion process and
it's come about that it would be very useful to get the insert_rowid of
the last record inserted while I'm still in the middle of a transaction of
servert hundred inserts(the primary key will become a foreign key to a
child tab
ecifics. What you need to do instead is work out what you need to use
SQLite from your app and go from there.
Clay Dowling
--
CeaMuS
http://www.ceamus.com
Simple Content Management
David Gewirtz said:
>
> I've just started to explore SQLite and I've noticed a whole pile of
> wrappers for various environments. The environment I'm using (the open
> source Frontier Kernel) doesn't have any wrappers, so I'd like to write
> one.
> Can someone post some pointers to resources on ho
jam_lraep said:
> I have only downloaded, unzipped SQLite-3.3.3.tar.gz and launched the
> followings commands:
> ./configure
> make && make install
>
> if there is another way to compile the library I don't know it...
There's probably a slicker way to do this, but as a crude hack you can
search t
Use the strip command. That removes a lot of fluff but keeps the
functionality.
Clay Dowling
--
Simple Content Management
http://www.ceamus.com
Jiao said:
> Hi,all
> NOW I want to use sqlite in an embedded device.In my design ,a web cgi
> in a single process is used to update configuration,and I expect my main
> application in another process can be noticed whenever its configuration
> is changed, how to use sqlite to achieve this goal,
t in the same program, so there's no problem that way.
Clay Dowling
--
CeaMuS
http://www.ceamus.com
Simple Content Management
is code in your own application.
That's why I've released it.
Clay Dowling
--
Simple Content Management
http://www.ceamus.com
e included examples are
specific to SQLite 3 using C++. I've also included a more thorough
example in PHP that generates a significantly large portion of the
application automatically. Hopefully these examples will be useful to
people reading this list.
Clay Dowling
--
Simple Content
mediate. Why?
When you didn't wrap it in a transaction, you really had about 50 little
transactions. That gets expensive in a hurry. So when you're doing bulk
inserts remember to make transactions. When I had to insert a 800k
records into a database I found that is changed insert
pavan savoy said:
> -- Forwarded message --
> From: pavan savoy <[EMAIL PROTECTED]>
> Date: Feb 8, 2006 5:22 PM
> Subject: Help regarding insertion into database
> To: [EMAIL PROTECTED]
>
> Hi,
>
> Inside C program I have a structure and want to store it into a
> database,
Jim C. Nasby said:
> Finally, and luckily this applies to SQLite as well so this doesn't get
> too off topic :), PLEASE seek help/advice BEFORE spending a bunch of
> money on a big server! All too often I see people who spend a load of $$
> on equipment they didn't need or won't be able to utiliz
spective, so getting any help on it is highly
desirable.
Clay Dowling
--
Simple Content Management
http://www.ceamus.com
ted
>> in
>> the client. However it's very easy to implement those in code. If
>> you'd
>> like I can supply C source to parse the CSV text.
>>
>> Clay Dowling
>> --
>> http://www.lazarusid.com/notes/
>> Lazarus Notes
>> Articles and Commentary on Web Development
>
>
--
Simple Content Management
http://www.ceamus.com
uot;copy" is removed from
version 3 on?..] (or where can i find them?...)
These features aren't built directly into the library, but implemented
in the client. However it's very easy to implement those in code. If
you'd like I can supply C source to parse the CSV text.
C
Clint Bailey said:
> Can anyone point me to web sites that are powered by Sqlite? I'm curious
> as to how they function as compared to a MySQL, or brand M$ powered site.
http://www.ceamus.com
Of course, you aren't going to see the guts of its SQLite access from this
perspective. But as a regul
w.ceamus.com/objbuilder/ which will render an XML
file describing the schema of the database. It would be a pretty straight
forward matter to generate an XML file with the contents as well, but I
don't know about such a beast. For filthy lucre I would be more than
happy to make such a to
ng at it, but I've had to deal with too many
designs that saved a little time and gained a little speed up front, but
that cost a lot of money down the road in longer development times.
Clay Dowling
Michael Sizaki wrote:
> Hi,
>
> I'm thinking about using a non standard de
user input anyway. It's very valuable in
a transaction processing situation though, where the same query will be
used many times.
Clay Dowling
--
Simple Content Management
http://www.ceamus.com
don't delete it, you're going to be in
for a rough ride when you try to built SQLite based software.
Clay Dowling
1 - 100 of 209 matches
Mail list logo