On Tuesday, December 07, 2010 11:28:05 pm you wrote: > On Wednesday 08 December 2010 5:56:50 pm you wrote: > > Welcome to the wonderful world of Dabo. I think you have found a home. > > Several on the list are former VFPers (myself included). > > Thank you. > > > The access of data is done via modules (sort of like ODBC, and special > > drivers on windows) in python language. For example to access Postgres > > the psycopg2 module is the one Dabo uses (also the most popular). And to > > access DBF files there several such modules. There is even one that > > prepares dbf data for import into Postgres. > > http://pgdbf.sourceforge.net/ > > > > That should help you to move your dbf's to postgres (assuming you want to > > use postgres). > > No sure. I have quite a few legacy datasets in VFP tables. If I import them > into MySQL or PostgreSQL don't they become huge single files? Changes to a > single field will trigger the need to copy the entire 'collection'. > > For example, rsync to backup my Ubuntu system and RoboCopy to copy tables > to my TabletPC for use in the field (MS Vista). My VirtualMachines map > drives into my Linux Boxes. > > As VFP tables, only tables that are changed are copied when backing up or > synchronizing the computers. If MySQL and PostgreSQL store the database as > a megafile, like what happens whenever you use a VirtualMachine, the whole > file is copied. this would be a problem. Is this correct or is the > PostgreSQL database actually a loose collection of files and > subdirectories? > > > If your programs are single user then you might want to consider > > SQLite. It has the advantage of being built-in to python. And I guess > > one can think of it like dbf's in the sense that it's always available in > > python. > > Is there any documentation on this? I have been reading books on Python and > actively perusing the Python Sites and I have not got the impression that > SQLite is built-in. What commands are dedicated to table creation, > manipulation, etc? Why hasn't the SQLite engine been automatically > installed with my standard Python Install on Linux, XP (VM) or Vista > Machines? > > > Just be aware that Dabo supports SQLite, Postgres, MySQL, and Firebird > > (there is also some support for MsSQL). > > That's fantastic. Now I have the problem of really deciding where to go. At > present I am favouring PostgreSQL because it can be coupled with PostGIS to > provide equivalent functionality to Oracle with DSE. I do a lot of work in > GIS and want a solution that could be suitable for both standard database > work and geospatial anlaysis. > > > Also make sure you check the screencasts on the Dabo site - > > www.dabodev.com > > I have been looking at these today. They are really good and certainly wet > my appetite. The only reason I have not installed the package already is > that the install instructions are a bit diffeent than I have seen before > and so I need to spend a bit more time considering what is happening. > Usually packages are normally installed as tar files or with deb files in > Ubuntu, or if they are ina a repository using synaptic, apt or Ubuntu > Software Centre. > > I have scheduled some time later this week to give the installation a go.
Most modern databases maintain a single datastore (one file). But most (if not all) have routines for backup that will only copy the changes. At a personal level I like to copy the entire database (easy restore) and use a compression routine to keep it smaller (but only after it's 5 gigs or so) and to speed up the transfer. With today's HD's, tapes, and network NAS system the space is not much of a concern. The true concern is the IO. SQlite is there no worries (the only it's not is if you have a very old python). Google is you friend here try: http://www.devshed.com/c/a/Python/Using-SQLite-in-Python/ I am using Postgres with postGIS and love it. If you do go with Postgres checkout the function debugger available from EB enterprizes. With respect to installing python modules - it is more than a little different than other ubuntu packages. Python (like Perl) has been around for a long time and has developed it's own routines. Most modules get installed in PYTHONPATH ->site-packages. But there are exceptions (to many). In your case (on ubuntu) you need to install wxPython first (Dabo requires it). You should use the ubuntu routines to install wxPython. Side Note: the latest versions of ubuntu install routine for wxPython does several things differently (I don't recall all issues - but I did find it strange) then many of the other distro's and windows. If you read the Dabo's install instructions carefully (check what is has been said about Ubuntu) you will be using Dabo in less than an hour! Johnf _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[email protected]
