Kategori: Development

november 28, 2016 Development

Raster vs SVG: Part 2 (with bonuses)!

Hello again guys! As promised, in today’s blog I will be covering scalable vector graphics, SVG, as well as offer you a little extra something: an insight on GZIP compression for your webserver. The reason of this addition: the advantages of GZIP compression, one of which to save you at least 50% on your bandwidth usage.

Continue reading
november 21, 2016 Development

Raster and SVG – The old and the new

In the first part of today´s blog I would like to talk a little about scalable vector graphics (SVG).

For the seasonable developer this is no new topic, however for those interested in tech matters, the post might give a couple of answers to your thoughts, so let´s get going!

Continue reading
oktober 10, 2016 Development

Import CSV and Excel to SQL

Most of us have been there

It’s late afternoon. You look forward to going home to your family and have a nice evening off relaxing. Then, all of a sudden, your PM stops by with a wish. You have to import some customers data into a system now. Today. As it can’t wait till tomorrow. Then you realize it’s a pretty big file at stake. You get on the phone and tell your spouse you are gonna be late. Yes. Again…

Importing CSV to SQL databases can be pretty easy when it comes to small files containing a determined and “known” data. But when the file is bigger and the data type is unknown, often you just end up defining column types that might either be unoptimized or plain wrong, thus resulting in data truncation and/or failed imports.

Continue reading