Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.python > #16281

Re: my new project, is this the right way?

References <4ec0f070$0$1378$4fafbaef@reader2.news.tin.it> <581dab49-e6b0-4fea-915c-4a41fa887c3b@p7g2000pre.googlegroups.com> <11840843.114.1322350898307.JavaMail.geo-discussion-forums@prfi36>
From Matt Joiner <anacrolix@gmail.com>
Date 2011-11-27 15:03 +1100
Subject Re: my new project, is this the right way?
Newsgroups comp.lang.python
Message-ID <mailman.3070.1322366629.27778.python-list@python.org> (permalink)

Show all headers | View raw


Sounds like you want a key-value store. If it's a lot of data, you may
still want a "database", I think it's just relational databases that
you're trying to avoid?

On Sun, Nov 27, 2011 at 10:41 AM, 88888 Dihedral
<dihedral88888@googlemail.com> wrote:
> On Saturday, November 26, 2011 1:01:34 AM UTC+8, rusi wrote:
>> On Nov 14, 3:41 pm, Tracubik <affdfs...@b.com> wrote:
>> > Hi all,
>> > i'm developing a new program.
>> > Mission: learn a bit of database management
>> > Idea: create a simple, 1 window program that show me a db of movies i've
>> > seen with few (<10) fields (actors, name, year etc)
>> > technologies i'll use: python + gtk
>> > db: that's the question
>> >
>> > since i'm mostly a new-bye for as regard databases, my idea is to use
>> > sqlite at the beginning.
>> >
>> > Is that ok? any other db to start with? (pls don't say mysql or similar,
>> > they are too complex and i'll use this in a second step)
>> >
>> > is there any general tutorial of how to start developing a database? i
>> > mean a general guide to databases you can suggest to me?
>> > Thank you all
>> >
>> > MedeoTL
>> >
>> > P.s. since i have a ods sheet files (libreoffice calc), is there a way to
>> > easily convert it in a sqlite db? (maybe via csv)
>>
>> To learn DBMS you need to learn sql
>> [Note sql is necessary but not sufficient for learning DBMS]
>> I recommend lightweight approaches to start with -- others have
>> mentioned access, libreoffice-base.
>> One more lightweight playpen is firefox plugin sqlite-manager
>>
>> > Is that ok? any other db to start with? (pls don't say mysql or similar,
>> > they are too complex and i'll use this in a second step)
>>
>> Correct. First you must figure out how to structure data -- jargon is
>> normalization.
>> After that you can look at transactions, ACID, distribution and all
>> the other good stuff.
>
> If I have a fast hash library  that each hash function supports insertion and deletion and can be frozen to be stored into the file system if desired and retrieved lator . Can I use several hashes to replace a database that is slow and expensive?
>
> --
> http://mail.python.org/mailman/listinfo/python-list
>

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


Thread

my new project, is this the right way? Tracubik <affdfsdfdsfsd@b.com> - 2011-11-14 10:41 +0000
  Re: my new project, is this the right way? Chris Angelico <rosuav@gmail.com> - 2011-11-14 21:55 +1100
    Re: my new project, is this the right way? HoneyMonster <someone@someplace.invalid> - 2011-11-25 15:44 +0000
      Re: my new project, is this the right way? Chris Angelico <rosuav@gmail.com> - 2011-11-26 02:49 +1100
  Re: my new project, is this the right way? Redcat <redcat@catfolks.net> - 2011-11-14 15:47 +0000
  Re: my new project, is this the right way? Jon Clements <joncle@googlemail.com> - 2011-11-14 08:37 -0800
  Re: my new project, is this the right way? Miki Tebeka <miki.tebeka@gmail.com> - 2011-11-14 09:48 -0800
  Re: my new project, is this the right way? rusi <rustompmody@gmail.com> - 2011-11-25 09:01 -0800
    Re: my new project, is this the right way? Roy Smith <roy@panix.com> - 2011-11-25 12:16 -0500
      Re: my new project, is this the right way? rusi <rustompmody@gmail.com> - 2011-11-25 20:48 -0800
    Re: my new project, is this the right way? 88888 Dihedral <dihedral88888@googlemail.com> - 2011-11-26 15:41 -0800
      Re: my new project, is this the right way? Dave Angel <d@davea.name> - 2011-11-26 21:35 -0500
        Re: my new project, is this the right way? Roy Smith <roy@panix.com> - 2011-11-26 21:49 -0500
          Re: my new project, is this the right way? 88888 Dihedral <dihedral88888@googlemail.com> - 2011-11-26 19:14 -0800
            Re: my new project, is this the right way? Chris Angelico <rosuav@gmail.com> - 2011-11-27 14:24 +1100
            Re: my new project, is this the right way? Dave Angel <d@davea.name> - 2011-11-26 22:27 -0500
            Re: my new project, is this the right way? Roy Smith <roy@panix.com> - 2011-11-26 22:41 -0500
      Re: my new project, is this the right way? Matt Joiner <anacrolix@gmail.com> - 2011-11-27 15:03 +1100
        Re: my new project, is this the right way? 88888 Dihedral <dihedral88888@googlemail.com> - 2011-11-27 00:29 -0800
          Re: my new project, is this the right way? 88888 Dihedral <dihedral88888@googlemail.com> - 2011-11-27 00:49 -0800
            Re: my new project, is this the right way? 88888 Dihedral <dihedral88888@googlemail.com> - 2011-11-28 00:51 -0800
            Re: my new project, is this the right way? 88888 Dihedral <dihedral88888@googlemail.com> - 2011-11-28 00:51 -0800
          Re: my new project, is this the right way? 88888 Dihedral <dihedral88888@googlemail.com> - 2011-11-27 00:49 -0800
        Re: my new project, is this the right way? 88888 Dihedral <dihedral88888@googlemail.com> - 2011-11-27 00:29 -0800

csiph-web