Path: csiph.com!usenet.pasdenom.info!gegeweb.org!newsfeed0.kamp.net!newsfeed.kamp.net!feeder1.cambriumusenet.nl!feed.tweaknews.nl!194.109.133.86.MISMATCH!newsfeed.xs4all.nl!newsfeed3a.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail
Return-Path: <python-python-list@m.gmane.org>
X-Original-To: python-list@python.org
Delivered-To: python-list@mail.python.org
X-Spam-Status: OK 0.000
X-Spam-Evidence: '*H*': 1.00; '*S*': 0.00; '(so': 0.07; 'modified': 0.07; 'mysql,': 0.07; "(i'd": 0.09; 'alter': 0.09; 'here?': 0.09; 'indicates': 0.09; 'latter': 0.09; 'objects)': 0.09; 'received:80.91': 0.09; 'received:80.91.229': 0.09; 'received:gmane.org': 0.09; 'received:list': 0.09; 'referenced': 0.09; 'subject:module': 0.09; 'django': 0.11; 'stored': 0.12; 'books': 0.15; 'windows': 0.15; '(other': 0.16; '(there': 0.16; '>on': 0.16; '[and': 0.16; 'dig': 0.16; 'fork': 0.16; 'letting': 0.16; 'message-id:@4ax.com': 0.16; 'otoh,': 0.16; 'received:80.91.229.3': 0.16; 'received:plane.gmane.org': 0.16; 'specifying': 0.16; 'sqlite': 0.16; 'subject:access': 0.16; 'targets': 0.16; 'subject:python': 0.16; 'alpha': 0.16; 'wrote:': 0.18; 'commit': 0.19; 'seems': 0.21; 'command': 0.22; 'feb': 0.22; 'separate': 0.22; 'print': 0.22; 'specify': 0.24; 'test.': 0.24; 'url:home': 0.24; 'mon,': 0.24; '(or': 0.24; "i've": 0.25; 'header:X-Complaints-To:1': 0.27; 'chris': 0.29; 'am,': 0.29; '(which': 0.31; '3.x': 0.31; 'anyone': 0.31; 'file': 0.32; 'linux': 0.33; 'subject:the': 0.34; 'advice': 0.35; 'but': 0.35; 'add': 0.35; 'version': 0.36; 'scheme': 0.36; 'charset:us-ascii': 0.36; 'subject:?': 0.36; 'architecture': 0.38; 'received:76': 0.38; 'server': 0.38; 'to:addr:python-list': 0.38; 'files': 0.38; 'does': 0.39; 'moving': 0.39; 'to:addr:python.org': 0.39; 'received:org': 0.40; 'users': 0.40; 'how': 0.40; 'new': 0.61; 'become': 0.64; 'more': 0.64; 'granted': 0.65; 'life': 0.66; 'covers': 0.68; 'limit': 0.70; 'records': 0.73; 'owner,': 0.78; 'subject:SQL': 0.84; 'subject:recommended': 0.84; 'opt-in': 0.91; 'time)': 0.91; 'tied': 0.93
X-Injected-Via-Gmane: http://gmane.org/
To: python-list@python.org
From: Dennis Lee Bieber <wlfraed@ix.netcom.com>
Subject: Re: What is the recommended python module for SQL database access?
Date: Sun, 09 Feb 2014 19:27:24 -0500
Organization: IISS Elusive Unicorn
References: <d2aa22af-8771-4944-ba2a-1098f9b5a735@googlegroups.com> <CAFEv2m5BOdZ3PzdVfQTw-K9xJ=oWiLi5ZOUFHAkimdndDshBnQ@mail.gmail.com> <CAPTjJmpuF=0peDWrgaUB+PZri3E=tM3vwkh=e0sFDYyqHoDRiw@mail.gmail.com> <5e6ff9tu3ih5c080so22ubsgbh4674ifto@4ax.com> <CAPTjJmrK-EKbRpF-fjAP7sEJXnQvdgj_VQoCw20fzT8KeAhk6g@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Gmane-NNTP-Posting-Host: adsl-76-249-26-199.dsl.klmzmi.sbcglobal.net
X-Newsreader: Forte Agent 6.00/32.1186
X-No-Archive: YES
X-BeenThere: python-list@python.org
X-Mailman-Version: 2.1.15
Precedence: list
List-Id: General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe: <https://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive: <http://mail.python.org/pipermail/python-list/>
List-Post: <mailto:python-list@python.org>
List-Help: <mailto:python-list-request@python.org?subject=help>
List-Subscribe: <https://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups: comp.lang.python
Message-ID: <mailman.6606.1391992060.18130.python-list@python.org>
Lines: 49
NNTP-Posting-Host: 2001:888:2000:d::a6
X-Trace: 1391992060 news.xs4all.nl 2863 [2001:888:2000:d::a6]:59646
X-Complaints-To: abuse@xs4all.nl
Xref: csiph.com comp.lang.python:65790

On Mon, 10 Feb 2014 09:03:46 +1100, Chris Angelico <rosuav@gmail.com>
declaimed the following:

>On Mon, Feb 10, 2014 at 2:40 AM, Dennis Lee Bieber
><wlfraed@ix.netcom.com> wrote:
>>         Any opinion on Firebird? Just curiosity given how often the advice
>> seems to be "start with SQLite, avoid MySQL, end with PostgreSQL"
>
>No, because I've never used it. Has anyone here? What are its
>strengths and weaknesses?
>

	My book is a decade old; seems the fate of Firebird and Django both
were to get books out in print, and then become moving targets with no
print updates <G> My book covers v1.5; the web site indicates that 3.x is
in Alpha test.


	It started life as a fork of Borland's InterBase 6... From the intro:

Multi-generational architecture (some scheme to reduce locking by letting
each client have its own version of modified records up to commit time)

Transactions, stored procedures, triggers (so what else is new <G>)

Database shadowing (which they state is NOT replication)

Opt-in SQL privileges (other than sysdba and database owner, no other users
have any automatic access -- they must be granted access to objects)

Classic/Superserver/Embedded (I'd have to dig deeper, but Superserver [and
embedded] are mult-threaded; I impute then that Classic spawns a separate
process for each connection)

Linux can use SMP, Windows need Classic server to use SMP

Databases are referenced by filepath -- not tied to a particular directory
or set of files (there is a "restrict" configuration item).

For systems with limited file sizes one can specify additional files in the
CREATE DATABASE command (or ALTER DATABASE), specifying the size limit of
each.

	The latter condition may add more to administration then others -- but
OTOH, does allow for larger databases than SQLite on Win32.
-- 
	Wulfraed                 Dennis Lee Bieber         AF6VN
    wlfraed@ix.netcom.com    HTTP://wlfraed.home.netcom.com/