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
lowing 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 Dowling
--
Simple Content Manageme
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
--
Simple Content Management
http://www.c
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);
>
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
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
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
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
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
[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
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
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
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
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
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
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
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, several wrappers are listed
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
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
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 was time
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
. 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
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
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_get_table func
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
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
-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 the ROWID reac
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
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 reco
./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 build. I do
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
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]
-
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.ceamus.com
t, 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]
-
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 here:
>
> http://ww
ut 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.ceam
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 about and how the
size is checked.
Clay Dowling
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 is empty,
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
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]
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 the Wi
t 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
> -Original Mess
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 ta
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
>
for the
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. I used sql
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 eventually I expect to be as
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
itimate requests from these machines would be
vanishingly small.
Clay Dowling
--
Simple Content Management
http://www.ceamus.com
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
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
lator.
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 Content Managem
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.
>
>
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
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.
Clay Dowl
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
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
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:
Chad Whitacre said:
> My personal favorite non-copyleft license is the "beer-ware license," as
> used by, e.g., Poul-Henning Kamp:
>
>http://people.freebsd.org/~phk/ [note: find 'Beerware']
That is a beautiful license. I'm for anything that gets me a beer or two.
size, you should be fretting the matter with your lawyers, not a mailing
list.
My advice? Stop fretting and get on with using this great little
library. There's a lot more profit in that than there is in worrying
about the unlikely event of a lawsuit that can't be collected on.
Clay Dowli
t you might instead be in need of a
high availability client/server database model. PostgreSQL fares very
well in this category, or some of the heftier commercial database
offerings.
Clay Dowling
--
Lazarus Notes from Lazarus Internet Development
http://www.lazarusid.com/notes/
Articles, Reviews and Commentary on web development
on't release source code Sleepycat is rather expensive. Speaking
as a program it has also not been my favorite database for administration
issues.
Clay Dowling
--
Lazarus Notes from Lazarus Internet Development
http://www.lazarusid.com/notes/
Articles, Reviews and Commentary on web development
key and
only relevant to win32 programmers. They have a notion of private and
public members for shared libraries that doesn't apply in the UNIX world.
Clay Dowling
--
Lazarus Notes from Lazarus Internet Development
http://www.lazarusid.com/notes/
Articles, Reviews and Commentary on web development
Jim McNamara said:
> i dont see many webhosts that advertise sqlite
> availability. are webhosts excluding support for
> sqlite for any reason
> i.e. is it a security concern?
> it is suppose to be an internal extension. i am not
> sure what that means yet.
Because SQLite doesn't have a
computer and the user
have a different idea of what the primary key is, and the user's key has
a uniqueness constraint upon it. I understand that this doesn't fly
well with some DBAs. I'm not a sophisticated enough designer to
understand their objections, but the design works well enough for my
purposes.
Clay Dowling
bly happy with the
result. Fair warning though that I'm not exactly a .NET power user, so
what was acceptable to me may be a steaming pile to you.
Clay Dowling
--
Simple Content Management
http://www.ceamus.com
Pascal and BASIC are really good and handling
arithmetic. Likewise, SQL and database engines are really good at data
storage. So when you need to divide 5 by 2, it probably makes a lot of
sense to do that in C/Pascal/BASIC than in SQL. And sure, there's cases
where you can't avoid it. But usually you can.
Clay Dowling
--
Simple Content Management
http://www.ceamus.com
into
the future, no matter what SELECT 5/2 returns in its result set.
Clay Dowling
--
CeaMuS, Simple Content Management
http://www.ceamus.com
Dave Dyer said:
>
> If I designed a sqlite database to be used by a bunch of independent
> applications, for example a bunch of CGI scripts each of which
> opened the database, did some processing, and exited, would
> that be (a) safe (b) effecient ?
It's very safe. My own product does that
Edward Wilson said:
> What is the best approach to concurrency in this scenario?
>
Don't choke when you get a SQLITE_BUSY error. Just wait and try again in
a second or so.
Clay Dowling
--
Simple Content Management
http://www.ceamus.com
> .quit
bash$
That should probably take care of you.
Clay Dowling
Tero Vihavainen said:
> yes I'm newbie ... :)
>
> ** clip ***
>
> [EMAIL PROTECTED]:/public$ ./sqlite3-3.2.7.bin
> SQLite version 3.2.7
> Enter ".help" for instructions
> sqlite&
etween driving a nice comfortable Ford
Taurus (Delphi) and a BMW Z3 with a stick shift (if you haven't done it,
do: you probably never realized that driving could be so fun). I like
driving both. But there are certain situations where one is a lot better
than the other, as I'm sure you're aware.
Cl
e one
who will be writing the SQL that gets passed to the engine, but if you'll
be writing all of the SQL yourself, you can avoid the problem by not doing
something that you know shouldn't work.
Clay Dowling
--
Simple Content Management
http://www.ceamus.com
imary key. If you do that you'll get auto incrementing keys
by default. If you tack auto_increment on to it you'll get slightly
different behavior in the selection of keys.
Clay Dowling
Try opening it with an sqlite3 client as well. If neither will open the
file, it's either not an SQLite database, or it's hopelessly corrupted and
you aren't getting into it.
Clay Dowling
Manuel Enache said:
> I'done like Shawn said and here is the result:
>
> C:\sqlite>sqlite.
Brad DerManouelian said:
> I was looking for something aggregateder. I've been scared to read email
> lists until now because of how unsafe it is. Just gotta figure out how I
> upgrade the internet to 2.01. I hope it comes with AJAX.
If you get the Web 2.01 upgrade pack, I think they throw AJAX
n of libxml2 and libxslt to generate your output. I've used
both solutions to generate output for high-volume web apps.
Clay Dowling
--
Simple Content Management
http://www.ceamus.com
search on this matter so I
can't really say that this would be breaking new ground.
Clay Dowling
John,
There's a package often found in the discount aisles of computer stores
called My Database. My father (who doesn't pretend to know anything about
databases or programming) uses it for his business and personal uses. The
tool looked absolutely brilliant from the perspective of making it
enum where that's possible (I'm not sure if PHP handles enums).
Clay Dowling
--
Simple Content Management
http://www.ceamus.com
= 0 begin
>select raise(rollback, 'foreign-key violation: MainTbl.EnumCol');
> end;
That's a lot more elegant than what I had envisioned, which was a static
list of values. Don't forget though that you'll also need to write an
update trigger, since it's pretty easy to write &qu
plementing this kind of
structure before I wouldn't try it again without consulting Selko's book.
Clay Dowling
the updates based on your cached data.
Clay Dowling
--
http://www.lazarusid.com/notes/
Lazarus Notes
Articles and Commentary on Web Development
Windows binaries to generate C++ code for manipulating SQLite 3
databases. Hopefully some of you will find it useful.
The code and more information is available at
http://www.ceamus.com/objbuilder/
Clay Dowling
--
CeaMuS, Simple Content Management
http://www.ceamus.com
r a rough ride when you try to built SQLite based software.
Clay Dowling
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 design for my database.
> There are up
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 tool.
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
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.
Clay Dowling
--
rspective, so getting any help on it is highly
desirable.
Clay Dowling
--
Simple Content Management
http://www.ceamus.com
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
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,
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 insertion time f
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 Management
http
in your own application.
That's why I've released it.
Clay Dowling
--
Simple Content Management
http://www.ceamus.com
m, so there's no problem that way.
Clay Dowling
--
CeaMuS
http://www.ceamus.com
Simple Content Management
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
Use the strip command. That removes a lot of fluff but keeps the
functionality.
Clay Dowling
--
Simple Content Management
http://www.ceamus.com
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
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
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
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
1 - 100 of 187 matches
Mail list logo