<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
        {font-family:"Cambria Math";
        panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0in;
        margin-bottom:.0001pt;
        font-size:11.0pt;
        font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:purple;
        text-decoration:underline;}
span.EmailStyle17
        {mso-style-type:personal-compose;
        font-family:"Calibri","sans-serif";
        color:windowtext;}
.MsoChpDefault
        {mso-style-type:export-only;}
@page WordSection1
        {size:8.5in 11.0in;
        margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
        {page:WordSection1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=WordSection1>
<p class=MsoNormal>Hi,<o:p></o:p></p>
<p class=MsoNormal>I’m not a programmer, but I have been exposed to some
programming basics. I’ve written small parts of console-based C++ programs
in an OOP class I took last year (but nothing outside of the classroom setting),
and on my own I’ve written some semi-simple multi-form multi-report
databases in Access, including the event-based VBA behind the scenes in those
dbs.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>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. <o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>I need to ask experienced people to help me make decisions
on what tools I should use. As I said, I’m pretty set on Python and
Sqlite. I believe I want to use an ORM so I’m thinking I’ll
use SQL Alchemy (it seems to be the biggy out there, and I’m sure I will
need lots of documentation, and forum help too). I’ve read that
Eclipse with PyDev is a good IDE, so I thought I’d use them. I’ve
also read that wxGlade will help me easily design a gui (drag and drop style),
and that it will generate the code for my UI so that I just have to bind to it
with my business logic code. How should I do my reports? I like
Access’s report style (since they are formatted already for printing),
but I’m open to other styles too. <o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Am I understanding what these things are and what they do?
If not, can you help me understand how all these pieces fit together and what
function they each have toward writing my program?<o:p></o:p></p>
<p class=MsoNormal>What else will I need?<o:p></o:p></p>
<p class=MsoNormal>What products (free ones please) can you recommend for me to
use?<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>(Ease of learning and speed to a finished program are what I’m
mainly looking for. I’m really only looking to learn the skills I
need for this particular project, and not to gain a broad development skill
set. My professional field is not computer related and this project only
for my personal satisfaction.)<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Sorry this message was so long. Thanks one and all for
your help!<o:p></o:p></p>
</div>
</body>
</html>