[sqlite] Check out my photos on Facebook

2009-07-16 Thread Allan Edwards
: http://www.facebook.com/p.php?i=678466945&k=Z4LX3464S5X1UCEHW1W5YWV&r sqlite-users@sqlite.org was invited to join Facebook by Allan Edwards. If you do not wish to receive this type of email from Facebook in the future, please click on the link below to unsubscribe. http://www.face

[sqlite] Sqlite database syncronization gui tool?

2009-03-01 Thread W Allan Edwards
Does anybody know of a sync tool for sqlite like what red gate offers for SQL Server? specific, the schema compare and db data compare capabilities? Thanks, -A- ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailm

Re: [sqlite] SQLite vs. Oracle (parallelized)

2009-02-28 Thread Allan Edwards
oring the possibility of using SQLite as a way to > validate, transform, and pre-aggregate raw data that would in turn be > exported to raw text files and imported (in final form) to a customer's > data warehouse. > >> Sometimes that choice is Sqlite, but in some cases it is

Re: [sqlite] Maximum number of concurrent users

2009-02-27 Thread Allan Edwards
you are looking for an Oracle replacement, SQLite > is probably not for you. > > D. Richard Hipp > d...@hwaci.com > > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqli

Re: [sqlite] SQLite vs. Oracle (parallelized)

2009-02-25 Thread Allan Edwards
If we were you would find me saying "Computer, lets work up a new piece of software on Sqlite... etc. etc. etc." On Tue, Feb 24, 2009 at 7:55 AM, P Kishor wrote: > On Tue, Feb 24, 2009 at 12:25 AM, Allan Edwards > wrote: > .. >> >> I have personally writte

Re: [sqlite] SQLite vs. Oracle (parallelized)

2009-02-24 Thread Allan Edwards
Vxworks, the > like. SQLite used to fit on a floppy and probably still does. > > Good point! > > I lost my perspective on SQLite's intended audience. > > Regards, > Malcolm > ___ > sqlite-users mailing list > s

Re: [sqlite] SQLite vs. Oracle (parallelized)

2009-02-24 Thread Allan Edwards
> once. > > > >> >> >> Thank you, >> Malcolm >> ___ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > D. Richard Hipp &

Re: [sqlite] Question on missing Entry Point for Sqlite 3

2009-02-10 Thread W Allan Edwards
Subject: Re: [sqlite] Question on missing Entry Point for Sqlite 3 > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > W Allan Edwards wrote: > > By preprocessor do you mean #define? > > It is a #define if in C source and -D if a compiler argument. >

Re: [sqlite] SPAM: Re: Question on missing Entry Point for Sqlite 3

2009-02-10 Thread W Allan Edwards
gt; not work properly.> > > >-Original Message-----> From: sqlite-users-boun...@sqlite.org> >[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of W Allan Edwards> Sent: >Tuesday, February 10, 2009 5:00 PM> To: sqlite-users@sqlite.org> Subject: >SPAM: Re: [sqlite]

Re: [sqlite] Question on missing Entry Point for Sqlite 3

2009-02-10 Thread W Allan Edwards
I have emailed Miguel of Mono directly, the mono contact form, and the ado.net provider guys. I have not heard anything back from anbody but this almighty sqlite group. Whether the doctor turns this code off by default or not I would hope somebody makes the provider behavior the same cross p

Re: [sqlite] Question on missing Entry Point for Sqlite 3

2009-02-09 Thread W Allan Edwards
Decide what features you want to use and set the > conditional compilation flags accordingly and com;pile it to all the > platforms you intend to use. You will then get exactly what you want. > > W Allan Edwards wrote: > > I also emailed the mono project guys about this because

Re: [sqlite] Question on missing Entry Point for Sqlite 3

2009-02-08 Thread W Allan Edwards
loaded by the ado.net provide on the mono side. <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< <<<<<<<<<<<<<<<<<<<<<<<<

Re: [sqlite] Question on missing Entry Point for Sqlite 3

2009-02-08 Thread W Allan Edwards
lt;<<<<<<<<<<<<<<<<<<<<<<< <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

Re: [sqlite] Question on missing Entry Point for Sqlite 3

2009-02-08 Thread W Allan Edwards
would have something do with the .configure fun file? > Date: Sun, 8 Feb 2009 18:10:19 -0800 > From: rog...@rogerbinns.com > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Question on missing Entry Point for Sqlite 3 > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1

Re: [sqlite] Question on missing Entry Point for Sqlite 3

2009-02-08 Thread W Allan Edwards
lite] Question on missing Entry Point for Sqlite 3 > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > W Allan Edwards wrote: > > I find it odd you have different expected behavior for the same code on > > each different platform. > > What specifically are you

Re: [sqlite] Question on missing Entry Point for Sqlite 3

2009-02-08 Thread W Allan Edwards
ntry point offerings for each platform of the same sqlite database version? Allan > Date: Sun, 8 Feb 2009 13:24:32 -0800 > From: rog...@rogerbinns.com > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Question on missing Entry Point for Sqlite 3 > > -BEGIN PGP SIGNED

Re: [sqlite] Question on missing Entry Point for Sqlite 3

2009-02-08 Thread W Allan Edwards
using the same versions of the same tools? Allan > Date: Wed, 4 Feb 2009 01:03:48 -0800 > From: rog...@rogerbinns.com > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Question on missing Entry Point for Sqlite 3 > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1

[sqlite] Question on missing Entry Point for Sqlite 3

2009-02-03 Thread W Allan Edwards
Unhandled Exception: System.EntryPointNotFoundException: sqlite3_column_origin_name I am getting this issue on a mono based application that utilizes the sphinx .net 2.0 ado.net adaptor for sqlite. I have installed the latest sqlite on my Ubuntu Linux 8.10 but I get this issue. My guess is m

RE: [sqlite] New Web site

2004-04-11 Thread Allan Edwards
Cool idea! Site looks good. -Original Message- From: Greg Obleshchuk [mailto:[EMAIL PROTECTED] Sent: Sunday, April 11, 2004 5:54 PM To: [EMAIL PROTECTED] Subject: [sqlite] New Web site Hi Everyone, (I know this is off subject) I have finished a new web site dedicated to SQL Scripts for

RE: [sqlite] A proposal for SQLite version 3.0

2004-04-07 Thread Allan Edwards
Yes, things are very tight on all of our products over here as well! I would like to know what causes a bloated file. Thanks, Allan http://www.aspire.ws http://store.aspire.ws -Original Message- From: Roy Black [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 07, 2004 10:38 PM To: [EM

[sqlite] Giveaway of Software that uses Sqlite!

2004-04-01 Thread Allan Edwards
Hey guys! Just wanted to let all of you know that http://www.osnews.com is going to be giving away a free Enterprise edition of our Software Defect Tracking system Enterprise Edition that utilizes Sqlite for data storage. They will have a competition for the free giveaway starting Monday April 5t

RE: [sqlite] sqlite.org ISP problems

2004-03-31 Thread Allan Edwards
Guys, the best hosting company with the best customer service I have had is from August.NET here in Dallas. They are not too big that you don't get excellent customer service, yet not too small in that they don't have enterprise level network infrastructure and capabilities. When you need to get

RE: [sqlite] Re: SQLite Logos?

2004-03-28 Thread Allan Edwards
fire them TO! : - ) Trust me, we are developers, NOT marketing people! The graphic needs help! Thanks, Allan -Original Message- From: Greg Obleshchuk [mailto:[EMAIL PROTECTED] Sent: Sunday, March 28, 2004 1:10 AM To: Allan Edwards; [EMAIL PROTECTED] Subject: Re: [sqlite] Re: SQLite

[sqlite] New Windows Product for developers that uses Sqlite

2004-02-17 Thread Allan Edwards
http://www.aspire.ws http://store.aspire.ws http://www.aspire.ws//Public/Products/Swatter2004r1/ProductHome.aspx Just wanted to show off some of the great things you can do with Sqlite. Our defect tracking system that uses sqlite is available for free eval. This app is fully managed .NET code exc

RE: [sqlite] OK to drop support for legacy file formats?

2004-02-06 Thread Allan Edwards
Now there is experience talking. I agree with this view point. -Original Message- From: Greg Obleshchuk [mailto:[EMAIL PROTECTED] Sent: Friday, February 06, 2004 4:18 PM To: D. Richard Hipp; [EMAIL PROTECTED] Subject: Re: [sqlite] OK to drop support for legacy file formats? Hello, Why

[sqlite] Question for the Dr. on Dates!

2004-01-05 Thread Allan Edwards
One thing I was unable to determine with my datetime fun in the past weeks was whether it was possible to stuff a date like this 12/23/2003 22:10:01 PM into a column in sqlite and then run a function to convert that date to a sqlite understood date for manipulation in a select WHERE clause. If thi

RE: [sqlite] Documentation

2004-01-05 Thread Allan Edwards
I looked through the source code and those functions "WERE" experimental. They appear to be a full non experimental in the sqlite source code at this point. Thus far I have not found any problems with them. You can #define them out on a compilation if you don't want date routines, but they look t

RE: [sqlite] Documentation

2004-01-05 Thread Allan Edwards
Yeah, I went through this myself a couple of weeks ago. Your best bet is to store your dates like this, -MM-DD HH:MM:SS. The data adapter for .NET we are shipping over here allows you to write code for any other database via a data adapter, then port your code with few to no changes. We hav

RE: [sqlite] SqLite on Windows

2004-01-03 Thread Allan Edwards
Howdy group, Although our store is a couple days to a week from being live, we have a Sqlite. NET product for windows. You can read about it at http://www.aspire.ws. We are using Sqlite in some of our current and future products. Because of some requests received earlier this year, we decided t

RE: [sqlite] web server use of SQLite

2003-11-24 Thread Allan Edwards
OK, Sqlite will scale just as well on a single processor machine with few drives as any big RDBMS. If Sqlite was to take a turn to compete in areas it does not already dominate clearly, it would be in scale. If sqlite could take advantage of multiple processors and drives that would be huge, but

RE: [sqlite] Concurrency in SQLite

2003-11-23 Thread Allan Edwards
My thoughts are that most programmers over use and abuse threading and I love the simplicity of your database as it is. Can't tell you how many C projects that have almost failed because of threading and memory issues (til I took over them and became Mr. Fix man). First thing I did was pull out a

RE: [sqlite] double email

2003-11-22 Thread Allan Edwards
Come on fellas! Why not just setup a forum on the sqlite.org website or something, and kill this whole list server thing. Maybe Linux is just too complex for some people to handle list servers with! : - ) Thanks, Allan -Original Message- From: Bernie Cosell [mailto:[EMAIL PROTECTED] S

RE: [sqlite] Performance tuning question

2003-11-14 Thread Allan Edwards
Say, are you testing inserts? Allan -Original Message- From: Arthur Hsu [mailto:[EMAIL PROTECTED] Sent: Friday, November 14, 2003 6:29 PM To: Andrew Shakinovsky; [EMAIL PROTECTED] Subject: Re: [sqlite] Performance tuning question Hello, I managed to download new CVS versions (by hand

RE: [sqlite] SQLite .NET Wrappers

2003-11-14 Thread Allan Edwards
My company will ship a commercial one in late Dec/ early Jan. It won't be open source but it will be managed C#. Thanks, Allan -Original Message- From: Luciano [mailto:[EMAIL PROTECTED] Sent: Friday, November 14, 2003 8:09 AM To: [EMAIL PROTECTED] Subject: [sqlite] SQLite .NET Wrappers

RE: [sqlite] Big Players League

2003-11-04 Thread Allan Edwards
With today's hardware power, I think sqlite will easily scale to most solutions. You may have to purchase a bigger machine, but it is truly easy and the data file does not corrupt like Access. Access is a piece of trash. I am helping a company currently with a system that gets 400 million record

RE: [sqlite] Performance problem

2003-11-04 Thread Allan Edwards
Howdy, I wrote a note the other day on BLOBS that did not go through I guess but since BLOBs came up again I want to throw in my 2 cents. I have YET to see a database, small to massively scalable that could handle BLOBS worth anything. Databases, especially relational ones give you quick power to

RE: [sqlite] Performance problem

2003-11-04 Thread Allan Edwards
H, the name of the database IS sql "LITE". My guess is that if it was mean to be the monstrous scalable solution, it would have been architected this way in the first place. One thing I find interesting about Sqlite is that I tested in this past week up to 360,000 records. I had no

RE: [sqlite] Protection of db file

2003-11-03 Thread Allan Edwards
What platform are you on? Linux or Windows Based? -Original Message- From: thomas_b_hansen2003 [mailto:[EMAIL PROTECTED] Sent: Monday, November 03, 2003 2:04 AM To: [EMAIL PROTECTED] Subject: [sqlite] Protection of db file I need a good advice regarding protecting the sqlite db file.

RE: [sqlite] .NET Fully compatible Data Adapter shipping in early November for Sqlite

2003-10-28 Thread Allan Edwards
Mono? Best regards, Paul. - Original Message - From: "Allan Edwards" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 28, 2003 11:36 PM Subject: [sqlite] .NET Fully compatible Data Adapter shipping in early November for Sqlite > Hi everyone. Just a

[sqlite] .NET Fully compatible Data Adapter shipping in early November for Sqlite

2003-10-28 Thread Allan Edwards
Hi everyone. Just a heads up. Originally my company was not going to release our .NET data adapter for .NET but some demand came up for it so we have professionally packaged it and will be releasing it in early November. We are writing other apps that need this feature so we went ahead and invest

FW: [sqlite] Performance benchmarking

2003-10-27 Thread Allan Edwards
I am putting finishing touches on quite a large application that uses Sqlite for the single user edition. My experience has been that inserting data is quite slow in comparison to most other dbs. All other operations are faster than any other db. It appears that Sqlite is highly optimized for S

RE: [sqlite] SQLite in Web application

2003-10-26 Thread Allan Edwards
If you want to do something like this, the only thing necessary is to synchronize access to your data layer. In other words, only one thread of execution should be able to access your Sqlite db at one time. To accomplish this, here is a simple solution. If you have not already put all data access