Oracle table() function disabling optimizations, part 2
Large union-all kills parsing performance, use an unpivot instead.
Architecturally Elegant - lahteenmaki.net
Latest posts
Modbus TCP and home automation
Modbus TCP can be used to read and control some devices at home
Oracle table() function disabling optimizations
Including table() function anywhere in a query in Oracle database disables some optimizations.
Hard problems
There are certain hard problems in any industry
A brief intro to Oracle macros etc
Some basics of Pipelined Table Functions, Polymorphic Table Functions and Macros in Oracle
Functional programming in Java
About libraries meta-utils and functional-utils to help in functional programming in Java.
Making Swagger codegen tolerable
Java client codegen for Swagger doesn’t support everything out of the box, but it seems to be extensible.
Combinator birds
Table of known combinators/birds and their properties
Applicative Parsing
Implementing a combinatorial parser utilizing applicative parsing.
Making Jackson tolerable
I believe the “right way” to do serialization and deserialization is a “type class based” approach, like what Aeson does. Unfortunately the community hasn’t given us one in the Java-land. Jackson is a widely (?) used JSON serialization libary. Unfortunately it has a few problems, but the good thing is that it provides some ways to make it more tolerable.
Goodbye Blogger, hello Pandoc and scripts
How I moved my blog from Blogger to a more developer-friendly platform.
About Subtext
Some thoughts related to Subtext.
Java Streams vs C# LINQ vs Java6 - updated examples
Java Streams vs C# LINQ vs Java6 - updated examples Authors Jyri-Matti Lähteenmäki Date 2014-05-17 Status Published Java 8 is published. This post is a rewrite of my previous one with updated examples. I added a third example to each challenge demonstrating how my functional-utils library could be used with lambdas. Challenge 1: Filtering LINQ : string [] names = { "Sam" , "Pamela" , "Dave" ,…
Java Streams vs C# LINQ vs Java6
Java Streams vs C# LINQ vs Java6 Authors Jyri-Matti Lähteenmäki Date 2013-04-10 Status Published A while back I ran into an article comparing C# LINQ to the upcoming Java8 Streams API: http://blog.informatech.cr/2013/03/24/java-streams-preview-vs-net-linq/ . I’m not really experienced with C# but I have a feeling that the language as a whole is quite verbose and, well, bad? Except for LINQ which…
Haskell and non-blocking asynchronous IO
Haskell and non-blocking asynchronous IO Authors Jyri-Matti Lähteenmäki Date 2013-01-05 Status Published Here begins my journey to the magnificent world of Haskell. I was chatting with a co-worker a while back about the influence of programming languages to code quality etc. He mentioned node.js and working with Promises . I kind of responded that I don’t really like Promise-hell or Callback-hell…
Simple construction of common queries with JPA2
Simple construction of common queries with JPA2 Authors Jyri-Matti Lähteenmäki Date 2012-08-21 Status Published In the previous post I demonstrated an API for executing queries. Now we need some queries. Due to some odd design choices, JPA2 Criteria API isn’t exactly the easiest API for query construction. Maybe we could utilize its metamodel to create an easier, statically typed way to construct…
Java Persistence API 2. Still useless?
Java Persistence API 2. Still useless? Authors Jyri-Matti Lähteenmäki Date 2012-08-10 Status Published In my day job I have the “privilege” to use JPA ( Hibernate in practice) for persistence. So when JPA2 was released I was eager to find out if they had actually corrected their mistakes and made a framework comparable to competitors. Well, they hadn’t. Don’t get me wrong. I actually don’t hate…
Statically typed Vector and Matrix algebra
Statically typed Vector and Matrix algebra Authors Jyri-Matti Lähteenmäki Date 2012-01-12 Status Published I took a course on Machine Learning a while back, just for fun. Stanford University seems to have really put some effort into free courses in the Internet, since Artificial Intelligence and Introduction to Databases were also time well spent. The exercises in Octave reminded me of Matlab and…
Composable querying with Scala
Composable querying with Scala Authors Jyri-Matti Lähteenmäki Date 2011-06-28 Status Published It’s been a while since my last post, but finally I was able to find enough time to re-implement the whole querying-thing and experiment with composability. My initial implementation was partly mutable (orgh, sorry about that…) which made true composability somewhat difficult (well, impossible, I guess).…
Querying with Scala
Querying with Scala Authors Jyri-Matti Lähteenmäki Date 2011-02-14 Status Published Let’s say we have a simple domain model with departments and employees (behold my imagination…). Forget all persistence or SQL related stuff, let’s just have it all in-memory: object InMemory { case class Employee ( name : String , salary : Option [ Int ]) case class Department ( name : String , employees : Set […
Greetings
Greetings Authors Jyri-Matti Lähteenmäki Date 2011-02-05 Status Published I felt like I needed a place to write some thoughts and views of programming. So, I decided to create a blog. I was going to write a wiki-style site in Scala but since my free time is awfully limited, it would have taken years =) Well, I do have such a site for sharing some events from the lives of my two boys, but the…