Re: [sqlite] i have a few Qs - sqlite3

2006-07-08 Thread Paul Malcher

On 7/8/06, Martin Jenkins <[EMAIL PROTECTED]> wrote:


Nuno Lucas wrote:
> Please don't feed the troll...



Well, I have to add my two cents here. I've been following this thread and
alot of people have been generous enough to the troll. I think its nice to
see a community such as this that is generous with time and clues. However,
I've seen some responses from the person that asked this initially and I say
Troll is putting it nicely. Thumbs up to the SQLite community as a whole and
also open source in general.


Re: [sqlite] Windows DB manager?

2006-07-01 Thread Paul Malcher

On 7/1/06, Bernie Cosell <[EMAIL PROTECTED]> wrote:


What's the current state of GUI-based managers for SQLite?  I know there
have been various admin apps for SQLite, but I've been out of touch and I
didn't see any linked out of the sqlite.org web page.



Hi, Well my personal favourite and the one I use mostly is called
sqlitebrowser. I have included the link for it below it comes in win32 and
linux flavours, mac os x even. I find it simply the best tool for my work I
do with SQLite. I can't remeber if its list on the SQLite page or not,
either way its worth checking out.

http://sourceforge.net/projects/sqlitebrowser/


Re: [sqlite] Most appropriate Web based database? (Newbie)

2006-04-24 Thread Paul Malcher
On 4/24/06, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
>
> Keep in mind, there's *WAY* more Windows users than Linux users; that
> doesn't mean Windows is a better OS.


Indeed also keep in mind both Postgres and MySQL are cross platform as well.


One final thought: the support you'll be able to get from the PostgreSQL
> community is absolutely top-notch, possibly even better than the support
> from the SQLite community (which is really saying something). I don't
> believe the same can be said of MySQL.


Haha, I have to agree. I've run into performance issues with  MySQL in some
of  projects, but never with Postgres. Keep in mind I'm a die hard Postgres
user and totally loath MySQL, because its had very annoying issues.


Re: [sqlite] SQLite Advocacy

2005-01-31 Thread Paul Malcher
Fred Williams wrote:
Politically, if you  are in the organization that was "acquired", you
best bite the bullet and learn to dance the Big Gates' version of "I
Shall Overcome."  I don't think there is a WinCE version of SQL Server,
(yet) so that might be your only real chance.
My experience with organizations that embrace all things Gates' is,
pretty much any technical advantageous products which lie outside the
Mickeysoft umbrella are ignored and usually completely banned as, "not
conforming to organization policy."
Fred
 

Hi,
I so agree with Fred he's nailed it dead on.


Re: [sqlite] SQLite Advocacy

2005-01-31 Thread Paul Malcher
Downey, Shawn wrote:
I am trying to overcome the attitude of:
"If SQLite is as good as you say, then why is it free?"
and 

"If anyone can see the source code, then won't we be venerable to
hackers?"
Hi, I hope I may be of assistance in this area. I own my own company and 
we use exclusively open source stuff for ourselves and clients. We went 
thought those questions too. What you must have them understand is that 
just because its open source and free, doesn't mean its of low quality. 
You see open source projects, ones like SQLite have many people working 
on them and looking the source over. As a result of this you get a high 
quality yet, free project. The more people that look at the source and 
stuff, the more of a bug free/exploit free product you end up with. The 
bugs that do exist also tend to be discovered quickly and fixed rather 
quickly.  Of course  there is always encryption if you're that  
worried.  Also if SQLite worked for you guys before then why change?  As 
some else mentioned, MS SQL is a full rdbms and SQLite is embedded. On a 
more opinion side of things I condemn anything made by MS, by default 
anyhow. Oh, as far as vulnerability to hackers goes, that depends on how 
well the project is run, if they fix bugs quickly and such then you need 
not be to worried. Also depends on how its built, do they build it in a 
manner that doesn't present vulnerabilities. I would recommend 
encryption though if you're really worried.