Re: MySQL vs .NET
If you are using Perl, take a look at SOAP::Lite - do not let the name fool you... www.soaplite.com Combining this with Apache and mod_perl and given Perl can directly interface with MySQL using Perl's DBI (and also the countless other modules available on CPAN) we have found this to be a very robust solution for a distributed and/or multi-tier system. SOAP::Lite supports MS .Net clients using VB/VC++ since .Net is pretty much MS's spin on the SOAP protocol, but there are some quirks... There are other SOAP variants for other languages like Java, Python, etc... but not sure how these stack up... William IT wrote: I am using Delphi 7 and MySql 4.0.16, since MS release .Net technology and also Delphi 8 .Net to provide web services application, I want to know how to make a web services application using Mysql? Or is there similiar technology like .Net but using Mysql? -- Bill Hess Technology Resource Group -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Spatial Extensions in MySQL 4.1 - converting to SRID values...
I am new to the world of GIS and have an application where I would like to use MySQL's (found in 4.1 alpha currently) Spatial Extensions. I have a set of latitude and longitude for various locations and am trying to figure out how to convert to the SRID units. I have started going thru the tons of info on OpenGIS and other related map projection sites, but it currently seems overwhelming. Has anyone out there converted from lat/long to SRID units for point geometry type in MySQL?? If there are any sites or otherrefs for a beginning tutorial on GIS topics please forward. I have been looking at PROJ.4 lib for performing these conversions - Am I on the right track? -- Bill Hess -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Spatial Exts in MySQL - converting to SRID values...
I am new to the world of GIS and have an application where I would like to use MySQL's (found in 4.1 alpha currently) Spatial Extensions. I have a set of latitude and longitude for various locations and am trying to figure out how to convert to the SRID units. I have started going thru the tons of info on OpenGIS and other related map projection sites, but it currently seems overwhelming. Has anyone out there converted from lat/long to SRID units for point geometry type in MySQL?? If there are any sites or otherrefs for a beginning tutorial on GIS topics please forward. I have been looking at PROJ.4 lib for performing these conversions - I am on the right track? Thanks in advance... -- Bill Hess -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: AUTO_INCREMENT max value...
Nope - nothing close to 4GB or even 1GB... My greatest data file size is 80MB. The largest table is 1.7 million rows. I have databases with more and bigger files. I think my problem is that the table having the problem with auto increment is refreshed everyday (or even multiple times a day) by different automated programs running on various other machines. These updates run at different times and remove all of the records from the last run before repopulating the records. In most cases the largest value is pretty big so when a new recordis added the auto increment field just gets bigger and bigger since there is probably never a time where there are 0 records in the table. One would think that the value would not top out until 2^31 since I have it defined as a normal INT. I guess I can make it a BIGINT, but I think I will run into a problem eventually regardless how big I make the field... Ken Menzel wrote: But did you check if the file size is at 4Gig? This will cause strange things to happen, mysql does not gice a nice error for this condition. If the table was not created with MAX_ROWS option = to some real large number like 5000, then you could be running into a problem with the size of the MYD or MYI file. You can use the ALTER statement to add this option to the table. Hope this helps, Ken - Original Message - From: Bill Hess [EMAIL PROTECTED] To: Keith C. Ivey [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, October 08, 2002 4:52 PM Subject: Re: AUTO_INCREMENT max value... Not really getting errors but getting warnings when inserting records and having duplicate values since the primary key is the one that is auto incremented... Keith C. Ivey wrote: On 8 Oct 2002, at 12:23, Bill Hess wrote: What is the maximum value of an AUTO_INCREMENT field? I am currently running into a maximum value of 296,995,724 on Solaris 8 using MySQL 3.23.42 - the field has been defined as an INT(11), which should be able to handle a value bigger than what I am seeing - The DuBois MySQL book states it should handle 2^31 which turns out to be 2,147,483,648 What is the error message you're getting? Could it be that the problem is the actually size of your data file (over 4 GB?) rather than the value of the AUTO_INCREMENT? [Filter fodder: SQL] -- Bill Hess Technology Resource Group - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Bill Hess Technology Resource Group - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AUTO_INCREMENT max value...
Hello all... What is the maximum value of an AUTO_INCREMENT field? I am currently running into a maximum value of 296,995,724 on Solaris 8 using MySQL 3.23.42 - the field has been defined as an INT(11), which should be able to handle a value bigger than what I am seeing - The DuBois MySQL book states it should handle 2^31 which turns out to be 2,147,483,648 Is there another setting specifc for AUTO_INCREMENT? If I changed the field's datatype to BIGINT would I be able to achieve higher values? Does anyone out there have other techniques they use in place of AUTO_INCREMENT? Please include my direct email when repsonding - Thanks... -- Bill Hess Technology Resource Group - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: AUTO_INCREMENT max value...
Not really getting errors but getting warnings when inserting records and having duplicate values since the primary key is the one that is auto incremented... Keith C. Ivey wrote: On 8 Oct 2002, at 12:23, Bill Hess wrote: What is the maximum value of an AUTO_INCREMENT field? I am currently running into a maximum value of 296,995,724 on Solaris 8 using MySQL 3.23.42 - the field has been defined as an INT(11), which should be able to handle a value bigger than what I am seeing - The DuBois MySQL book states it should handle 2^31 which turns out to be 2,147,483,648 What is the error message you're getting? Could it be that the problem is the actually size of your data file (over 4 GB?) rather than the value of the AUTO_INCREMENT? [Filter fodder: SQL] -- Bill Hess Technology Resource Group - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php