Re: SQL statements
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 42546
interpreted = N
texte = Hi,On Wednesday, August 14, 2002, at 09:50 PM, Jason Tyler wrote:> I just recently spent way, way, way too much time fighting with a similar > setup. (you are running OS X right??)If you are asking me about OS X, I am running on RH Linux for my servers, and my test/development machine is Mac OS X.> > It was recommended by Simon Cotsworth to give up and buy MacODBC from > theKompany.com for $10. It installs easily, though a bit quirky and works > perfectly. I can send you a full copy of the steps.I will look into that, the steps would be very helpful. I will be taking vacation to do some major coding on my site, which requires the SQL stuff long before I will get my hands on 10.2 :(> Alternatively if you're running 10.2 (according to sites it's now shipping) > there is a built in ODBC manager based on iOdbc. Can anyone from > SmithMicro comment on support for this feature since 10.2 is now in public > hands? Hopefully for my machines at home I will be able to get 10.2 soon. But that still leaves the production server. I have heard many good things about PostgreSQL, and John's comments in the other reply to my message sound good.I use Webmin on most of my servers and the module for mysql has a nice execute sql feature (we made a backup here before uploading, the sql backup alone was 900 meg!). Unfortunately, there isn't such a feature in the webmin module for PostgreSQL. Does anyone know of any other tools for administering PostgreSQL on Linux? John mentioned one for NT.> > -Jason TylerThanks!> > On Wednesday, August 14, 2002, at 03:32 PM, dale's stuff wrote: > >> I am also getting ready to start dealing with a huge db in MySQL - can't >> get the darn unixodbc installed though :( >> >> I am considering trying out Pstgresql (spelling?) as the odbc stuff is >> already installed on my system for it. Has anyone had any experience >> using it over mysql with Webcat? >> >> In this case the DB is about 1.5 gig in size (including indexes) so not >> really practical for putting in a webcat db - that and it will probably >> only be accessed a few hundred times per day once the initial matching is >> done.[snip]Dale ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Hi,On Wednesday, August 14, 2002, at 09:50 PM, Jason Tyler wrote:> I just recently spent way, way, way too much time fighting with a similar > setup. (you are running OS X right??)If you are asking me about OS X, I am running on RH Linux for my servers, and my test/development machine is Mac OS X.> > It was recommended by Simon Cotsworth to give up and buy MacODBC from > theKompany.com for $10. It installs easily, though a bit quirky and works > perfectly. I can send you a full copy of the steps.I will look into that, the steps would be very helpful. I will be taking vacation to do some major coding on my site, which requires the SQL stuff long before I will get my hands on 10.2 :(> Alternatively if you're running 10.2 (according to sites it's now shipping) > there is a built in ODBC manager based on iODBC. Can anyone from > SmithMicro comment on support for this feature since 10.2 is now in public > hands? Hopefully for my machines at home I will be able to get 10.2 soon. But that still leaves the production server. I have heard many good things about PostgreSQL, and John's comments in the other reply to my message sound good.I use Webmin on most of my servers and the module for mysql has a nice execute sql feature (we made a backup here before uploading, the sql backup alone was 900 meg!). Unfortunately, there isn't such a feature in the webmin module for PostgreSQL. Does anyone know of any other tools for administering PostgreSQL on Linux? John mentioned one for NT.> > -Jason TylerThanks!> > On Wednesday, August 14, 2002, at 03:32 PM, dale's stuff wrote: > >> I am also getting ready to start dealing with a huge db in MySQL - can't >> get the darn unixODBC installed though :( >> >> I am considering trying out Pstgresql (spelling?) as the ODBC stuff is >> already installed on my system for it. Has anyone had any experience >> using it over mysql with Webcat? >> >> In this case the DB is about 1.5 gig in size (including indexes) so not >> really practical for putting in a webcat db - that and it will probably >> only be accessed a few hundred times per day once the initial matching is >> done.[snip]Dale ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
dale's stuff
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
not interpreting Q (2001)
[ShowNext] feature in 2.0 (1997)
[LINEITEMS] (2000)
Cancel Subscription (1996)
[WebDNA] Issue with [table] append and search from, ... (2016)
WebDNA Server Not Running (2005)
Re:2nd WebCatalog2 Feature Request (1996)
WebCatalog can't find database (1997)
WebCatalog (1998)
using showpage and showcart commands (1996)
triggers (2003)
Dates (1996)
HTML docs are wrong about listwords ... (2000)
TeaRoom Order fields email account remain empty even though thewy are filled. (1997)
Not really WebCat (1997)
Email problem.. (2004)
shownext problems & formvariables (1998)
Is this possible, WebCat2.0 and checkboxes (1997)
Return records from another (1997)
primer/tutorial question (2004)