This week a Windows C/C# guru was showing me an SMS corporate app he has developed. Anyway, he has built it to run on MySQL. So this article linked below may ring quite true to some of you out there! http://dev.mysql.com/tech-resources/articles/move_from_microsoft_SQL_Server....
Interesting article. I've come to find that articles praising one vendor's products over another's wiritten by the vendor are best taken with a pinch of salt. I read Oracle comparisons by Oracle, SQL Server comparisons by Microsoft and DB2 comparisons by IBM skeptically. Not to say that they lie, but they are written in such a way to make the competition look less appealing. Selecting a database for production useI would imagine is best done on a case by case basis depending on several factors (cost, support, skill set, features, operating system, problem domain etc) which would mean for different scenarios you'd end up with different databases. On Tue, Jun 9, 2009 at 9:31 PM, Murigi Muraya <mmskunkworks@gmail.com>wrote:
This week a Windows C/C# guru was showing me an SMS corporate app he has developed. Anyway, he has built it to run on MySQL. So this article linked below may ring quite true to some of you out there!
http://dev.mysql.com/tech-resources/articles/move_from_microsoft_SQL_Server....
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
The article aside, I have used for several years SQL-Server, Oracle, Postgres and Mysql. When presented with the same optimal level of load, hardware and platform, SQL-Server sucks in comparison. There are very few positive things that I can say about sql-server in COMPARISON with other DB platforms other than the fact that they have a huge marketing budget and effective sales network! On Wed, Jun 10, 2009 at 9:50 AM, Rad! <conradakunga@gmail.com> wrote:
Interesting article. I've come to find that articles praising one vendor's products over another's wiritten by the vendor are best taken with a pinch of salt. I read Oracle comparisons by Oracle, SQL Server comparisons by Microsoft and DB2 comparisons by IBM skeptically. Not to say that they lie, but they are written in such a way to make the competition look less appealing.
Selecting a database for production useI would imagine is best done on a case by case basis depending on several factors (cost, support, skill set, features, operating system, problem domain etc) which would mean for different scenarios you'd end up with different databases.
On Tue, Jun 9, 2009 at 9:31 PM, Murigi Muraya <mmskunkworks@gmail.com>wrote:
This week a Windows C/C# guru was showing me an SMS corporate app he has developed. Anyway, he has built it to run on MySQL. So this article linked below may ring quite true to some of you out there!
http://dev.mysql.com/tech-resources/articles/move_from_microsoft_SQL_Server....
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
Well, that is entirely subjective. I too have used a variety of RDMBS systems, and for the solutions I used SQL Server I am very happy with the performance. Whereas you are unable to find positive things I can find several. For instance 1. 3 replication techniques 2. Dedicated date and time data types (fantastic for reporting and data warehousing) 3. Timezone aware datetime type 4. Geospatial type 5. Embedded .NET runtime, allowing procedures and functions to be written in .NET as well as allowing use of 3rd party DLLs. A godsend for situations where SQL is very poor like regular expressions 6. Integration services for ETL tasks 7. Business Intelligence 8. Data warehousing 9. Structured error handling in T-SQL (try-catch-finally) 10. Transparent data encryption 11. etc Depending on your ability to make use said features, your mileage may vary On Wed, Jun 10, 2009 at 5:59 PM, Moses <mosenetk@gmail.com> wrote:
The article aside, I have used for several years SQL-Server, Oracle, Postgres and Mysql. When presented with the same optimal level of load, hardware and platform, SQL-Server sucks in comparison. There are very few positive things that I can say about sql-server in COMPARISON with other DB platforms other than the fact that they have a huge marketing budget and effective sales network!
On Wed, Jun 10, 2009 at 9:50 AM, Rad! <conradakunga@gmail.com> wrote:
Interesting article. I've come to find that articles praising one vendor's products over another's wiritten by the vendor are best taken with a pinch of salt. I read Oracle comparisons by Oracle, SQL Server comparisons by Microsoft and DB2 comparisons by IBM skeptically. Not to say that they lie, but they are written in such a way to make the competition look less appealing.
Selecting a database for production useI would imagine is best done on a case by case basis depending on several factors (cost, support, skill set, features, operating system, problem domain etc) which would mean for different scenarios you'd end up with different databases.
On Tue, Jun 9, 2009 at 9:31 PM, Murigi Muraya <mmskunkworks@gmail.com>wrote:
This week a Windows C/C# guru was showing me an SMS corporate app he has developed. Anyway, he has built it to run on MySQL. So this article linked below may ring quite true to some of you out there!
http://dev.mysql.com/tech-resources/articles/move_from_microsoft_SQL_Server....
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
I was going to put my foot down on this until i read this line "Depending on your ability to make use said features, your mileage may vary" There two things every developer should look at when features are listed in a Software Product. 1. Are those features really practical and applicable in ones use case - its like telling me your car can move at 300 mph and drag and elephant accros sahara on a gallon of gas - when am i ever going to get an opportunity to do that? 2. Do those features actually work as well as supposedly stated by the vendor. I this case when i say work i really mean something like this... am i gonna be able to replicate one terrabyte of data halfway accross earth and it takes me 36hrs especiall if am using one of SQLservers relication such as snap shot. might as well do an SQL dump of the data and fedex it to the remote location and have it imported back in. nuff said. Now in many cases without going into details, SQL Server (in general) has come short of expectations. Just a quick comment. Packing features into a product causes it t become bloated and thats why we have what we call plugins. A good product has all the necessary stuff one needs and the addition candy supplied as a pluggin. Now with RDMS like MYSQL it has been deliberately stripped off some of the features to make it as robust as it is today... Wait. here's the catch. some of the features have also simply been moved into various storage engines so the developer has the ability to choose what engne and features they need. I'll stop there Steve Obbayi, _____ From: skunkworks-bounces@lists.my.co.ke [mailto:skunkworks-bounces@lists.my.co.ke] On Behalf Of Rad! Sent: Wednesday, June 10, 2009 6:11 PM To: Skunkworks forum Subject: Re: [Skunkworks] MySQL on Windows Well, that is entirely subjective. I too have used a variety of RDMBS systems, and for the solutions I used SQL Server I am very happy with the performance. Whereas you are unable to find positive things I can find several. For instance 1. 3 replication techniques 2. Dedicated date and time data types (fantastic for reporting and data warehousing) 3. Timezone aware datetime type 4. Geospatial type 5. Embedded .NET runtime, allowing procedures and functions to be written in .NET as well as allowing use of 3rd party DLLs. A godsend for situations where SQL is very poor like regular expressions 6. Integration services for ETL tasks 7. Business Intelligence 8. Data warehousing 9. Structured error handling in T-SQL (try-catch-finally) 10. Transparent data encryption 11. etc Depending on your ability to make use said features, your mileage may vary On Wed, Jun 10, 2009 at 5:59 PM, Moses <mosenetk@gmail.com> wrote: The article aside, I have used for several years SQL-Server, Oracle, Postgres and Mysql. When presented with the same optimal level of load, hardware and platform, SQL-Server sucks in comparison. There are very few positive things that I can say about sql-server in COMPARISON with other DB platforms other than the fact that they have a huge marketing budget and effective sales network! On Wed, Jun 10, 2009 at 9:50 AM, Rad! <conradakunga@gmail.com> wrote: Interesting article. I've come to find that articles praising one vendor's products over another's wiritten by the vendor are best taken with a pinch of salt. I read Oracle comparisons by Oracle, SQL Server comparisons by Microsoft and DB2 comparisons by IBM skeptically. Not to say that they lie, but they are written in such a way to make the competition look less appealing. Selecting a database for production useI would imagine is best done on a case by case basis depending on several factors (cost, support, skill set, features, operating system, problem domain etc) which would mean for different scenarios you'd end up with different databases. On Tue, Jun 9, 2009 at 9:31 PM, Murigi Muraya <mmskunkworks@gmail.com> wrote: This week a Windows C/C# guru was showing me an SMS corporate app he has developed. Anyway, he has built it to run on MySQL. So this article linked below may ring quite true to some of you out there! http://dev.mysql.com/tech-resources/articles/move_from_microsoft_SQL_Server. html _______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general _______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general _______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
I think interesting are going to happen to MySQL now that its owned by Oracle. On Thu, Jun 11, 2009 at 7:57 AM, Steve Obbayi <steve@sobbayi.com> wrote:
I was going to put my foot down on this until i read this line
"Depending on your ability to make use said features, your mileage may vary"
There two things every developer should look at when features are listed in a Software Product.
1. Are those features really practical and applicable in ones use case - its like telling me your car can move at 300 mph and drag and elephant accros sahara on a gallon of gas - when am i ever going to get an opportunity to do that?
2. Do those features actually work as well as supposedly stated by the vendor. I this case when i say work i really mean something like this... am i gonna be able to replicate one terrabyte of data halfway accross earth and it takes me 36hrs especiall if am using one of SQLservers relication such as snap shot. might as well do an SQL dump of the data and fedex it to the remote location and have it imported back in. nuff said.
Now in many cases without going into details, SQL Server (in general) has come short of expectations. Just a quick comment. Packing features into a product causes it t become bloated and thats why we have what we call plugins. A good product has all the necessary stuff one needs and the addition candy supplied as a pluggin. Now with RDMS like MYSQL it has been deliberately stripped off some of the features to make it as robust as it is today... Wait. here's the catch. some of the features have also simply been moved into various storage engines so the developer has the ability to choose what engne and features they need.
I'll stop there
Steve Obbayi,
------------------------------ *From:* skunkworks-bounces@lists.my.co.ke [mailto: skunkworks-bounces@lists.my.co.ke] *On Behalf Of *Rad! *Sent:* Wednesday, June 10, 2009 6:11 PM *To:* Skunkworks forum *Subject:* Re: [Skunkworks] MySQL on Windows
Well, that is entirely subjective. I too have used a variety of RDMBS systems, and for the solutions I used SQL Server I am very happy with the performance. Whereas you are unable to find positive things I can find several. For instance
1. 3 replication techniques 2. Dedicated date and time data types (fantastic for reporting and data warehousing) 3. Timezone aware datetime type 4. Geospatial type 5. Embedded .NET runtime, allowing procedures and functions to be written in .NET as well as allowing use of 3rd party DLLs. A godsend for situations where SQL is very poor like regular expressions 6. Integration services for ETL tasks 7. Business Intelligence 8. Data warehousing 9. Structured error handling in T-SQL (try-catch-finally) 10. Transparent data encryption 11. etc
Depending on your ability to make use said features, your mileage may vary
On Wed, Jun 10, 2009 at 5:59 PM, Moses <mosenetk@gmail.com> wrote:
The article aside, I have used for several years SQL-Server, Oracle, Postgres and Mysql. When presented with the same optimal level of load, hardware and platform, SQL-Server sucks in comparison. There are very few positive things that I can say about sql-server in COMPARISON with other DB platforms other than the fact that they have a huge marketing budget and effective sales network!
On Wed, Jun 10, 2009 at 9:50 AM, Rad! <conradakunga@gmail.com> wrote:
Interesting article. I've come to find that articles praising one vendor's products over another's wiritten by the vendor are best taken with a pinch of salt. I read Oracle comparisons by Oracle, SQL Server comparisons by Microsoft and DB2 comparisons by IBM skeptically. Not to say that they lie, but they are written in such a way to make the competition look less appealing.
Selecting a database for production useI would imagine is best done on a case by case basis depending on several factors (cost, support, skill set, features, operating system, problem domain etc) which would mean for different scenarios you'd end up with different databases.
On Tue, Jun 9, 2009 at 9:31 PM, Murigi Muraya <mmskunkworks@gmail.com>wrote:
This week a Windows C/C# guru was showing me an SMS corporate app he has developed. Anyway, he has built it to run on MySQL. So this article linked below may ring quite true to some of you out there!
http://dev.mysql.com/tech-resources/articles/move_from_microsoft_SQL_Server....
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
I am only to happy to respond to your vaguely condescending email. I have a project that stores maps in a database and generates a map depending on various criteria. For that native shapefile support in a database is not bloat. It has saved me days of wrestling with issues like serlializing and deserializing shapefiles for storage and display For another project I have some legacy data (unnormalized) in the database that I need to process prior to display. (For political reasons normalizing it is not possible) Most database (except maybe Oracle) have very rudimentary regular expression support. .NET has a very good regular expression engine and so I wrote some functions in C# to expose that. CLR support is not bloat. Reporting using datetimes is very cumbersome because of the time element. You invariably have to find some way to remove the time when querying data stored as datetimes. Same problem when you're only interested in the time. So separate types is not bloat. You will find use for a timezone aware datetime when you develop a scheduling application that allows people to set up meetings. Just try doing that using normal datetimes. 3 o'clock in Nairobi is not 3 o'clock in New York. And so on. Like I said, it depends on the projects you are working on. If your domain is sacco software then I agree you'll never get to use most of these features,unless its datetime. As for the features working -- if you are replicating a terabyte of data, something is wrong with your design. There are better ways t do it (mirroring, log shipping, etc). As for that old argument of features=bloat all I can say is it depends on you. One man's candy is another man's bread and butter. Personally I prefer a Swiss army knife to a butter knife. Either way you can still butter bread. I've stopped trying to wrap my brains around the argument that lack of features is a good thing. By the way, your point of storage engines is deceptive. (For the record I have some projects that are using MySQL 5). The problem with the multiplicity of storate engines is that they all offer features that the others lack. What if I wanted an engine that had soe features of InnoDB and other features from ISAM? By the way, please notice that NOWHERE have i said SQL Server is better than MySQL, or vice versa. I just said what I happened to find worked very well for me. I dare say more people would benefit from this discussion if we kept it from degenerating into 'my daddy can beat your daddy' if you outlined what about MySQL makes it your database of choice. On Thu, Jun 11, 2009 at 7:57 AM, Steve Obbayi <steve@sobbayi.com> wrote:
I was going to put my foot down on this until i read this line
"Depending on your ability to make use said features, your mileage may vary"
There two things every developer should look at when features are listed in a Software Product.
1. Are those features really practical and applicable in ones use case - its like telling me your car can move at 300 mph and drag and elephant accros sahara on a gallon of gas - when am i ever going to get an opportunity to do that?
2. Do those features actually work as well as supposedly stated by the vendor. I this case when i say work i really mean something like this... am i gonna be able to replicate one terrabyte of data halfway accross earth and it takes me 36hrs especiall if am using one of SQLservers relication such as snap shot. might as well do an SQL dump of the data and fedex it to the remote location and have it imported back in. nuff said.
Now in many cases without going into details, SQL Server (in general) has come short of expectations. Just a quick comment. Packing features into a product causes it t become bloated and thats why we have what we call plugins. A good product has all the necessary stuff one needs and the addition candy supplied as a pluggin. Now with RDMS like MYSQL it has been deliberately stripped off some of the features to make it as robust as it is today... Wait. here's the catch. some of the features have also simply been moved into various storage engines so the developer has the ability to choose what engne and features they need.
I'll stop there
Steve Obbayi,
Am willing to invest (in classroom or conference space) for Conrad and others to educate interested parties on .Net. Microsoft East Africa is organized locally to sell software licenses not to promote software engineering like Google Kenya is doing to localize their Search (Software as a Service). Just e-mail c-sharp-asp.net@saltech.co.ke to notify us of your interest in these technologies. Have been thinking of guided self study reviewed on a Friday (2pm to 6pm or 4pm to 8pm) or / plus a Saturday morning (9am to 1pm) @ USD 40.00 per (4 hour) session. In the .Net world, developers do not work for free(dom), they work for MONEY! That's just how it is! PERIOD! Cannot discourage torrents (e-books) after international computer book publishers have ignored (not responded to) our queries over a 2 year period. How does one make Africans (non corporates) pay 4-6K (after shipping and handling) for a book bought for 2-3K in the USA or India? Hard core software developer training is not profitable (trust me when I tell you this from experience - there is too little demand for it as developers are usually self taught). This is why it is hard to find. It is more commonly done in house. A McKinsey Study (commissioned by the Kenya ICT Board) did not recommend (nor discourage) us to get into the Application Development (Outsourcing). Our software developers have failed work as teams doing notable projects So we must take action to encourage GLOBALLY noticed Application Development! On Thu, Jun 11, 2009 at 12:14 PM, Rad! <conradakunga@gmail.com> wrote:
I am only to happy to respond to your vaguely condescending email.
I have a project that stores maps in a database and generates a map depending on various criteria. For that native shapefile support in a database is not bloat. It has saved me days of wrestling with issues like serlializing and deserializing shapefiles for storage and display
For another project I have some legacy data (unnormalized) in the database that I need to process prior to display. (For political reasons normalizing it is not possible) Most database (except maybe Oracle) have very rudimentary regular expression support. .NET has a very good regular expression engine and so I wrote some functions in C# to expose that. CLR support is not bloat.
Reporting using datetimes is very cumbersome because of the time element. You invariably have to find some way to remove the time when querying data stored as datetimes. Same problem when you're only interested in the time. So separate types is not bloat.
You will find use for a timezone aware datetime when you develop a scheduling application that allows people to set up meetings. Just try doing that using normal datetimes. 3 o'clock in Nairobi is not 3 o'clock in New York.
And so on. Like I said, it depends on the projects you are working on. If your domain is sacco software then I agree you'll never get to use most of these features,unless its datetime.
As for the features working -- if you are replicating a terabyte of data, something is wrong with your design. There are better ways t do it (mirroring, log shipping, etc).
As for that old argument of features=bloat all I can say is it depends on you. One man's candy is another man's bread and butter. Personally I prefer a Swiss army knife to a butter knife. Either way you can still butter bread. I've stopped trying to wrap my brains around the argument that lack of features is a good thing.
By the way, your point of storage engines is deceptive. (For the record I have some projects that are using MySQL 5). The problem with the multiplicity of storate engines is that they all offer features that the others lack. What if I wanted an engine that had soe features of InnoDB and other features from ISAM?
By the way, please notice that NOWHERE have i said SQL Server is better than MySQL, or vice versa. I just said what I happened to find worked very well for me. I dare say more people would benefit from this discussion if we kept it from degenerating into 'my daddy can beat your daddy' if you outlined what about MySQL makes it your database of choice.
On Thu, Jun 11, 2009 at 7:57 AM, Steve Obbayi <steve@sobbayi.com> wrote:
I was going to put my foot down on this until i read this line
"Depending on your ability to make use said features, your mileage may vary"
There two things every developer should look at when features are listed in a Software Product.
1. Are those features really practical and applicable in ones use case - its like telling me your car can move at 300 mph and drag and elephant accros sahara on a gallon of gas - when am i ever going to get an opportunity to do that?
2. Do those features actually work as well as supposedly stated by the vendor. I this case when i say work i really mean something like this... am i gonna be able to replicate one terrabyte of data halfway accross earth and it takes me 36hrs especiall if am using one of SQLservers relication such as snap shot. might as well do an SQL dump of the data and fedex it to the remote location and have it imported back in. nuff said.
Now in many cases without going into details, SQL Server (in general) has come short of expectations. Just a quick comment. Packing features into a product causes it t become bloated and thats why we have what we call plugins. A good product has all the necessary stuff one needs and the addition candy supplied as a pluggin. Now with RDMS like MYSQL it has been deliberately stripped off some of the features to make it as robust as it is today... Wait. here's the catch. some of the features have also simply been moved into various storage engines so the developer has the ability to choose what engne and features they need.
I'll stop there
Steve Obbayi,
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
On Thu, Jun 11, 2009 at 1:59 PM, Murigi Muraya <mmskunkworks@gmail.com>wrote:
... Have been thinking of guided self study reviewed on a Friday (2pm to 6pm or 4pm to 8pm) or / plus a Saturday morning (9am to 1pm) @ USD 40.00 per (4 hour) session. ...
Why US dollars? :)
Regional considerations! An Ethiopian coming in for a 'Weekend with C#' will find it easier to compute in USD. Our market is too small to rely on. Very few in Kenya (and East Africa) are willing or able to pay 3K for a 4 hour .Net session! Locally, we get charged in GBP for certification tests. http://stackoverflow.com/questions/7113/is-it-worth-it-to-get-ms-certified On Thu, Jun 11, 2009 at 2:06 PM, Joseph Wayodi <jwayodi@gmail.com> wrote:
On Thu, Jun 11, 2009 at 1:59 PM, Murigi Muraya <mmskunkworks@gmail.com>wrote:
... Have been thinking of guided self study reviewed on a Friday (2pm to 6pm or 4pm to 8pm) or / plus a Saturday morning (9am to 1pm) @ USD 40.00 per (4 hour) session. ...
Why US dollars? :)
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
Just to stop this degenerating into a "my daddy can beat your daddy" debate, the point is all RDMS have got pros and cons so defending one over another is a never ending tale. That war has been fought and the battle still rages on however, i just want to make to points here. the terrabyte data relication i mentioned is when using snapshot method on sqlserver which is known to be time consuming... not necessarily for large datasets but its generally time consuming. I donno if you have tried using it. Now about the storage engine your choice of storage engines can be misinformed... Let me pick on your scenario. You want a feature on MYISAM and another from INNODB. The solution is simple try out the MARIADB Storage Engine it is has adopted the features of INNODB and merged them with features from MYISAM. Now the current branch we are working on even picks some robust features out of XTRADB which is a major improvement of INNODB engine. Trust me. what you are looking for in feature sets is spread out between those engine. Think al stop now before i go on and on. _____ From: Rad! [mailto:conradakunga@gmail.com] Sent: Thursday, June 11, 2009 12:15 PM To: steve@sobbayi.com; Skunkworks forum Subject: Re: [Skunkworks] MySQL on Windows I am only to happy to respond to your vaguely condescending email. I have a project that stores maps in a database and generates a map depending on various criteria. For that native shapefile support in a database is not bloat. It has saved me days of wrestling with issues like serlializing and deserializing shapefiles for storage and display For another project I have some legacy data (unnormalized) in the database that I need to process prior to display. (For political reasons normalizing it is not possible) Most database (except maybe Oracle) have very rudimentary regular expression support. .NET has a very good regular expression engine and so I wrote some functions in C# to expose that. CLR support is not bloat. Reporting using datetimes is very cumbersome because of the time element. You invariably have to find some way to remove the time when querying data stored as datetimes. Same problem when you're only interested in the time. So separate types is not bloat. You will find use for a timezone aware datetime when you develop a scheduling application that allows people to set up meetings. Just try doing that using normal datetimes. 3 o'clock in Nairobi is not 3 o'clock in New York. And so on. Like I said, it depends on the projects you are working on. If your domain is sacco software then I agree you'll never get to use most of these features,unless its datetime. As for the features working -- if you are replicating a terabyte of data, something is wrong with your design. There are better ways t do it (mirroring, log shipping, etc). As for that old argument of features=bloat all I can say is it depends on you. One man's candy is another man's bread and butter. Personally I prefer a Swiss army knife to a butter knife. Either way you can still butter bread. I've stopped trying to wrap my brains around the argument that lack of features is a good thing. By the way, your point of storage engines is deceptive. (For the record I have some projects that are using MySQL 5). The problem with the multiplicity of storate engines is that they all offer features that the others lack. What if I wanted an engine that had soe features of InnoDB and other features from ISAM? By the way, please notice that NOWHERE have i said SQL Server is better than MySQL, or vice versa. I just said what I happened to find worked very well for me. I dare say more people would benefit from this discussion if we kept it from degenerating into 'my daddy can beat your daddy' if you outlined what about MySQL makes it your database of choice. On Thu, Jun 11, 2009 at 7:57 AM, Steve Obbayi <steve@sobbayi.com> wrote: I was going to put my foot down on this until i read this line "Depending on your ability to make use said features, your mileage may vary" There two things every developer should look at when features are listed in a Software Product. 1. Are those features really practical and applicable in ones use case - its like telling me your car can move at 300 mph and drag and elephant accros sahara on a gallon of gas - when am i ever going to get an opportunity to do that? 2. Do those features actually work as well as supposedly stated by the vendor. I this case when i say work i really mean something like this... am i gonna be able to replicate one terrabyte of data halfway accross earth and it takes me 36hrs especiall if am using one of SQLservers relication such as snap shot. might as well do an SQL dump of the data and fedex it to the remote location and have it imported back in. nuff said. Now in many cases without going into details, SQL Server (in general) has come short of expectations. Just a quick comment. Packing features into a product causes it t become bloated and thats why we have what we call plugins. A good product has all the necessary stuff one needs and the addition candy supplied as a pluggin. Now with RDMS like MYSQL it has been deliberately stripped off some of the features to make it as robust as it is today... Wait. here's the catch. some of the features have also simply been moved into various storage engines so the developer has the ability to choose what engne and features they need. I'll stop there Steve Obbayi,
The Data Protection Act is going to make us think about more than performance. http://www.tometasoftware.com/MySQL-5-vs-Microsoft-SQL-Server-2005.asp On Wed, Jun 10, 2009 at 5:59 PM, Moses <mosenetk@gmail.com> wrote:
The article aside, I have used for several years SQL-Server, Oracle, Postgres and Mysql. When presented with the same optimal level of load, hardware and platform, SQL-Server sucks in comparison. There are very few positive things that I can say about sql-server in COMPARISON with other DB platforms other than the fact that they have a huge marketing budget and effective sales network!
On Wed, Jun 10, 2009 at 9:50 AM, Rad! <conradakunga@gmail.com> wrote:
Interesting article. I've come to find that articles praising one vendor's products over another's wiritten by the vendor are best taken with a pinch of salt. I read Oracle comparisons by Oracle, SQL Server comparisons by Microsoft and DB2 comparisons by IBM skeptically. Not to say that they lie, but they are written in such a way to make the competition look less appealing.
Selecting a database for production useI would imagine is best done on a case by case basis depending on several factors (cost, support, skill set, features, operating system, problem domain etc) which would mean for different scenarios you'd end up with different databases.
On Tue, Jun 9, 2009 at 9:31 PM, Murigi Muraya <mmskunkworks@gmail.com>wrote:
This week a Windows C/C# guru was showing me an SMS corporate app he has developed. Anyway, he has built it to run on MySQL. So this article linked below may ring quite true to some of you out there!
http://dev.mysql.com/tech-resources/articles/move_from_microsoft_SQL_Server....
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
Murigi, Can you share what with the rest of us what the corporate app does ? Im quite interested in C# applications. Thanks, Kevin On Tue, Jun 9, 2009 at 9:31 PM, Murigi Muraya <mmskunkworks@gmail.com>wrote:
This week a Windows C/C# guru was showing me an SMS corporate app he has developed. Anyway, he has built it to run on MySQL. So this article linked below may ring quite true to some of you out there!
http://dev.mysql.com/tech-resources/articles/move_from_microsoft_SQL_Server....
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
participants (7)
-
Joseph Wayodi -
Kevin Oeba -
Moses -
Murigi Muraya -
Peter Karunyu -
Rad! -
Steve Obbayi