Please turn the html off. --- Regarding suitable database - for 2 - 3 K recs I cant see the value in advertising FP quite so aggressively. On a static population of this size the pickle and shelve libraries are just as flexible, and possibly just a little faster (i've done no tests on this, but if anyone wants to take this on.....). ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 05, 2002 8:03 PM Subject: ActivePython digest, Vol 1 #427 - 6 msgs
> Send ActivePython mailing list submissions to > [EMAIL PROTECTED] > > To subscribe or unsubscribe via the World Wide Web, visit > http://listserv.ActiveState.com/mailman/listinfo/activepython > or, via email, send a message with subject or body 'help' to > [EMAIL PROTECTED] > > You can reach the person managing the list at > [EMAIL PROTECTED] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of ActivePython digest..." > > > Today's Topics: > > 1. What database should I use (A) > 2. RE: What database should I use (Ganz, Will) > 3. RE: What database should I use (Sathish Chandrasekaran (S)) > 4. RE: What database should I use (Ron Darling) > 5. RE: What database should I use (Ganz, Will) > 6. Having problems with PPM (Octavio Jose de Franca Lima (EWU)) > > --__--__-- > > Message: 1 > From: "A" <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED], [EMAIL PROTECTED], > [EMAIL PROTECTED], [EMAIL PROTECTED] > Date: Thu, 05 Sep 2002 15:20:31 +0200 > Subject: What database should I use > Reply-to: [EMAIL PROTECTED] > CC: [EMAIL PROTECTED], [EMAIL PROTECTED] > > Hello, > I am going to program a small application (in Python and wxPython) which consists about > 2000 - 3000 records . Can you please recommend which database is the best for that. I > use Windows. > Maybe MS Access or FoxPro or MySQL or better? > I want to keep the program as small as possible. > Thanks > Ladislav > > > --__--__-- > > Message: 2 > From: "Ganz, Will" <[EMAIL PROTECTED]> > To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>, > [EMAIL PROTECTED] > Subject: RE: What database should I use > Date: Thu, 5 Sep 2002 08:45:53 -0500 > > Another consideration besides the number of records is how complex is your > data. If the application doesn't need to have relational capablities and > size is of the essence, then take a look at the pickle or shelve modules. > This may serve your needs. > > If relational capabilities are required and MS Access is already installed, > then it would be OK from my experience with a small(100K records max) > database with up to 2 users connected simultaneously. Beyond that, goto > MySQL. > > I cannot stress enough, before coding; always ALWAYS define your data > structures FIRST. Been there, done that, got the scars to prove it. > > Your mileage may vary, > > Will > > -----Original Message----- > From: A [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 05, 2002 8:21 AM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; > [EMAIL PROTECTED]; [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: What database should I use > > > Hello, > I am going to program a small application (in Python and wxPython) which > consists about > 2000 - 3000 records . Can you please recommend which database is the best > for that. I > use Windows. > Maybe MS Access or FoxPro or MySQL or better? > I want to keep the program as small as possible. > Thanks > Ladislav > > _______________________________________________ > ActivePython mailing list > [EMAIL PROTECTED] > To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs > Other options: http://listserv.ActiveState.com/mailman/listinfo/ActivePython > > --__--__-- > > Message: 3 > Subject: RE: What database should I use > Date: Thu, 5 Sep 2002 16:24:08 +0200 > From: "Sathish Chandrasekaran \(S\)" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>, > <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> > > In that case MS-access will be better on the size issue. But on the > other hand if u want ur application to be flexible and ease of use I > would rather suggest FoxPro (though it's it considered obsolete > now-a-days). > > > Here Is A Test To Know Whether The Mission Of Your Life Is Over . > If You Are Alive It Isn't . > > Sathish C > Infra-Amdocs=20 > > > -----Original Message----- > From: A [mailto:[EMAIL PROTECTED]] > Sent: 05 September 2002 15:21 > To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; > [EMAIL PROTECTED]; [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: What database should I use > > > Hello, > I am going to program a small application (in Python and wxPython) > which consists about=20 > 2000 - 3000 records . Can you please recommend which database is the > best for that. I=20 > use Windows. > Maybe MS Access or FoxPro or MySQL or better? > I want to keep the program as small as possible. > Thanks > Ladislav > > _______________________________________________ > ActivePython mailing list > [EMAIL PROTECTED] > To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs > Other options: > http://listserv.ActiveState.com/mailman/listinfo/ActivePython > > > --__--__-- > > Message: 4 > From: "Ron Darling" <[EMAIL PROTECTED]> > To: "Sathish Chandrasekaran \(S\)" <[EMAIL PROTECTED]>, > <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>, > <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> > Subject: RE: What database should I use > Date: Thu, 5 Sep 2002 10:30:11 -0500 > > >> (though it's it considered obsolete now-a-days). > > This is only a consideration for the uni-formed or those that have never > really used it. MS is still dumping lots of money into it. Just shipped > v7.0 will be going into Beta with 8.0 in a couple of months. > > Amazing String capabilties. As a matter of fact there is now a VFP style > .net class that moves a lot of the wonderful commands internal to VFP to > .NET. I think the Fox Dev team created. > > Cursor Technology, Rushmore Speed and many other things have moved there way > into not only Access but SQL Server and ADO. > > Due to the fact that each part of a table is its own file. .DBF is the > table. .FPT is the Memo field .CDX is the index. The file size limitation > of the OS of 2 gig is at the individual file level. In Access everything is > stored in the same file (you could break up but not really meant to) so the > 2 gig file size is limited to the app and data which is more than likely in > the same file. I have dealt with lots of situations where the .DBF was 1.8 > gig, the index was 1.2 gig and the FPT was another 1+ gig size. > > Indexes are stored in a .CDX file. A .CDX file can have as many as 255 > indexes (take into account 2 gig file size). Each open table can have 10 > open CDX's so you can have 2550 indexes on a table. > > Very Robust SQL pass Through for back end databases. > > There is nothing out there as fast as VFP for pure raw speed. SQL 2000 gets > close but not quite there, the advantage to SQL as far speed goes is it does > not bog down under load. Load means 25 + heavy users. > > As far as speed goes I have seen the return of queries on tables as large as > 21 million records within seconds and that was pulling data across a 10 meg > network with Foxpro For DOS. United We Stand (remember Ross Perot) > member/prospect database. Sounds a little dated but the point is its been > that way in Fox for a long time. > > Fox and VFP managed/tracked the military assets to the Persian Gulf and is > till in use. > Manages the flow of info for Chunnel. > It is far more prevalent than most realize. > > Very good OOP. It seems that VFP is becoming known for the best language > that can really implement the "Abstract Factory Pattern" > > Very good interface. Rich Native Controls (No OCX) and does very well with > OCX's. > > Easy Distribution. (Drop a couple of DLLS into system directory not reg) > > Rich Debugger. > > Can access any data ODBC, ADO or ADO.Net can access. > > Internal XML. Select Result set from SQL into a local cursor then use > CURSORTOXML(). With the XMLTOCCURSOR() and > CURSORTOXML() commands it is very easy to build thin wire apps. Bind the > interface to the cursor. > > I can try any and all commands from the command prompt and even from within > a debugging suspend. Pretty much interrogate the entire system at hand very > easily from a suspend. > > Many options for hanging VFP behind IIS and ISAPI. > > You can create com objects and run behind other languages even from within > SQL Server or visa versa. > > One of the most robust SOUNDEX/Fuzzy Search add-ons available with the > PHDbase Library. You can index memo fields and do 2 - 3 second searches on > huge amounts of memo data. > > Best Table Repair Libraries that I am aware of are available. > > Error trapping has been far superior to VB and a lot of languages since the > Fox 2.0 days (1992). > > Last but not least http://www.universalthread.com. Great support from all > over the world. > > > obsolete...hmmmmm maybe lack of exposure or conflicting marketing problems > with MS owning Access, SQL and Fox but certainly not obsolete. > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Sathish > Chandrasekaran (S) > Sent: Thursday, September 05, 2002 9:24 AM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; > [EMAIL PROTECTED]; [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: RE: What database should I use > > > In that case MS-access will be better on the size issue. But on the > other hand if u want ur application to be flexible and ease of use I > would rather suggest FoxPro (though it's it considered obsolete > now-a-days). > > > Here Is A Test To Know Whether The Mission Of Your Life Is Over . > If You Are Alive It Isn't . > > Sathish C > Infra-Amdocs > > > -----Original Message----- > From: A [mailto:[EMAIL PROTECTED]] > Sent: 05 September 2002 15:21 > To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; > [EMAIL PROTECTED]; [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: What database should I use > > > Hello, > I am going to program a small application (in Python and wxPython) > which consists about > 2000 - 3000 records . Can you please recommend which database is the > best for that. I > use Windows. > Maybe MS Access or FoxPro or MySQL or better? > I want to keep the program as small as possible. > Thanks > Ladislav > > _______________________________________________ > ActivePython mailing list > [EMAIL PROTECTED] > To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs > Other options: > http://listserv.ActiveState.com/mailman/listinfo/ActivePython > > _______________________________________________ > ActivePython mailing list > [EMAIL PROTECTED] > To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs > Other options: http://listserv.ActiveState.com/mailman/listinfo/ActivePython > > > > --__--__-- > > Message: 5 > From: "Ganz, Will" <[EMAIL PROTECTED]> > To: "'Ron Darling'" <[EMAIL PROTECTED]>, > "Sathish Chandrasekaran \(S\)" <[EMAIL PROTECTED]>, [EMAIL PROTECTED], > [EMAIL PROTECTED], [EMAIL PROTECTED], > [EMAIL PROTECTED], [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED], [EMAIL PROTECTED] > Subject: RE: What database should I use > Date: Thu, 5 Sep 2002 11:17:39 -0500 > > I grant that FoxPro is still a formidable competitor in the marketplace but > given the size that the original poster stated of 2K-3k records; the 2gig > Access limitation shouldn't come into play. In this instance, Visual FoxPro > would be like using a supersonic fighter jet as a crop duster. 8-) > > -----Original Message----- > From: Ron Darling [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 05, 2002 10:30 AM > To: Sathish Chandrasekaran (S); [EMAIL PROTECTED]; [EMAIL PROTECTED]; > [EMAIL PROTECTED]; [EMAIL PROTECTED]; > [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: RE: What database should I use > > > >> (though it's it considered obsolete now-a-days). > > This is only a consideration for the uni-formed or those that have never > really used it. MS is still dumping lots of money into it. Just shipped > v7.0 will be going into Beta with 8.0 in a couple of months. > > Amazing String capabilties. As a matter of fact there is now a VFP style > .net class that moves a lot of the wonderful commands internal to VFP to > .NET. I think the Fox Dev team created. > > Cursor Technology, Rushmore Speed and many other things have moved there way > into not only Access but SQL Server and ADO. > > Due to the fact that each part of a table is its own file. .DBF is the > table. .FPT is the Memo field .CDX is the index. The file size limitation > of the OS of 2 gig is at the individual file level. In Access everything is > stored in the same file (you could break up but not really meant to) so the > 2 gig file size is limited to the app and data which is more than likely in > the same file. I have dealt with lots of situations where the .DBF was 1.8 > gig, the index was 1.2 gig and the FPT was another 1+ gig size. > > Indexes are stored in a .CDX file. A .CDX file can have as many as 255 > indexes (take into account 2 gig file size). Each open table can have 10 > open CDX's so you can have 2550 indexes on a table. > > Very Robust SQL pass Through for back end databases. > > There is nothing out there as fast as VFP for pure raw speed. SQL 2000 gets > close but not quite there, the advantage to SQL as far speed goes is it does > not bog down under load. Load means 25 + heavy users. > > As far as speed goes I have seen the return of queries on tables as large as > 21 million records within seconds and that was pulling data across a 10 meg > network with Foxpro For DOS. United We Stand (remember Ross Perot) > member/prospect database. Sounds a little dated but the point is its been > that way in Fox for a long time. > > Fox and VFP managed/tracked the military assets to the Persian Gulf and is > till in use. Manages the flow of info for Chunnel. It is far more prevalent > than most realize. > > Very good OOP. It seems that VFP is becoming known for the best language > that can really implement the "Abstract Factory Pattern" > > Very good interface. Rich Native Controls (No OCX) and does very well with > OCX's. > > Easy Distribution. (Drop a couple of DLLS into system directory not reg) > > Rich Debugger. > > Can access any data ODBC, ADO or ADO.Net can access. > > Internal XML. Select Result set from SQL into a local cursor then use > CURSORTOXML(). With the XMLTOCCURSOR() and > CURSORTOXML() commands it is very easy to build thin wire apps. Bind the > interface to the cursor. > > I can try any and all commands from the command prompt and even from within > a debugging suspend. Pretty much interrogate the entire system at hand very > easily from a suspend. > > Many options for hanging VFP behind IIS and ISAPI. > > You can create com objects and run behind other languages even from within > SQL Server or visa versa. > > One of the most robust SOUNDEX/Fuzzy Search add-ons available with the > PHDbase Library. You can index memo fields and do 2 - 3 second searches on > huge amounts of memo data. > > Best Table Repair Libraries that I am aware of are available. > > Error trapping has been far superior to VB and a lot of languages since the > Fox 2.0 days (1992). > > Last but not least http://www.universalthread.com. Great support from all > over the world. > > > obsolete...hmmmmm maybe lack of exposure or conflicting marketing problems > with MS owning Access, SQL and Fox but certainly not obsolete. > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Sathish > Chandrasekaran (S) > Sent: Thursday, September 05, 2002 9:24 AM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; > [EMAIL PROTECTED]; [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: RE: What database should I use > > > In that case MS-access will be better on the size issue. But on the other > hand if u want ur application to be flexible and ease of use I would rather > suggest FoxPro (though it's it considered obsolete now-a-days). > > > Here Is A Test To Know Whether The Mission Of Your Life Is Over . If You Are > Alive It Isn't . > > Sathish C > Infra-Amdocs > > > -----Original Message----- > From: A [mailto:[EMAIL PROTECTED]] > Sent: 05 September 2002 15:21 > To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; > [EMAIL PROTECTED]; [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: What database should I use > > > Hello, > I am going to program a small application (in Python and wxPython) which > consists about 2000 - 3000 records . Can you please recommend which database > is the best for that. I use Windows. Maybe MS Access or FoxPro or MySQL or > better? I want to keep the program as small as possible. Thanks Ladislav > > _______________________________________________ > ActivePython mailing list > [EMAIL PROTECTED] > To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs > Other options: http://listserv.ActiveState.com/mailman/listinfo/ActivePython > > _______________________________________________ > ActivePython mailing list > [EMAIL PROTECTED] > To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs > Other options: http://listserv.ActiveState.com/mailman/listinfo/ActivePython > > > _______________________________________________ > ActivePython mailing list > [EMAIL PROTECTED] > To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs > Other options: http://listserv.ActiveState.com/mailman/listinfo/ActivePython > > --__--__-- > > Message: 6 > From: "Octavio Jose de Franca Lima \(EWU\)" <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: Having problems with PPM > Date: Thu, 5 Sep 2002 11:25:30 -0500 > > This message is in MIME format. Since your mail reader does not understand > this format, some or all of this message may not be legible. > > ------_=_NextPart_001_01C254F8.D9E5DB1C > Content-Type: text/plain; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > > I used to have NT 4.0 on my machine and Python 2.1. PPM used to work = > fine behind our firewall. I recently got upgraded to Win2000 and also = > decided to upgrade to Python 2.2 but now I cannot get the thing to run. = > Whenever I start pyppm.bat I get the following: > > " > > The system cannot find the path specified. > PPM>search > > searching ActiveState Package Repository repository -- URL=3D = > http://www.ActiveState.com/cgibin/PyPPM/2.2+/pyppmserver.pl > The system cannot find the path specified. > PPM>exit > > " > > Any ideas? > > > -- > > Oct=E1vio Jos=E9 de Fran=E7a Lima > <[EMAIL PROTECTED]> > > > > ------_=_NextPart_001_01C254F8.D9E5DB1C > Content-Type: text/html; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> > <HTML> > <HEAD> > <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = > charset=3Diso-8859-1"> > <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = > 5.5.2655.35"> > <TITLE>Having problems with PPM</TITLE> > </HEAD> > <BODY> > <BR> > > <P><FONT SIZE=3D2 FACE=3D"Arial">I used to have NT 4.0 on my machine = > and Python 2.1. PPM used to work fine behind our firewall. I recently = > got upgraded to Win2000 and also decided to upgrade to Python 2.2 but = > now I cannot get the thing to run. Whenever I start pyppm.bat I get the = > following:</FONT></P> > > <P><FONT SIZE=3D2 FACE=3D"Arial">"</FONT> > </P> > > <P><FONT SIZE=3D2 FACE=3D"Arial">The system cannot find the path = > specified.</FONT> > <BR><FONT SIZE=3D2 FACE=3D"Arial">PPM>search</FONT> > </P> > > <P><FONT SIZE=3D2 FACE=3D"Arial">searching ActiveState Package = > Repository repository -- URL=3D <A = > HREF=3D"http://www.ActiveState.com/cgibin/PyPPM/2.2+/pyppmserver.pl"; = > TARGET=3D"_blank">http://www.ActiveState.com/cgibin/PyPPM/2.2+/pyppmserv= > er.pl</A></FONT> > <BR><FONT SIZE=3D2 FACE=3D"Arial">The system cannot find the path = > specified.</FONT> > <BR><FONT SIZE=3D2 FACE=3D"Arial">PPM>exit</FONT> > </P> > > <P><FONT SIZE=3D2 FACE=3D"Arial">"</FONT> > </P> > > <P><FONT SIZE=3D2 FACE=3D"Arial">Any ideas?</FONT> > </P> > <BR> > > <P><FONT SIZE=3D2 FACE=3D"Arial">--</FONT> > </P> > > <P><B><FONT SIZE=3D2 FACE=3D"Arial">Oct=E1vio Jos=E9 de Fran=E7a = > Lima</FONT></B> > <BR><FONT SIZE=3D2 FACE=3D"Arial"><[EMAIL PROTECTED]></FONT> > </P> > <BR> > > </BODY> > </HTML> > ------_=_NextPart_001_01C254F8.D9E5DB1C-- > > > --__--__-- > > _______________________________________________ > ActivePython mailing list > [EMAIL PROTECTED] > To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs > > > End of ActivePython Digest > > _______________________________________________ ActivePython mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs Other options: http://listserv.ActiveState.com/mailman/listinfo/ActivePython
