4 ms·

Back when I was a baby programmer in the early 00s picking tools to learn about (I'm self taught), I picked a few obscure looking things that looked like the ri

Back when I was a baby programmer in the early 00s picking tools to learn about (I'm self taught), I picked a few obscure looking things that looked like the right choice. These included R (which has now taken over the statistical world), Debian, Postgresql and Perl (good choice for me - worked out well). Pg always looked like a better choice than mysql to me. As evidenced during an early job I did where mysql disappeared some of my data it really shouldn't have done due to its well understood but not by me back then pitfalls.

Annatar 4y ago
With over 15,000 packages at CRAN, R has evolved from a wonderful language for statistics to a wonderful general-purpose language. I came in contact with R by accident because a colleague of mine took a day off and the client approached me instead, and it's a love affair with R that has lasted since. I haven't been excited about a programming language since I was last learning the MC68000 family's assembler. I just cannot sing R enough praises. R of course has packages for connecting to a PostgreSQL database, and Vertica is a PostgreSQL database with R as the scripting language. Such a wonderful combination. I'd gladly use and administer Vertica again without a second thought, given the opportunity,
- singingfish 4y ago
  Oh no, R as a general purpose language, argh! I mean yeah whatever floats your boat but I find it torturous for anything other than as a specialist platform for doing linear algebra - aka statistical analysis. I got a nice half hour meeting with one of the core R developers a few years ago back when I was pretending to be an academic - he was a regular collaborator with one of the senior academics in the business school that most of my work was coming from at the time.
takeda 4y ago
I feel like everyone who worked with MySQL, had some story with lost data. Two companies that I worked for used MySQL and in both of them I had an instance where data was lost or corrupted and it did not involve hardware failure. First instance was that there was MySQL service that crashed and refused to start up. The machine was not rebooted or shut down abruptly, disk was not corrupted, also disk was not full and had plenty of space. Running repair command resolved the issue, but it was weird. In another instance we run into a bug and apparently certain character combination in the data made MySQL all out of sudden think the data was encrypted.

Annatar 4y ago

With over 15,000 packages at CRAN, R has evolved from a wonderful language for statistics to a wonderful general-purpose language. I came in contact with R by accident because a colleague of mine took a day off and the client approached me instead, and it's a love affair with R that has lasted since. I haven't been excited about a programming language since I was last learning the MC68000 family's assembler. I just cannot sing R enough praises. R of course has packages for connecting to a PostgreSQL database, and Vertica is a PostgreSQL database with R as the scripting language. Such a wonderful combination. I'd gladly use and administer Vertica again without a second thought, given the opportunity,

singingfish 4y ago
Oh no, R as a general purpose language, argh! I mean yeah whatever floats your boat but I find it torturous for anything other than as a specialist platform for doing linear algebra - aka statistical analysis. I got a nice half hour meeting with one of the core R developers a few years ago back when I was pretending to be an academic - he was a regular collaborator with one of the senior academics in the business school that most of my work was coming from at the time.

takeda 4y ago

I feel like everyone who worked with MySQL, had some story with lost data. Two companies that I worked for used MySQL and in both of them I had an instance where data was lost or corrupted and it did not involve hardware failure. First instance was that there was MySQL service that crashed and refused to start up. The machine was not rebooted or shut down abruptly, disk was not corrupted, also disk was not full and had plenty of space. Running repair command resolved the issue, but it was weird. In another instance we run into a bug and apparently certain character combination in the data made MySQL all out of sudden think the data was encrypted.