John W. Colby
jwcolby at gmail.com
Sat Feb 28 09:32:46 CST 2015
>>Yes, I remember your driven by a large MS SQL backend DB application development story. Is it up&running? It is up and running. I have been using it for years. >>No any plans to migrate it to Linux/noSQL - Map Reduce ( http://en.wikipedia.org/wiki/MapReduce ) / CouchDB ( http://en.wikipedia.org/wiki/CouchDB ) ? I would love to migrate it to MariaDB, however the C# code was written to target SQL Server specifically. The bigger problem is that the database is used to pull data sets for sale. I have an entire template database that I copy for each client order, and that template database has defined tables, views and stored procedures that I use to fill the order. Once the order is filled, the order database becomes a history of what was done to fill the order, as well as a history of records not to be sold again should the client order another data set. In the end there is simply no compelling reason to make the move. Yet. The compelling reason long term is that the SQL Server is hosted on Windows 2008, and SQL Server itself is 2008 as well. As we know, MS likes to force us to upgrade by dropping support (including bug / security fixes). I don't know if you have ever looked, but licenses for new versions are EXPENSIVE!!! Particularly for tiny companies. So someday, in the next few years, I will likely be forced to do something. I am in fact trying to get MariaDB running on my Linux Mint server / workstation here at my office. Sadly, doing anything in Linux is a serious exercise in frustration compared to doing the equivalent in Windows. MariaDB is installed. I can't log in. Breaking in as the root user isn't working as the Google search says it should. I have an old Areca RAID controller which has to be firmware updated to work with the modern drives larger than 2 tb size. In Windows, that involves downloading the file and using a program from Areca to find a firmware file and upgrade. Dead simple. The same exact process is required for Linux except... Since I am just bringing this card up for the first time (in Linux) I have to start from scratch installing drivers, installing the software etc. That involves figuring out what version of Linux... downloading the right thing from Areca... Typing in loads of crap in the command window... dealing with the inevitable (and I do mean inevitable) error messages. So a simple (in Windows) 15 minute install turns into an hours long exercise in frustration (all of last night), and this morning the Areca card and three spanking new 3 tb drives are still a useless paperweight hooked up to the Linux machine. For some reason, the Linux crowd seems to think this is supposed to be fun??? I have PILES of work backed up behind "simple" (on Windows) things that just aren't progressing on Linux Mint. Something always goes wrong somewhere. And figuring it out ALWAYS starts with "what version of Linux" and goes downhill from there. Google (And SUDO, and the command window for GOD's sake) is my friend. Except the last two are only very uneasy allies. In my opinion the core of the Linux problem is simply that with so many distros out there, no company selling into the Linux environment can do anything in a consistent manner because nothing works the same on every distro. And so the poor guy (me) trying to get anything done is tasked with sorting it all out for the specific distro chosen. Linux is supposed to be free. The problem is that the Linux cost is in all the stunningly stupid crap that has to be figured out to get anything more than the simplest install done. And all that comes BEFORE, and stands in the way of, actually getting any work done. Boy did that end up off-topic or what? My frustration is showing. On a lighter note, I have come to the conclusion that approximately 50% of ALL the internet content is "how to" articles for getting stuff done in Linux. ;) John W. Colby On 2/28/2015 3:14 AM, Salakhetdinov Shamil wrote: > Yes, I remember your driven by a large MS SQL backend DB application development story. Is it up&running? No any plans to migrate it to Linux/noSQL - Map Reduce (http://en.wikipedia.org/wiki/MapReduce ) / CouchDB (http://en.wikipedia.org/wiki/CouchDB ) ?