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

Groups > comp.lang.python > #95401 > unrolled thread

Old DbaseV DOS Programmer wants to step over to new/actual modern program software

Back to article view | Back to comp.lang.python

Contents

  Old DbaseV DOS Programmer wants to step over to new/actual modern program software AGOSTINHO TEIXEIRA <agostinhoteixeira17@gmail.com> - 2015-08-16 09:40 -0700
    Re: Old DbaseV DOS Programmer wants to step over to new/actual modern program software Igor Korot <ikorot01@gmail.com> - 2015-08-16 12:54 -0400
    Re: Old DbaseV DOS Programmer wants to step over to new/actual modern program software Michael Torrie <torriem@gmail.com> - 2015-08-16 11:07 -0600
    Re: Old DbaseV DOS Programmer wants to step over to new/actual modern program software Rustom Mody <rustompmody@gmail.com> - 2015-08-16 10:11 -0700
      Re: Old DbaseV DOS Programmer wants to step over to new/actual modern program software Vladimir Ignatov <kmisoft@gmail.com> - 2015-08-16 14:40 -0400
      Re: Old DbaseV DOS Programmer wants to step over to new/actual modern program software "Adriaan Renting" <renting@astron.nl> - 2015-08-17 12:29 +0200

#95401 — Old DbaseV DOS Programmer wants to step over to new/actual modern program software

I'm a 25year DBASE-5 DOS programmer and want/have to step over to new program/platform software, because there is no future anymore for DOS after W-XP, I've been looking around for alternatives and cannot figure out where to start, I already have been learning the SQL with SSMS database system/script this is very important because I work mostly with large databases invoicing/stock/statements etc. I always manage my users with design-programs,windows-input,files-views, using custom made windows/input. I did all this in *.prg files with hard-coding. I have some ideas in mind like Java with (ECLIPS) because it is very popular, it is the most widely used and can get tutorials and videos all over the internet. I've read a lot of good things about Python, that it is much easier but too complicate to define what to choose, at the first place witch version 2.x or 3.x, a lot of IDE's to choose from, beside of that witch IDE with what pluggin. I'll need something suitable to manage/manipulate M-SQL. I have a lot of programs to rewrite and not much time, that's why it is very important to me to start with something appropriate with the best software combination that I can learn completely from the internet, cannot go back to the classroom, too old for that. I appreciate very much that any of you can help me to figure out to choose the right software combination for my new project. Thanks....!

[toc] | [next] | [standalone]

#95403

Hi,

On Sun, Aug 16, 2015 at 12:40 PM, AGOSTINHO TEIXEIRA
<agostinhoteixeira17@gmail.com> wrote:
> I'm a 25year DBASE-5 DOS programmer and want/have to step over to new program/platform software, because there is no future anymore for DOS after W-XP, I've been looking around for alternatives and cannot figure out where to start, I already have been learning the SQL with SSMS database system/script this is very important because I work mostly with large databases invoicing/stock/statements etc. I always manage my users with design-programs,windows-input,files-views, using custom made windows/input. I did all this in *.prg files with hard-coding. I have some ideas in mind like Java with (ECLIPS) because it is very popular, it is the most widely used and can get tutorials and videos all over the internet. I've read a lot of good things about Python, that it is much easier but too complicate to define what to choose, at the first place witch version 2.x or 3.x, a lot of IDE's to choose from, beside of that witch IDE with what pluggin. I'll need something suitable to manage/manipulate
>  M-SQL. I have a lot of programs to rewrite and not much time, that's why it is very important to me to start with something appropriate with the best software combination that I can learn completely from the internet, cannot go back to the classroom, too old for that. I appreciate very much that any of you can help me to figure out to choose the right software combination for my new project. Thanks....!

It really doesn't matter which language you choose for you
implementation. You will still need to learn it somehow and understand
how to operate with it and how to write a nice maintainable code with it.

I'd suggest to go to some local college and get some knowledge about
your language of the choice.

Perl/python might be better. because with them you will be able to
test you changes right away on the spot.
Also make sure that you DBMS does have a ODBC driver so you can
connect to the DB...

Thank you.
> --
> https://mail.python.org/mailman/listinfo/python-list

[toc] | [prev] | [next] | [standalone]

#95404

On 08/16/2015 10:40 AM, AGOSTINHO TEIXEIRA wrote:
> I'm a 25year DBASE-5 DOS programmer and want/have to step over to new
> program/platform software, because there is no future anymore for DOS
> after W-XP, I've been looking around for alternatives and cannot
> figure out where to start, I already have been learning the SQL with
> SSMS database system/script this is very important because I work
> mostly with large databases invoicing/stock/statements etc. I always
> manage my users with design-programs,windows-input,files-views, using
> custom made windows/input. I did all this in *.prg files with
> hard-coding. I have some ideas in mind like Java with (ECLIPS)
> because it is very popular, it is the most widely used and can get
> tutorials and videos all over the internet. I've read a lot of good
> things about Python, that it is much easier but too complicate to
> define what to choose, at the first place witch version 2.x or 3.x, a
> lot of IDE's to choose from, beside of that witch IDE with what
> pluggin. I'll need something suitable to manage/manipulate M-SQL. I
> have a lot of programs to rewrite and not much time, that's why it is
> very important to me to start with something appropriate with the
> best software combination that I can learn completely from the
> internet, cannot go back to the classroom, too old for that. I
> appreciate very much that any of you can help me to figure out to
> choose the right software combination for my new project.
> Thanks....!
> 

Here're a couple of interesting projects that I found on a google search
that might relate to what you're trying to do:

http://www.python-camelot.com/
http://kivy.org/

But like the other poster said, take some time to learn a new language,
such as Python.  Things can get complicated in a hurry, but if you have
a solid understanding of the language, it's doable.  Also it is helpful
if you have a good working knowledge of SQL.  SQL is useful when
interacting with a variety of database engines such as MS SQL, or a
freely available one like PostgreSQL.  Then there are dozens of
different database access libraries and abstractions you can choose from
such as SQLAlchemy.  And for creating a GUI there are several different
toolkits.

As for the future of DOS, existing DOS programs including your DBASE-5
apps should continue running indefinitely with the wonderful DOSBox
program: http://www.dosbox.com/.  While it's aimed at running games, it
runs business apps quite well.

[toc] | [prev] | [next] | [standalone]

#95405

On Sunday, August 16, 2015 at 10:10:18 PM UTC+5:30, AGOSTINHO TEIXEIRA wrote:
> I'm a 25year DBASE-5 DOS programmer and want/have to step over to new program/platform software, because there is no future anymore for DOS after W-XP, I've been looking around for alternatives and cannot figure out where to start, I already have been learning the SQL with SSMS database system/script this is very important because I work mostly with large databases invoicing/stock/statements etc. I always manage my users with design-programs,windows-input,files-views, using custom made windows/input. I did all this in *.prg files with hard-coding. I have some ideas in mind like Java with (ECLIPS) because it is very popular, it is the most widely used and can get tutorials and videos all over the internet. I've read a lot of good things about Python, that it is much easier but too complicate to define what to choose, at the first place witch version 2.x or 3.x, a lot of IDE's to choose from, beside of that witch IDE with what pluggin. I'll need something suitable to manage/manipulate M-SQL. I have a lot of programs to rewrite and not much time, that's why it is very important to me to start with something appropriate with the best software combination that I can learn completely from the internet, cannot go back to the classroom, too old for that. I appreciate very much that any of you can help me to figure out to choose the right software combination for my new project. Thanks....!

Questions
1.
Are you talking MSQL, MS-SQL? Quite different and also different from MySQL

2. How bound are you to your DBMS? If you are going to anyway port DBase-V
to a modern DBMS, you can as well choose a more python-friendly one --
one of postgres, MySql, Sqlite.

Anyways...
Assuming you are committed to MsSql, I'd suggest in sequence:
1. Forget about DBMS and study the python tutorial for a few days
2. Forget get about *your* DBMS and play around with Sqlite that runs out
of the box.  This will familiarize you with python's DBMS model
without the headaches of installing many pieces of softwares
3. Pick a python MsSql library and port your stuff to that

[toc] | [prev] | [next] | [standalone]

#95407

On Sun, Aug 16, 2015 at 1:11 PM, Rustom Mody <rustompmody@gmail.com> wrote:

>> I have some ideas in mind like Java with (ECLIPS) because it is very popular, it is the most widely used and can get tutorials and videos all over the internet.
>> I've read a lot of good things about Python, that it is much easier but too complicate to define what to choose,
>> at the first place witch version 2.x or 3.x, a lot of IDE's to choose from, beside of that witch IDE with what pluggin.

Hi,

I am using python for years but still curious about best IDE to suggest newbies.
IMHO - too many choices with no clear winner and each with its own flaws.
For me two crucial features are: good autocompletion and ability to
step over code in debugger.
I'd try Eclipse+PyDev first and then additionally check PyCharm ($$$)
for comparison (to see how "best free" compares to "good commercial")


Vladimir

https://itunes.apple.com/us/app/python-code-samples/id1025613117

[toc] | [prev] | [next] | [standalone]

#95429

For building new programs using free software, I currently like a mix
of Qt, Python, C++ and various open source SQL databases (MySQL,
PostGreSQL). I have found QtCreator an easy IDE to use in such cases, I
don't really like Eclipse.
But it requires a heavy knowledge of C++, which is not an easy
language, if you want to use Qt directly.
PyQt works for smaller projects, I've used it with
http://eric-ide.python-projects.org/ in the past.

A few things you need to ask yourself:
- How much time do I have?
- Who are my users, what OS/systems do they use? I like Qt because it
allows me to create programs for all kinds of operating systems.
- How do I want to distribute my software? Is it a problem if a user is
able to read the souce code?
- How well do I really know Dbase V? What do I want to do the same and
what differently? My dad worked with Dbase III/IV/V for years, but
learned how to program it by changing the autogenerated code, which is a
horrible way to learn programming and leads to very bad habbits.
- What kind of programs are you trying to make? There also exist a lot
of more specialized solutions, like http://www.4d.com/, which might suit
your needs, if you're looking for a dBase replacement.

Cheers



Adriaan Renting        | Email: renting@astron.nl
Software Engineer Radio Observatory
ASTRON                 | Phone: +31 521 595 100 (797 direct)
P.O. Box 2             | GSM:   +31 6 24 25 17 28
NL-7990 AA Dwingeloo   | FAX:   +31 521 595 101
The Netherlands        | Web: http://www.astron.nl/~renting/



>>> On 16-8-2015 at 20:40, Vladimir Ignatov <kmisoft@gmail.com> wrote:

> On Sun, Aug 16, 2015 at 1:11 PM, Rustom Mody <rustompmody@gmail.com>
wrote:
> 
>>> I have some ideas in mind like Java with (ECLIPS) because it is
very 
> popular, it is the most widely used and can get tutorials and videos
all over 
> the internet.
>>> I've read a lot of good things about Python, that it is much easier
but too 
> complicate to define what to choose,
>>> at the first place witch version 2.x or 3.x, a lot of IDE's to
choose from, 
> beside of that witch IDE with what pluggin.
> 
> Hi,
> 
> I am using python for years but still curious about best IDE to
suggest 
> newbies.
> IMHO - too many choices with no clear winner and each with its own
flaws.
> For me two crucial features are: good autocompletion and ability to
> step over code in debugger.
> I'd try Eclipse+PyDev first and then additionally check PyCharm
($$$)
> for comparison (to see how "best free" compares to "good
commercial")
> 
> 
> Vladimir
> 
> https://itunes.apple.com/us/app/python-code-samples/id1025613117

[toc] | [prev] | [standalone]

Back to top | Article view | comp.lang.python

csiph-web