Re: sqlite3 and dates

Path	csiph.com!usenet.pasdenom.info!weretis.net!feeder1.news.weretis.net!feeder.erje.net!eu.feeder.erje.net!newsfeed.xs4all.nl!newsfeed2.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail
Return-Path	<rosuav@gmail.com>
X-Original-To	python-list@python.org
Delivered-To	python-list@mail.python.org
X-Spam-Status	OK 0.001
X-Spam-Evidence	'H': 1.00; 'S': 0.00; 'scripts': 0.03; 'received:209.85.223': 0.03; 'schema': 0.05; 'installed.': 0.07; 'alter': 0.09; 'badly': 0.09; 'git': 0.09; 'hooks': 0.09; 'postgresql,': 0.09; 'postgresql.': 0.09; 'sucks': 0.09; 'to)': 0.09; 'cc:addr:python-list': 0.11; 'python': 0.11; "wouldn't": 0.14; '"create': 0.16; 'ah,': 0.16; 'concurrency,': 0.16; 'from:addr:rosuav': 0.16; 'from:name:chris angelico': 0.16; 'none.': 0.16; 'operation,': 0.16; 'secondarily': 0.16; 'subject:dates': 0.16; 'subject:sqlite3': 0.16; 'tables,': 0.16; 'wrote:': 0.18; 'wed,': 0.18; 'server,': 0.19; 'feb': 0.22; 'import': 0.22; 'cc:addr:python.org': 0.22; 'cc:2**0': 0.24; "i've": 0.25; 'push': 0.26; 'updating': 0.26; 'header:In-Reply- To:1': 0.27; 'ideal': 0.29; 'reporting': 0.29; 'message- id:@mail.gmail.com': 0.30; "i'm": 0.30; 'too.': 0.31; 'becoming': 0.31; 'fine,': 0.31; 'minor': 0.31; 'quantities': 0.31; 'table,': 0.31; 'anyone': 0.31; 'file': 0.32; 'quite': 0.32; 'text': 0.33; "i'd": 0.34; 'problem': 0.35; 'received:209.85': 0.35; 'common': 0.35; 'operations': 0.35; 'but': 0.35; 'received:google.com': 0.35; 'add': 0.35; 'limitations': 0.36; 'doing': 0.36; 'invoice': 0.37; 'received:209': 0.37; 'being': 0.38; 'work?': 0.38; 'files': 0.38; 'pm,': 0.38; 'anything': 0.39; 'does': 0.39; 'company': 0.60; 'then,': 0.60; 'most': 0.60; 'new': 0.61; 'entire': 0.61; 'central': 0.64; 'more': 0.64; 'frank': 0.68; '2015': 0.84; 'bite': 0.84; 'column.': 0.84; 'demos': 0.84; 'inquiring': 0.84; 'way...': 0.84; 'to:none': 0.92; 'businesses.': 0.93
DKIM-Signature	v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:cc :content-type; bh=HsPmLIFl7y6iFY4++7x8pBXjM18egWB/fPoZ7BNCLuc=; b=TPkkmkosWaiuAQaHLTDdDUA+vMjq20g48iVO6PSNimwEi6VV+i2IB1GR+NbI/FIU+X geBsIKilBe6c4Alobh90o8TQlc55EvOZ39pKt6oWNH8gPKkBLaj+6dY3HJyud74uAjQm 5hWRxKsXowG7rHnycBUJiH6fPYaetHq0lVHjf8i/LwpGghRIldjYllWEKpHJzr9rSgkE 1Lr5gH2LCjY6rzgYSrbct1F5UsaHDQPhj+ugV3hDeNyvR1mjCrMVw5msmCojzR0PE80Z im7v2whPJNVWccKdWvaHd0S6giEm1FUnQZCeorgeypGlz4JJvrLl/hHKbLuU6vrLmymB OZWw==
MIME-Version	1.0
X-Received	by 10.50.79.161 with SMTP id k1mr1845943igx.14.1424253206297; Wed, 18 Feb 2015 01:53:26 -0800 (PST)
In-Reply-To	<mc1g78$rro$1@ger.gmane.org>
References	<mc1atd$cq0$1@ger.gmane.org> <CAPTjJmrB+55CVgN6zTUawRf=rzn9LTaVi5TzhJSYvHHywK1vOw@mail.gmail.com> <mc1g78$rro$1@ger.gmane.org>
Date	Wed, 18 Feb 2015 20:53:26 +1100
Subject	Re: sqlite3 and dates
From	Chris Angelico <rosuav@gmail.com>
Cc	"python-list@python.org" <python-list@python.org>
Content-Type	text/plain; charset=UTF-8
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.18812.1424253215.18130.python-list@python.org> (permalink)
Lines	34
NNTP-Posting-Host	2001:888:2000:d::a6
X-Trace	1424253215 news.xs4all.nl 2885 [2001:888:2000:d::a6]:51299
X-Complaints-To	abuse@xs4all.nl
Xref	csiph.com comp.lang.python:85781

Show key headers only | View raw

On Wed, Feb 18, 2015 at 6:49 PM, Frank Millman <frank@chagford.com> wrote:
> My accounting software supports three databases - MS Sql Server, PostgreSQL,
> and sqlite3.
>
> sqlite3 is not suitable for 'heavy-duty' applications, but it is ideal for
> demos and one-man businesses. Anyone can try out my software so long as they
> have python installed. They do not have to set up a database.

I wouldn't trust sqlite3 with my accounting... but then, I'm becoming
more and more disillusioned with most full-scale accounting packages,
too. I'm seriously looking toward a git-managed directory of text
files as being the accounting package of the future; a few pre-commit
hooks (and/or pre-receive if you want to have a central repo that
people push to) to check file formats and stuff; and then some scripts
that do maintenance and reporting (eg updating inventory quantities
when you mark an invoice as completed). I want to see a big company
work this way... it's clearly not a problem for a one-man operation,
as I've been doing exactly that for some time (with very few scripts),
and we do know that git scales to global operations just fine, but
will it actually work? Inquiring minds must know!

But anyway, I wouldn't push people onto sqlite3 for anything serious,
mainly because it sucks at concurrency, secondarily because it lacks a
number of common features. I'd push people to PostgreSQL.

> sqlite3 does support ALTER TABLE, but with limited functionality. I think
> all you can do is add a column.

Ah, true. Minor support for altering tables, not quite none. But
still, there's a lot of limitations that will bite you badly any time
you try to migrate a schema using anything other than the brute-force
"create entire new database and import the content".

ChrisA

Back to comp.lang.python | Previous | Next | Find similar | Unroll thread

Thread

Re: sqlite3 and dates Chris Angelico <rosuav@gmail.com> - 2015-02-18 20:53 +1100

csiph-web