Path: csiph.com!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!feeds.phibee-telecom.net!newsfeed.xs4all.nl!newsfeed2.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail
Return-Path: <ethan@stoneleaf.us>
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; '*not*': 0.07; 'json': 0.07; 'from:addr:ethan': 0.09; 'from:addr:stoneleaf.us': 0.09; 'from:name:ethan furman': 0.09; 'message-id:@stoneleaf.us': 0.09; 'mysql.': 0.09; 'postgres': 0.09; 'postgresql,': 0.09; 'sure,': 0.09; '~ethan~': 0.09; 'wrote': 0.14; 'be:': 0.16; 'concurrency': 0.16; 'concurrent': 0.16; 'db2,': 0.16; 'etc...': 0.16; 'filename:fname piece:signature': 0.16; 'lite': 0.16; 'sqlite': 0.16; 'subject:dates': 0.16; 'subject:sqlite3': 0.16; 'wrote:': 0.18; 'things.': 0.19; 'thu,': 0.19; 'feb': 0.22; '>>>': 0.22; 'install': 0.23; 'header:User-Agent:1': 0.23; "aren't": 0.24; 'header:In-Reply-To:1': 0.27; 'installed': 0.27; 'chris': 0.29; 'am,': 0.29; "doesn't": 0.30; 'especially': 0.30; 'advice': 0.35; 'but': 0.35; 'add': 0.35; 'there': 0.35; "didn't": 0.36; 'should': 0.36; 'application': 0.37; 'to:addr:python-list': 0.38; 'sure': 0.39; 'to:addr:python.org': 0.39; 'even': 0.60; 'received:173': 0.61; 'services,': 0.61; 'great': 0.65; 'benefit': 0.68; '2015': 0.84; 'blob': 0.84; 'comparable': 0.84; 'fat': 0.84
Date: Wed, 18 Feb 2015 14:52:36 -0800
From: Ethan Furman <ethan@stoneleaf.us>
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:24.0) Gecko/20100101 Thunderbird/24.5.0
MIME-Version: 1.0
To: python-list@python.org
Subject: Re: sqlite3 and dates
References: <mc1atd$cq0$1@ger.gmane.org> <mailman.18805.1424243139.18130.python-list@python.org> <mc1s1e$feh$1@news.albasani.net> <mailman.18815.1424258499.18130.python-list@python.org> <4154cc37-0bb0-4bf2-a52c-b728c737357c@googlegroups.com> <CAPTjJmogRj_==1wUcLooFwDhUK+saSaAkQEuUo4o30n8aRdB=w@mail.gmail.com>
In-Reply-To: <CAPTjJmogRj_==1wUcLooFwDhUK+saSaAkQEuUo4o30n8aRdB=w@mail.gmail.com>
Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="E2WDoW32IwvUO2d72NLlpljbjsmAJpAuE"
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.18841.1424299967.18130.python-list@python.org>
Lines: 63
NNTP-Posting-Host: 2001:888:2000:d::a6
X-Trace: 1424299967 news.xs4all.nl 2931 [2001:888:2000:d::a6]:55270
X-Complaints-To: abuse@xs4all.nl
Xref: csiph.com comp.lang.python:85829

This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--E2WDoW32IwvUO2d72NLlpljbjsmAJpAuE
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On Thu, Feb 19, 2015 at 9:17 AM,  rurpy wrote:
> That you would equate that to a JSON blob [...]

Chris wrote:
> I didn't equate them.

>> Chris wrote earlier:
>>> and you manipulate it just the same as if it were a big fat blob
>>> of JSON

That sure sounds like equating.

Chris also wrote:
> But SQLite3 is *not* great if you look on it as a database engine
> comparable with DB2, PostgreSQL, and even MySQL.

Sure, the LITE in SQLite means you don't get some things.  There is still=
 a huge amount of software that doesn't need
concurrency and can benefit from it.

Having installed Postgres I can say there is definitely a cost to install=
 it, use it, maintain it, etc... especially if
you aren't steeped in it and have to look things up every time you have t=
o make a change (how do I add a user again?).

I think the general advice should be:  if you are writing a single-user a=
pplication that happens to need SQL services,
check out SQLite; if you are writing a multi-user or concurrent SQL appli=
cation, check out Postgres.

--
~Ethan~


--E2WDoW32IwvUO2d72NLlpljbjsmAJpAuE
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)

iQIcBAEBAgAGBQJU5Re5AAoJENZ7D1rrH75NgwgQAMhfIxnl4kaJ0eh1nQMPtvCN
uAOKY6J84wVxGRvfTDYaDrO94OPRq8ZlAseoVo2OghFb1lGLS2MY1LlgFlQR+mLS
mdfN+fSXQerZn1X8otzsFfN2CEi0urQQqHMTK4yw5h3CXBx6fn5+J5GWwS0ltGVT
otujTBlpDHOHRGwBwr8KV7WkCdaU7uIt+Us+o1uPMt5Gf3jp8IKhOWnQ+mqOjaFB
PG9nQtFgm8/QGvAuHRrkKF+12z+7yElNYceWojwJ++Vr84B3CjQEP634+rGiLJ91
Ax8amH/b+mmDEvTDRS1fDHnUonWzSNowp5ocEUz13R4dYaY3vzqAyl5vZeRIjaok
vbyjjFtVb8ERJY+glyfspl3tVMFpT22yYTSEkq7d5FJ7H9+R5bgdoKKwPQSc75QV
xk37AYZP0MQ0s5HVX0vWEwL/A7+Goe7/4qkezoy1JhX1wuVwN6rXasG2jOAJ6tpm
CAbcqSpRDMVbky6rHZIRxmwNrFyrIdFm7JLzgrDhZ+qZBMZV5DkxQlXKFrqcZvVb
NEDpb+d3JypuP8lHmWJXfStWN10jA5AYCL8vABE03UcfvM51pB31lC63asOepF17
LUXRPDaIsecVA/vFSYFH+lkf5Sw+qv6MkDqi6/JHr9OmoEnNMoAd/JvX+1UInEzm
ZKje6NRQAx5UNUXC/anY
=0sMk
-----END PGP SIGNATURE-----

--E2WDoW32IwvUO2d72NLlpljbjsmAJpAuE--