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

Groups > comp.lang.python > #28884

Re: simple client data base

Followups directed to: comp.lang.python

Show all headers | View raw

Mark R Rivet wrote:

> Thomas 'PointedEars' Lahn wrote:
>> Mark R Rivet wrote:
>>> Hello all, I am learning to program in python. I have a need to make a
>>> program that can store, retrieve, add, and delete client data such as
>>> name, address, social, telephone number and similar information. This
>>> would be a small client database for my wife who has a home accounting
>>> business.
>>> 
>>> I have been reading about lists, tuples, and dictionary data
>>> structures in python and I am confused as to which would be more
>>> appropriate for a simple database.
>> 
>> […]
>> However, if you want your program to manipulate the data *persistently*.
>> as it will probably be needed for business, you will need to also store
>> it somewhere else than in the volatile memory in which these data
>> structures are usually stored.  The most simple way would be to store and
>> parse the string representation of the objects.
>>
>> Production-quality implementations of those and other concepts already
>> exist, of course, but using something finished and polished does not
>> provide as much learning experience.
> 
> Now this is the kind of answer I was hoping for. This gives me food
> for thought. Now I have some Ideas of how to appproach this thing. I
> know that there are solutions to this problem already but I need to do
> my own before I can really use anything better. Thanks for the help. I
> fully intend to go with a real realational database, but not now. My
> version 1 will be a console interface and dictionaries, lists and
> pickling. Version 2 will be with a GUI written in tkinter, and better
> and better. I just want to learn how to lay the bricks before I start
> using prefab walls.

You are welcome.  However, I have to concur with the others that in terms of 
efficiency and reliability, which leads to household peace, you are better 
off starting with a prepackaged solution instead.

You can keep developing your Python-powered database as a pet project for 
the time being.  Your wife will be even more impressed if at one day you can 
tell her that you wrote completely customizable software that works the same 
or even better than the one she has been getting used to :)  Even if not, 
you will have learned much about Python and related concepts along the way.  
Keep in mind, then, that you probably also need a graphical user interface.

Please trim your quotes to the relevant minimum next time.

-- 
PointedEars

Twitter: @PointedEars2
Please do not Cc: me. / Bitte keine Kopien per E-Mail.

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

Thread

simple client data base Mark R Rivet <markrrivet@aol.com> - 2012-09-03 10:12 -0400
  Re: simple client data base "Martin P. Hellwig" <martin.hellwig@gmail.com> - 2012-09-03 07:27 -0700
  Re: simple client data base Chris Angelico <rosuav@gmail.com> - 2012-09-04 00:28 +1000
  Re: simple client data base Mark Lawrence <breamoreboy@yahoo.co.uk> - 2012-09-03 15:37 +0100
  Re: simple client data base Peter Otten <__peter__@web.de> - 2012-09-03 16:50 +0200
    Re: simple client data base Mark R Rivet <markrrivet@aol.com> - 2012-09-08 15:22 -0400
      Re: simple client data base Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2012-09-08 17:42 -0400
  Re: simple client data base Wolfgang Keller <feliphil@gmx.net> - 2012-09-03 18:03 +0200
    Re: simple client data base Walter Hurry <walterhurry@lavabit.com> - 2012-09-03 19:02 +0000
      Re: simple client data base Wolfgang Keller <feliphil@gmx.net> - 2012-09-04 15:17 +0200
  Re: simple client data base Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2012-09-04 04:25 +0200
    Re: simple client data base Mark R Rivet <markrrivet@aol.com> - 2012-09-08 15:40 -0400
      Re: simple client data base Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2012-09-11 13:28 +0200
  Re: simple client data base Ramchandra Apte <maniandram01@gmail.com> - 2012-09-05 05:57 -0700
    Re: simple client data base Mark R Rivet <markrrivet@aol.com> - 2012-09-08 15:42 -0400
  Re: simple client data base Bryan <bryanjugglercryptographer@yahoo.com> - 2012-09-06 01:57 -0700
    Re: simple client data base Mark R Rivet <markrrivet@aol.com> - 2012-09-08 15:47 -0400
      Re: simple client data base Jason Friedman <jason@powerpull.net> - 2012-09-08 14:05 -0600
      Re: simple client data base Paul Rubin <no.email@nospam.invalid> - 2012-09-08 13:11 -0700
        Re: simple client data base Ian W <mymixedmess@gmail.com> - 2012-09-08 15:32 -0500
        Re: simple client data base Walter Hurry <walterhurry@lavabit.com> - 2012-09-08 20:39 +0000
      Re: simple client data base Jorgen Grahn <grahn+nntp@snipabacken.se> - 2012-09-08 21:03 +0000
      Re: simple client data base Bryan <bryanjugglercryptographer@yahoo.com> - 2012-09-09 09:06 -0700
      Re: simple client data base Tim Chase <python.list@tim.thechases.com> - 2012-09-09 13:27 -0500
        Re: simple client data base Paul Rubin <no.email@nospam.invalid> - 2012-09-09 11:55 -0700

csiph-web