Re: [Tutor] Help with choices for new database program

2010-07-04 Thread Jeff Johnson

On 07/03/2010 08:25 AM, Jim Byrnes wrote:

Jeff Johnson wrote:

On 07/02/2010 11:40 AM, Chris C. wrote: I'm writing this question
because I want, for my own satisfaction, to rewrite one of my Access dbs
(one that does our finances) into a stand-alone Python database program
using SQLite. I know I'll be learning as I go, but that'll work, I'm not
in a big hurry and I'll work on it in my spare time. Right now I'm
trying to get organized and get a game plan, and that's where I need 
help.


I have been developing database applications for 20 years using FoxPro
and VFP. Now I am developing using Dabo. Dabo is a framework wrapper for
wxPython written totally in Python. I use SQLite for small applications
and PostgreSQL for larger ones. Dabo was written by two of the top
FoxPro developers and is supported by many others all over the world.

http://dabodev.com/

Please check it out. And go to www.leafe.com and subscribe to the
dabo-user email list.



I would like to try out Dabo, but I don't see it in the Ubuntu 
repositories and I would like to avoid using svn if I can.  I didn't 
subscribe to the mailing list but I did read the archives and saw a 
thread about making a deb package.  It seems to have ended in April 
without a clear resolution.


So is there a package available so I can use the Ubuntu package 
manager to install it?


Thanks,  Jim

I use Ubuntu 10.04 and Windows XP.  The developers of Dabo use Mac and 
Ubuntu.  Dabo runs without modification on all three major platforms.  
It is a given that while Ubuntu is awesome at supplying packages, there 
might be some that you have to go get.


That's all I can say about that.

--
Jeff

---

Jeff Johnson
j...@san-dc.com
(623) 582-0323

www.san-dc.com

___
Tutor maillist  -  Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor


Re: [Tutor] Help with choices for new database program

2010-07-04 Thread Jim Byrnes

Martin Walsh wrote:

On 07/03/2010 10:25 AM, Jim Byrnes wrote:

Jeff Johnson wrote:


[snip]


http://dabodev.com/

Please check it out. And go to www.leafe.com and subscribe to the
dabo-user email list.


I would like to try out Dabo, but I don't see it in the Ubuntu
repositories and I would like to avoid using svn if I can.  I didn't
subscribe to the mailing list but I did read the archives and saw a
thread about making a deb package.  It seems to have ended in April
without a clear resolution.

So is there a package available so I can use the Ubuntu package manager
to install it?


Unfortunately, after poking around a bit it would seem the only reliable
way of installing dabo for Linux at the moment is checking out trunk
from the project's subversion repository. Someone better informed should
feel free to set the record straight, if I am mistaken.

If your interest in a deb package is mainly the ability to uninstall,
then I'd recommend using virtualenv[1] until a suitable deb package is
released. The steps would be roughly this (untested) ...


That's part of it but mainly it's that they are so easy to install.


$ sudo apt-get install python-reportlab python-wxgtk2.8
$ sudo apt-get install subversion python-virtualenv
$ virtualenv daboenv
$ cd daboenv
$ source bin/activate # this is important
# now we install dabo as recommended, adapted from:
#   http://wiki.dabodev.com/InstallationOnLinux
(daboenv)$
(daboenv)$ mkdir src  cd src
(daboenv)$ svn co http://svn.dabodev.com/dabo/trunk dabo
(daboenv)$ cd dabo
(daboenv)$ python setup.py install # no sudo!
# and run the demo to verify the installation
(daboenv)$ demo/DaboDemo.py

...

Hmm, this might seem like a lot of work -- but by using this method,
dabo is installed under daboenv and not in the system-wide site-packages
-- particularly useful for evaluation, IMO. YMMV.


I read the website [1] and being new to linux there was a lot I did not 
understand.  I think I will go the svn route on a test machine before I 
put it on my main machine.



HTH,
Marty

[1] http://virtualenv.openplans.org/


Thanks, Jim

___
Tutor maillist  -  Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor


Re: [Tutor] Help with choices for new database program

2010-07-03 Thread Jeff Johnson

On 07/02/2010 05:35 PM, Chris C. wrote:


Hi Jeff, thank for your reply!  I'm aware of Dabo and was pretty much 
sold on using it until the last couple of days.  I was trying to 
install it so I could start connecting to my tables when I ran into a 
problem with the instructions for installing ReportLab.  I wrote to 
the mailing list Wednesday but haven't heard from anyone.  Being such 
a  beginner and knowing I'll be needing help, it kind of has me wary 
of committing to Dabo when I'm having this trouble getting help before 
I even get started.  I saw your post to the Dabo mailing list with the 
title Reference to bizjob control has been getting responses.  Can 
you confirm whether my question went out to the list recipients?  Did 
you receive it?


Like I was saying, I wanted to use Dabo, but I submitted this question 
to this board because I was beginning to lose faith in being able to 
get help from the Dabo mailing list.


Thanks again,

Chris C.

*From:* Jeff Johnson [mailto:j...@dcsoftware.com]
*Sent:* Friday, July 02, 2010 2:09 PM
*To:* Chris C.
*Subject:* Re: [Tutor] Help with choices for new database program

On 07/02/2010 11:40 AM, Chris C. wrote: I'm writing this question 
because I want, for my own satisfaction, to rewrite one of my Access 
dbs (one that does our finances) into a stand-alone Python database 
program using SQLite.  I know I'll be learning as I go, but that'll 
work, I'm not in a big hurry and I'll work on it in my spare time.  
Right now I'm trying to get organized and get a game plan, and that's 
where I need help.


I have been developing database applications for 20 years using FoxPro 
and VFP.  Now I am developing using Dabo.  Dabo is a framework wrapper 
for wxPython written totally in Python.  I use SQLite for small 
applications and PostgreSQL for larger ones.  Dabo was written by two 
of the top FoxPro developers and is supported by many others all over 
the world.


http://dabodev.com/

Please check it out.  And go to www.leafe.com http://www.leafe.com 
and subscribe to the dabo-user email list.


--

Jeff
  
---
  
Jeff Johnson

j...@dcsoftware.com  mailto:j...@dcsoftware.com
  


Chris:  The folks on the Dabo list are always available for answers.  Ed 
and Paul (Dabo's developers) are always quick to answer questions and I 
guarantee they respond quicker than most lists.  There are many others 
that develop commercial applications with Dabo that are always 
monitoring the list (just like me only more experienced with Dabo and 
Python).  If you are interested please subscribe to the list:


http://www.leafe.com/mailman/listinfo/dabo-users

I did not see your post on the list so no one else did either.  If you 
developed an app using Access than you are a perfect candidate for Dabo 
and you have at least enough understanding of what is going on to use it.


There are four things that need installing in order to use Dabo.  It may 
not go as smooth as a Windows Installshield application, but you can get 
plenty of help and once it is installed you can follow the great screen 
casts and tutorials.  The users of Dabo are developing applications for 
users.  Once you have your application developed there are ways to 
package it based on your platform.


You need Python, wxPython, Dabo, and Report Lab.  You can install PIL if 
you want to manipulate images.  If you need help, just ask!


Many of the people using Dabo are moving over from Visual FoxPro which 
is very similar to Access, so don't be afraid to ask any question.  If 
you ask a question the question and answer will be saved in the archives 
for others to learn.


Come on in, the water is fine!

--
Jeff

---

Jeff Johnson
j...@san-dc.com
(623) 582-0323

www.san-dc.com

___
Tutor maillist  -  Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor


Re: [Tutor] Help with choices for new database program

2010-07-03 Thread Jeff Johnson

On 07/02/2010 06:14 PM, David Hutto wrote:


Stick to the main python libraries(python with sqllite, and for the
standalone exe know it's somewhere, and I've seen it in the past few
days, but didn't pay attention because it wasn't important to what I
was doing at the time) going anywhere else is the beginning of an ADHD
nightmare. It's like being a hypochondriac with an unlimited
healthcare plan, you'll want to see any option except for the obvious
in front of you.

Try not to get distracted by the shiny things unless necessary.
   

I'm not sure how this helps with Chris's application.  I will agree that 
the number of choices is daunting!  The nice thing about Dabo is the 
group is focused on database applications.  Kind of like Django is 
focused on web devopment.


I mean this in a joking way:  If you find that Python and open source 
creates too many decisions then you can consider Microsoft .NET and 
Microsoft SQL Server on Windows 7.


I am a recovering Microsoft developer of over 20 years.  ;^)

BTW learning Python is awesome!

--

Jeff

---

Jeff Johnson
j...@san-dc.com
(623) 582-0323

www.san-dc.com

___
Tutor maillist  -  Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor


Re: [Tutor] Help with choices for new database program

2010-07-03 Thread Jeff Johnson

On 07/02/2010 06:32 PM, David Hutto wrote:

On Fri, Jul 2, 2010 at 9:31 PM, David Huttosmokefl...@gmail.com  wrote:
   


Well, it was mainly that he said he was a beginner and was only using
this for a single banking project, I do believe.

Not that learning a new package would

wouldn't


  be helpful, I like
   

experimenting, and failing/succeeding, but if this is all he needs to
accomplish, then not using more than is necessary would be beneficial.
A simple script, with simple sqlite fields to maintain.

 


David:  Experimenting, failing and succeeding is the life of a 
programmer.  I have been programming for many years in assemply, 
FORTRAN, COBOL, Basic, RPG, FoxPro, C, but I am now totally committed to 
Python.  It is the best of all worlds.  Coming from the Microsoft side, 
open source and Python creates a whole new set of problems.  Do I use 
Windows?  Do I use Linux?  Do I use my Mac Book Pro?  You do have to 
make some decisions before moving on.  The choices are endless.


I have found Dabo and Django to be beneficial for me because they target 
what I want to do.


Your mileage may vary.  ;^)

--
Jeff

---

Jeff Johnson
j...@san-dc.com
(623) 582-0323

www.san-dc.com

___
Tutor maillist  -  Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor


Re: [Tutor] Help with choices for new database program

2010-07-03 Thread Jeff Johnson

On 07/02/2010 06:51 PM, David Hutto wrote:

In the end, there might be so many packages, I might not be able to
handle it all(for my own uses). But, I would think, you would agree
that a simple account balance app, would be no more than tkinter with
a few functions to write and retrieve data from a sqlite db. To quote
Sherlock, 'Sometimes, after eliminating the impossible, what ever is
left, no matter how improbable, must be the solution.', or something
like that.
   


David:  I like your quote!  I am a huge Sherlock Holmes fan.  I like 
Dabo because I develop commercial applications.


--
Jeff

---

Jeff Johnson
j...@san-dc.com
(623) 582-0323

www.san-dc.com

___
Tutor maillist  -  Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor


Re: [Tutor] Help with choices for new database program

2010-07-03 Thread Jeff Johnson

On 07/02/2010 08:19 PM, bob gailer wrote:

On 7/2/2010 5:56 PM, Jeff Johnson wrote:

[snip]



Visual FoxPro ... is very similar to Access

I differ. Access and FoxPro are very different. Yes they both use 
tables, relationships, indexes and SQL. Yes they both have visual 
designers for forms and reports. Yes they both are programmable.


But the differences are much more dramatic than the commonalities. I 
have developed in both. I find it painful to work in one while 
desiring a feature that exists only in the other.


--
Bob Gailer
919-636-4239
Chapel Hill NC

   

Dare you say which?   ;^)


--
Jeff

---

Jeff Johnson
j...@san-dc.com
(623) 582-0323

www.san-dc.com

___
Tutor maillist  -  Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor


Re: [Tutor] Help with choices for new database program

2010-07-03 Thread John
On Friday 02 July 2010 08:19:24 pm bob gailer wrote:
 On 7/2/2010 5:56 PM, Jeff Johnson wrote:
  [snip]
 
  Visual FoxPro ... is very similar to Access

 I differ. Access and FoxPro are very different. Yes they both use
 tables, relationships, indexes and SQL. Yes they both have visual
 designers for forms and reports. Yes they both are programmable.

 But the differences are much more dramatic than the commonalities. I
 have developed in both. I find it painful to work in one while desiring
 a feature that exists only in the other.

Yes I agree (0ver 20 years with Fox/dBase) they are different.  I'd say Access 
provides several no thinking tools for the end user where VFP requires a 
little more effort.  But the concepts of both are very close.   The 
underlying code is also very different in that I find VFP 10 times easier 
when working with data.

That said, the question at hand is does Dabo make a good fit for the poster.  
I'd say without question the answer is yes.  Yes it is true that Dabo follows 
VFP more closely than Access.  But if the poster is moving from Access to a 
python solution does it matter?  The poster is making a change to a new 
language which is a major change.  At least Dabo keeps many of the concepts a 
Access user already understands. Therefore he/she will be more productive.

Johnf
___
Tutor maillist  -  Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor


Re: [Tutor] Help with choices for new database program

2010-07-03 Thread Jim Byrnes

Jeff Johnson wrote:

On 07/02/2010 11:40 AM, Chris C. wrote: I'm writing this question
because I want, for my own satisfaction, to rewrite one of my Access dbs
(one that does our finances) into a stand-alone Python database program
using SQLite. I know I'll be learning as I go, but that'll work, I'm not
in a big hurry and I'll work on it in my spare time. Right now I'm
trying to get organized and get a game plan, and that's where I need help.

I have been developing database applications for 20 years using FoxPro
and VFP. Now I am developing using Dabo. Dabo is a framework wrapper for
wxPython written totally in Python. I use SQLite for small applications
and PostgreSQL for larger ones. Dabo was written by two of the top
FoxPro developers and is supported by many others all over the world.

http://dabodev.com/

Please check it out. And go to www.leafe.com and subscribe to the
dabo-user email list.



I would like to try out Dabo, but I don't see it in the Ubuntu 
repositories and I would like to avoid using svn if I can.  I didn't 
subscribe to the mailing list but I did read the archives and saw a 
thread about making a deb package.  It seems to have ended in April 
without a clear resolution.


So is there a package available so I can use the Ubuntu package manager 
to install it?


Thanks,  Jim

___
Tutor maillist  -  Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor


Re: [Tutor] Help with choices for new database program

2010-07-03 Thread bob gailer

On 7/2/2010 9:44 PM, Jeff Johnson wrote:

On 07/02/2010 08:19 PM, bob gailer wrote:

On 7/2/2010 5:56 PM, Jeff Johnson wrote:

[snip]



Visual FoxPro ... is very similar to Access

I differ. Access and FoxPro are very different. Yes they both use 
tables, relationships, indexes and SQL. Yes they both have visual 
designers for forms and reports. Yes they both are programmable.


But the differences are much more dramatic than the commonalities. I 
have developed in both. I find it painful to work in one while 
desiring a feature that exists only in the other.



Dare you say which?   ;^)


FoxPro
- more complete and easy-to-use object orientation
  - classes don't need to be in separate modules
  - classes and controls can be subclassed
  - controls can be encapsulated in container classes
  - classes have constructor methods - so possible to pass parameters
- forms do not contain any magic events
- method editor is a simple text editor
  - no magic events
  - no separate application window for programming
- each table, database container, program, index is a separate file
- there is a command window and lots of interactively useful commands
  - I like being able to run SQL and data manipulation statements directly.
- error handling is much better
- there are no misleading or confusing error messages that result from 
compilation problems

- SQL is integrated into the language
- nice set of workarea commands (scan, replace, )
- writing programs in FoxPro much easier than in VBA
- no need to separate application from data (that is automatic).
- no confusion about when to use . vs !

Access:
- query and report designers are much much better
  - the VFP report designer is incredibly limited and hard to work with 
by comparison.

- debugger does not require separate window
- subforms
- recordset controls on forms
- table designer has more features
- there is no database container or need for one.
- relationships are integrated - visually created and available in query 
designer.


That is not an exhaustive list - and it is my opinion. I'd rather not 
get into any religious arguments - but I'd be glad to clarify.


--
Bob Gailer
919-636-4239
Chapel Hill NC

___
Tutor maillist  -  Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor


Re: [Tutor] Help with choices for new database program

2010-07-03 Thread Martin Walsh
On 07/03/2010 10:25 AM, Jim Byrnes wrote:
 Jeff Johnson wrote:

[snip]

 http://dabodev.com/

 Please check it out. And go to www.leafe.com and subscribe to the
 dabo-user email list.
 
 I would like to try out Dabo, but I don't see it in the Ubuntu
 repositories and I would like to avoid using svn if I can.  I didn't
 subscribe to the mailing list but I did read the archives and saw a
 thread about making a deb package.  It seems to have ended in April
 without a clear resolution.
 
 So is there a package available so I can use the Ubuntu package manager
 to install it?

Unfortunately, after poking around a bit it would seem the only reliable
way of installing dabo for Linux at the moment is checking out trunk
from the project's subversion repository. Someone better informed should
feel free to set the record straight, if I am mistaken.

If your interest in a deb package is mainly the ability to uninstall,
then I'd recommend using virtualenv[1] until a suitable deb package is
released. The steps would be roughly this (untested) ...

$ sudo apt-get install python-reportlab python-wxgtk2.8
$ sudo apt-get install subversion python-virtualenv
$ virtualenv daboenv
$ cd daboenv
$ source bin/activate # this is important
# now we install dabo as recommended, adapted from:
#   http://wiki.dabodev.com/InstallationOnLinux
(daboenv)$
(daboenv)$ mkdir src  cd src
(daboenv)$ svn co http://svn.dabodev.com/dabo/trunk dabo
(daboenv)$ cd dabo
(daboenv)$ python setup.py install # no sudo!
# and run the demo to verify the installation
(daboenv)$ demo/DaboDemo.py

...

Hmm, this might seem like a lot of work -- but by using this method,
dabo is installed under daboenv and not in the system-wide site-packages
-- particularly useful for evaluation, IMO. YMMV.

HTH,
Marty

[1] http://virtualenv.openplans.org/
___
Tutor maillist  -  Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor


Re: [Tutor] Help with choices for new database program

2010-07-02 Thread Jeff Johnson
On 07/02/2010 11:40 AM, Chris C. wrote: I'm writing this question 
because I want, for my own satisfaction, to rewrite one of my Access dbs 
(one that does our finances) into a stand-alone Python database program 
using SQLite.  I know I'll be learning as I go, but that'll work, I'm 
not in a big hurry and I'll work on it in my spare time.  Right now I'm 
trying to get organized and get a game plan, and that's where I need help.


I have been developing database applications for 20 years using FoxPro 
and VFP.  Now I am developing using Dabo.  Dabo is a framework wrapper 
for wxPython written totally in Python.  I use SQLite for small 
applications and PostgreSQL for larger ones.  Dabo was written by two of 
the top FoxPro developers and is supported by many others all over the 
world.


http://dabodev.com/

Please check it out.  And go to www.leafe.com and subscribe to the 
dabo-user email list.


--

Jeff

---

Jeff Johnson
j...@dcsoftware.com


___
Tutor maillist  -  Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor


Re: [Tutor] Help with choices for new database program

2010-07-02 Thread Alan Gauld


Chris C. filt...@gmail.com wrote

rewrite one of my Access dbs (one that does our finances) into a 
stand-alone
Python database program using SQLite.  I know I'll be learning as I 
go, but
that'll work, I'm not in a big hurry and I'll work on it in my spare 
time.


If its a database focused app I'd take a look at Dabo.
It has a GUI builder but also has links to database tables etc.

http://dabodev.com/

I've only played with it briefly (followed the tutorial) since I don't 
do much
database work in Python but it did look like a good tool for data 
centric

desktop GUI based apps.

HTH,


--
Alan Gauld
Author of the Learn to Program web site
http://www.alan-g.me.uk/


___
Tutor maillist  -  Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor


Re: [Tutor] Help with choices for new database program

2010-07-02 Thread Jeff Johnson

On 07/02/2010 05:35 PM, Chris C. wrote:


Hi Jeff, thank for your reply!  I'm aware of Dabo and was pretty much 
sold on using it until the last couple of days.  I was trying to 
install it so I could start connecting to my tables when I ran into a 
problem with the instructions for installing ReportLab.  I wrote to 
the mailing list Wednesday but haven't heard from anyone.  Being such 
a  beginner and knowing I'll be needing help, it kind of has me wary 
of committing to Dabo when I'm having this trouble getting help before 
I even get started.  I saw your post to the Dabo mailing list with the 
title Reference to bizjob control has been getting responses.  Can 
you confirm whether my question went out to the list recipients?  Did 
you receive it?


Like I was saying, I wanted to use Dabo, but I submitted this question 
to this board because I was beginning to lose faith in being able to 
get help from the Dabo mailing list.


Thanks again,

Chris C.

*From:* Jeff Johnson [mailto:j...@dcsoftware.com]
*Sent:* Friday, July 02, 2010 2:09 PM
*To:* Chris C.
*Subject:* Re: [Tutor] Help with choices for new database program

On 07/02/2010 11:40 AM, Chris C. wrote: I'm writing this question 
because I want, for my own satisfaction, to rewrite one of my Access 
dbs (one that does our finances) into a stand-alone Python database 
program using SQLite.  I know I'll be learning as I go, but that'll 
work, I'm not in a big hurry and I'll work on it in my spare time.  
Right now I'm trying to get organized and get a game plan, and that's 
where I need help.


I have been developing database applications for 20 years using FoxPro 
and VFP.  Now I am developing using Dabo.  Dabo is a framework wrapper 
for wxPython written totally in Python.  I use SQLite for small 
applications and PostgreSQL for larger ones.  Dabo was written by two 
of the top FoxPro developers and is supported by many others all over 
the world.


http://dabodev.com/

Please check it out.  And go to www.leafe.com http://www.leafe.com 
and subscribe to the dabo-user email list.


--

Jeff
  
---
  
Jeff Johnson

j...@dcsoftware.com  mailto:j...@dcsoftware.com
  


Chris:  The folks on the Dabo list are always available for answers.  Ed 
and Paul (Dabo's developers) are always quick to answer questions and I 
guarantee they respond quicker than most lists.  There are many others 
that develop commercial applications with Dabo that are always 
monitoring the list (just like me only more experienced with Dabo and 
Python).  If you are interested please subscribe to the list:


http://www.leafe.com/mailman/listinfo/dabo-users

I did not see your post on the list so no one else did either.  If you 
developed an app using Access than you are a perfect candidate for Dabo 
and you have at least enough understanding of what is going on to use it.


There are four things that need installing in order to use Dabo.  It may 
not go as smooth as a Windows Installshield application, but you can get 
plenty of help and once it is installed you can follow the great screen 
casts and tutorials.  The users of Dabo are developing applications for 
users.  Once you have your application developed there are ways to 
package it based on your platform.


You need Python, wxPython, Dabo, and Report Lab.  You can install PIL if 
you want to manipulate images.  If you need help, just ask!


Many of the people using Dabo are moving over from Visual FoxPro which 
is very similar to Access, so don't be afraid to ask any question.  If 
you ask a question the question and answer will be saved in the archives 
for others to learn.


Come on in, the water is fine!

--
Jeff

---

Jeff Johnson
j...@san-dc.com
(623) 582-0323

www.san-dc.com


--
Jeff

---

Jeff Johnson
j...@dcsoftware.com



___
Tutor maillist  -  Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor


Re: [Tutor] Help with choices for new database program

2010-07-02 Thread David Hutto
On Fri, Jul 2, 2010 at 8:56 PM, Jeff Johnson j...@dcsoftware.com wrote:
 On 07/02/2010 05:35 PM, Chris C. wrote:

 Hi Jeff, thank for your reply!  I’m aware of Dabo and was pretty much sold
 on using it until the last couple of days.  I was trying to install it so I
 could start connecting to my tables when I ran into a problem with the
 instructions for installing ReportLab.  I wrote to the mailing list
 Wednesday but haven’t heard from anyone.  Being such a  beginner and knowing
 I’ll be needing help, it kind of has me wary of committing to Dabo when I’m
 having this trouble getting help before I even get started.  I saw your post
 to the Dabo mailing list with the title “Reference to bizjob control” has
 been getting responses.  Can you confirm whether my question went out to the
 list recipients?  Did you receive it?

Stick to the main python libraries(python with sqllite, and for the
standalone exe know it's somewhere, and I've seen it in the past few
days, but didn't pay attention because it wasn't important to what I
was doing at the time) going anywhere else is the beginning of an ADHD
nightmare. It's like being a hypochondriac with an unlimited
healthcare plan, you'll want to see any option except for the obvious
in front of you.

Try not to get distracted by the shiny things unless necessary.




 Like I was saying, I wanted to use Dabo, but I submitted this question to
 this board because I was beginning to lose faith in being able to get help
 from the Dabo mailing list.



 Thanks again,

 Chris C.





 From: Jeff Johnson [mailto:j...@dcsoftware.com]
 Sent: Friday, July 02, 2010 2:09 PM
 To: Chris C.
 Subject: Re: [Tutor] Help with choices for new database program



 On 07/02/2010 11:40 AM, Chris C. wrote: I’m writing this question because I
 want, for my own satisfaction, to rewrite one of my Access dbs (one that
 does our finances) into a stand-alone Python database program using SQLite.
 I know I’ll be learning as I go, but that’ll work, I’m not in a big hurry
 and I’ll work on it in my spare time.  Right now I’m trying to get organized
 and get a game plan, and that’s where I need help.

 I have been developing database applications for 20 years using FoxPro and
 VFP.  Now I am developing using Dabo.  Dabo is a framework wrapper for
 wxPython written totally in Python.  I use SQLite for small applications and
 PostgreSQL for larger ones.  Dabo was written by two of the top FoxPro
 developers and is supported by many others all over the world.

 http://dabodev.com/

 Please check it out.  And go to www.leafe.com and subscribe to the dabo-user
 email list.

 --

 Jeff



 ---



 Jeff Johnson

 j...@dcsoftware.com



 Chris:  The folks on the Dabo list are always available for answers.  Ed and
 Paul (Dabo's developers) are always quick to answer questions and I
 guarantee they respond quicker than most lists.  There are many others that
 develop commercial applications with Dabo that are always monitoring the
 list (just like me only more experienced with Dabo and Python).  If you are
 interested please subscribe to the list:

 http://www.leafe.com/mailman/listinfo/dabo-users

 I did not see your post on the list so no one else did either.  If you
 developed an app using Access than you are a perfect candidate for Dabo and
 you have at least enough understanding of what is going on to use it.

 There are four things that need installing in order to use Dabo.  It may not
 go as smooth as a Windows Installshield application, but you can get plenty
 of help and once it is installed you can follow the great screen casts and
 tutorials.  The users of Dabo are developing applications for users.  Once
 you have your application developed there are ways to package it based on
 your platform.

 You need Python, wxPython, Dabo, and Report Lab.  You can install PIL if you
 want to manipulate images.  If you need help, just ask!

 Many of the people using Dabo are moving over from Visual FoxPro which is
 very similar to Access, so don't be afraid to ask any question.  If you ask
 a question the question and answer will be saved in the archives for others
 to learn.

 Come on in, the water is fine!

 --
 Jeff

 ---

 Jeff Johnson
 j...@san-dc.com
 (623) 582-0323

 www.san-dc.com

 --
 Jeff

 ---

 Jeff Johnson
 j...@dcsoftware.com



 ___
 Tutor maillist  -  tu...@python.org
 To unsubscribe or change subscription options:
 http://mail.python.org/mailman/listinfo/tutor


___
Tutor maillist  -  Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor


Re: [Tutor] Help with choices for new database program

2010-07-02 Thread Jeff Johnson

On 07/02/2010 06:14 PM, David Hutto wrote:


Stick to the main python libraries(python with sqllite, and for the
standalone exe know it's somewhere, and I've seen it in the past few
days, but didn't pay attention because it wasn't important to what I
was doing at the time) going anywhere else is the beginning of an ADHD
nightmare. It's like being a hypochondriac with an unlimited
healthcare plan, you'll want to see any option except for the obvious
in front of you.

Try not to get distracted by the shiny things unless necessary.


I'm not sure how this helps with Chris's application.  I will agree that 
the number of choices is daunting!  The nice thing about Dabo is the 
group is focused on database applications.  Kind of like Django is 
focused on web devopment.


I mean this in a joking way:  If you find that Python and open source 
creates too many decisions then you can consider Microsoft .NET and 
Microsoft SQL Server on Windows 7.


I am a recovering Microsoft developer of over 20 years.  ;^)

BTW learning Python is awesome!

--
Jeff

---

Jeff Johnson
j...@dcsoftware.com


___
Tutor maillist  -  Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor


Re: [Tutor] Help with choices for new database program

2010-07-02 Thread David Hutto
On Fri, Jul 2, 2010 at 9:27 PM, Jeff Johnson j...@san-dc.com wrote:
 On 07/02/2010 06:14 PM, David Hutto wrote:

 Stick to the main python libraries(python with sqllite, and for the
 standalone exe know it's somewhere, and I've seen it in the past few
 days, but didn't pay attention because it wasn't important to what I
 was doing at the time) going anywhere else is the beginning of an ADHD
 nightmare. It's like being a hypochondriac with an unlimited
 healthcare plan, you'll want to see any option except for the obvious
 in front of you.

 Try not to get distracted by the shiny things unless necessary.


 I'm not sure how this helps with Chris's application.  I will agree that the
 number of choices is daunting!  The nice thing about Dabo is the group is
 focused on database applications.  Kind of like Django is focused on web
 devopment.

Well, it was mainly that he said he was a beginner and was only using
this for a single banking project, I do believe.

Not that learning a new package would be helpful, I like
experimenting, and failing/succeeding, but if this is all he needs to
accomplish, then not using more than is necessary would be beneficial.
A simple script, with simple sqlite fields to maintain.


 I mean this in a joking way:  If you find that Python and open source
 creates too many decisions then you can consider Microsoft .NET and
 Microsoft SQL Server on Windows 7.

 I am a recovering Microsoft developer of over 20 years.  ;^)

 BTW learning Python is awesome!

 --

 Jeff

 ---

 Jeff Johnson
 j...@san-dc.com
 (623) 582-0323

 www.san-dc.com


___
Tutor maillist  -  Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor


Re: [Tutor] Help with choices for new database program

2010-07-02 Thread David Hutto
On Fri, Jul 2, 2010 at 9:31 PM, David Hutto smokefl...@gmail.com wrote:
 On Fri, Jul 2, 2010 at 9:27 PM, Jeff Johnson j...@san-dc.com wrote:
 On 07/02/2010 06:14 PM, David Hutto wrote:

 Stick to the main python libraries(python with sqllite, and for the
 standalone exe know it's somewhere, and I've seen it in the past few
 days, but didn't pay attention because it wasn't important to what I
 was doing at the time) going anywhere else is the beginning of an ADHD
 nightmare. It's like being a hypochondriac with an unlimited
 healthcare plan, you'll want to see any option except for the obvious
 in front of you.

 Try not to get distracted by the shiny things unless necessary.


 I'm not sure how this helps with Chris's application.  I will agree that the
 number of choices is daunting!  The nice thing about Dabo is the group is
 focused on database applications.  Kind of like Django is focused on web
 devopment.

 Well, it was mainly that he said he was a beginner and was only using
 this for a single banking project, I do believe.

 Not that learning a new package would

wouldn't


 be helpful, I like
 experimenting, and failing/succeeding, but if this is all he needs to
 accomplish, then not using more than is necessary would be beneficial.
 A simple script, with simple sqlite fields to maintain.


 I mean this in a joking way:  If you find that Python and open source
 creates too many decisions then you can consider Microsoft .NET and
 Microsoft SQL Server on Windows 7.

 I am a recovering Microsoft developer of over 20 years.  ;^)

 BTW learning Python is awesome!

 --

 Jeff

 ---

 Jeff Johnson
 j...@san-dc.com
 (623) 582-0323

 www.san-dc.com



___
Tutor maillist  -  Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor


Re: [Tutor] Help with choices for new database program

2010-07-02 Thread David Hutto
On Fri, Jul 2, 2010 at 9:44 PM, Jeff Johnson j...@san-dc.com wrote:
 On 07/02/2010 06:32 PM, David Hutto wrote:

 On Fri, Jul 2, 2010 at 9:31 PM, David Huttosmokefl...@gmail.com  wrote:


 Well, it was mainly that he said he was a beginner and was only using
 this for a single banking project, I do believe.

 Not that learning a new package would

 wouldn't


  be helpful, I like


 experimenting, and failing/succeeding, but if this is all he needs to
 accomplish, then not using more than is necessary would be beneficial.
 A simple script, with simple sqlite fields to maintain.



 David:  Experimenting, failing and succeeding is the life of a programmer.
  I have been programming for many years in assemply, FORTRAN, COBOL, Basic,
 RPG, FoxPro, C, but I am now totally committed to Python.  It is the best of
 all worlds.  Coming from the Microsoft side, open source and Python creates
 a whole new set of problems.  Do I use Windows?  Do I use Linux?  Do I use
 my Mac Book Pro?  You do have to make some decisions before moving on.  The
 choices are endless.

 I have found Dabo and Django to be beneficial for me because they target
 what I want to do.

 Your mileage may vary.  ;^)


In the end, there might be so many packages, I might not be able to
handle it all(for my own uses). But, I would think, you would agree
that a simple account balance app, would be no more than tkinter with
a few functions to write and retrieve data from a sqlite db. To quote
Sherlock, 'Sometimes, after eliminating the impossible, what ever is
left, no matter how improbable, must be the solution.', or something
like that.



 --
 Jeff

 ---

 Jeff Johnson
 j...@san-dc.com
 (623) 582-0323

 www.san-dc.com


___
Tutor maillist  -  Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor


Re: [Tutor] Help with choices for new database program

2010-07-02 Thread Jeff Johnson

On 07/02/2010 06:51 PM, David Hutto wrote:

In the end, there might be so many packages, I might not be able to
handle it all(for my own uses). But, I would think, you would agree
that a simple account balance app, would be no more than tkinter with
a few functions to write and retrieve data from a sqlite db. To quote
Sherlock, 'Sometimes, after eliminating the impossible, what ever is
left, no matter how improbable, must be the solution.', or something
like that.



David:  I like your quote!  I am a huge Sherlock Holmes fan.  I like 
Dabo because I develop commercial applications.


--
Jeff

---

Jeff Johnson
j...@dcsoftware.com


___
Tutor maillist  -  Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor


Re: [Tutor] Help with choices for new database program

2010-07-02 Thread David Hutto
On Fri, Jul 2, 2010 at 9:55 PM, Jeff Johnson j...@dcsoftware.com wrote:
 On 07/02/2010 06:51 PM, David Hutto wrote:

 In the end, there might be so many packages, I might not be able to
 handle it all(for my own uses). But, I would think, you would agree
 that a simple account balance app, would be no more than tkinter with
 a few functions to write and retrieve data from a sqlite db. To quote
 Sherlock, 'Sometimes, after eliminating the impossible, what ever is
 left, no matter how improbable, must be the solution.', or something
 like that.


 David:  I like your quote!  I am a huge Sherlock Holmes fan.  I like Dabo
 because I develop commercial applications.

'I love to develop relatively operational residential programs that
quasi-suit my own purpose', I said sarcastically. 'So hopefully I'll
join the commercial, then industrial one day', I said optimistically,
looking pessimistically up at the sky, while lazily, daydreaming
blurred images of the future.


 --
 Jeff

 ---

 Jeff Johnson
 j...@dcsoftware.com



___
Tutor maillist  -  Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor


Re: [Tutor] Help with choices for new database program

2010-07-02 Thread David Hutto
On Fri, Jul 2, 2010 at 10:01 PM, David Hutto smokefl...@gmail.com wrote:
 On Fri, Jul 2, 2010 at 9:55 PM, Jeff Johnson j...@dcsoftware.com wrote:
 On 07/02/2010 06:51 PM, David Hutto wrote:

 In the end, there might be so many packages, I might not be able to
 handle it all(for my own uses). But, I would think, you would agree
 that a simple account balance app, would be no more than tkinter with
 a few functions to write and retrieve data from a sqlite db. To quote
 Sherlock, 'Sometimes, after eliminating the impossible, what ever is
 left, no matter how improbable, must be the solution.', or something
 like that.


 David:  I like your quote!  I am a huge Sherlock Holmes fan.  I like Dabo
 because I develop commercial applications.

 'I love to develop relatively operational residential programs that
 quasi-suit my own purpose', I said sarcastically. 'So hopefully I'll
 join the commercial, then industrial one day', I said optimistically,
 looking pessimistically up at the sky, while lazily, daydreaming
 blurred images of the future.


 --
 Jeff

 ---

 Jeff Johnson
 j...@dcsoftware.com





But...maybe actually accessing the bank account url and logging in,
then checking, might be made easier by those you suggested. What would
be the ultimate intent of the developer of the app?
___
Tutor maillist  -  Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor


Re: [Tutor] Help with choices for new database program

2010-07-02 Thread David Hutto
On Fri, Jul 2, 2010 at 10:07 PM, David Hutto smokefl...@gmail.com wrote:
 On Fri, Jul 2, 2010 at 10:01 PM, David Hutto smokefl...@gmail.com wrote:
 On Fri, Jul 2, 2010 at 9:55 PM, Jeff Johnson j...@dcsoftware.com wrote:
 On 07/02/2010 06:51 PM, David Hutto wrote:

 In the end, there might be so many packages, I might not be able to
 handle it all(for my own uses). But, I would think, you would agree
 that a simple account balance app, would be no more than tkinter with
 a few functions to write and retrieve data from a sqlite db. To quote
 Sherlock, 'Sometimes, after eliminating the impossible, what ever is
 left, no matter how improbable, must be the solution.', or something
 like that.


 David:  I like your quote!  I am a huge Sherlock Holmes fan.  I like Dabo
 because I develop commercial applications.

 'I love to develop relatively operational residential programs that
 quasi-suit my own purpose', I said sarcastically. 'So hopefully I'll
 join the commercial, then industrial one day', I said optimistically,
 looking pessimistically up at the sky, while lazily, daydreaming
 blurred images of the future.


 --
 Jeff

 ---

 Jeff Johnson
 j...@dcsoftware.com





 But...maybe actually accessing the bank account url and logging in,
 then checking, might be made easier by those you suggested. What would
 be the ultimate intent of the developer of the app?

Or maybe more extensive, in detail documentation?

Sell me and the OP.
___
Tutor maillist  -  Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor


Re: [Tutor] Help with choices for new database program

2010-07-02 Thread David Hutto
On Fri, Jul 2, 2010 at 10:10 PM, David Hutto smokefl...@gmail.com wrote:
 On Fri, Jul 2, 2010 at 10:07 PM, David Hutto smokefl...@gmail.com wrote:
 On Fri, Jul 2, 2010 at 10:01 PM, David Hutto smokefl...@gmail.com wrote:
 On Fri, Jul 2, 2010 at 9:55 PM, Jeff Johnson j...@dcsoftware.com wrote:
 On 07/02/2010 06:51 PM, David Hutto wrote:

 In the end, there might be so many packages, I might not be able to
 handle it all(for my own uses). But, I would think, you would agree
 that a simple account balance app, would be no more than tkinter with
 a few functions to write and retrieve data from a sqlite db. To quote
 Sherlock, 'Sometimes, after eliminating the impossible, what ever is
 left, no matter how improbable, must be the solution.', or something
 like that.


 David:  I like your quote!  I am a huge Sherlock Holmes fan.  I like Dabo
 because I develop commercial applications.

 'I love to develop relatively operational residential programs that
 quasi-suit my own purpose', I said sarcastically. 'So hopefully I'll
 join the commercial, then industrial one day', I said optimistically,
 looking pessimistically up at the sky, while lazily, daydreaming
 blurred images of the future.


 --
 Jeff

 ---

 Jeff Johnson
 j...@dcsoftware.com





 But...maybe actually accessing the bank account url and logging in,
 then checking, might be made easier by those you suggested. What would
 be the ultimate intent of the developer of the app?

 Or maybe more extensive, in detail documentation?

 Sell me and the OP.


Actually do, because I have a payment transaction app I've been
thinking about(for personal development, not intentional business
use), that would incorporate something like that for interaction with
several banking accounts from several banks/financial institutions.
So, is there anything in there that would help me and the OP by
actually logging in to the site. And I can, newbie think, about
several ways, but haven't gotten to the specifics. But it does apply,
I think to the OP's question.
___
Tutor maillist  -  Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor


Re: [Tutor] Help with choices for new database program

2010-07-02 Thread bob gailer

On 7/2/2010 5:56 PM, Jeff Johnson wrote:

[snip]



Visual FoxPro ... is very similar to Access

I differ. Access and FoxPro are very different. Yes they both use 
tables, relationships, indexes and SQL. Yes they both have visual 
designers for forms and reports. Yes they both are programmable.


But the differences are much more dramatic than the commonalities. I 
have developed in both. I find it painful to work in one while desiring 
a feature that exists only in the other.


--
Bob Gailer
919-636-4239
Chapel Hill NC

___
Tutor maillist  -  Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor