Viewing profile — tkyjonathan

Misadventures in AWS Lambda, connection pooling and killing the database with unclosed transactions.

Isn't this DataOps?

Almost none of the company leaders or even VCs fully understand what AI even is or does. They just like to hear thats its there. If you don't have some AI in your company, you won'…

"Normalization was built for a world with very different assumptions. In the data centers of the 1980s, storage was at a premium and compute was relatively cheap." But forget to do…

Location: UK, Horsham Remote: Yes Willing to relocate: No Technologies: Data Engineering, Data Architecture, Data Performance Engineering, Java, Python, SQL. Résumé/CV: https://www…

Location: West Sussex, UK Remote: Yes Willing to relocate: No Technologies: Data Architect, Data Modeling, Data Performance Engineer, SQL, MySQL, Percona, MariaDB, Galera, Postgres…

This is obvious to me. Since Hadoop came out, (a lot of) people have been giving up on even forming algorithms and just dumping data into machine learning and hoping for the best. …

I said this 3 years ago, the future is having an SQLite DB inside a container for each one of your customers. /s

If its minimum of 70k, then its probably a good idea, because you would only hire if you absolutely have to. 37signals would be proud. If you decentivize the most productive people…

I reduce my RDS bill by 66% by keeping it on EC2 and using Percona Server.

Batching is the multi-threadedness of databases. Its also important to remember that in databases, you are more often optimising for IO usage than CPU.

That could be a fault of complex physical data models that need simplification.

It is worth mentioning that there are some data-process heavy work that can be done much faster and more efficiently in SQL. Real life example for a regulatory batch job: 6 tomcat …

Imagine my shock. Asking for regulation simply to attack the competition or new entrants..

This is very impressive. The average lifespan of a company on the S&P 500 is 15 years.

I'm still on pen and paper..

I feel that philosophy of systems and theory of constraints would be a better philosophy to use with computer systems.

And a lot of those lakes remain untouched for years..

Already started a DataOps team in my company!

Where has this been since 2015?

This is going to be your next cloud agnostic data warehouse.

Not sure which DB you are using, but you can load the csv file into the DB directly on a single thread using something like LOAD DATA INFILE. If you have some good indexes and do s…