|
Scalar Subqueries in Oracle SQL WHERE clauses (and a little bit of Exadata stuff too)
-
tanelpoder.com
-
12 years ago
-
eng
My previous post was about Oracle 12c SQL Scalar Subquery transformations . Actually I need to clarify its scope a bit: the previous post was about scalar subqueries inside a SELECT projection list only (meaning that for populating a field in the query resultset, a subquery gets executed once for each row returned back to the caller, instead of returning a “real” column value passed up from a child rowsource). I did not cover an other ....
|
|
Scalar Subqueries in Oracle SQL WHERE clauses (and a little bit of Exadata stuff too)
-
tanelpoder.com
-
12 years ago
-
eng
My previous post was about Oracle 12c SQL Scalar Subquery transformations . Actually I need to clarify its scope a bit: the previous post was about scalar subqueries inside a SELECT projection list only (meaning that for populating a field in the query resultset, a subquery gets executed once for each row returned back to the caller, instead of returning a “real” column value passed up from a child rowsource). I did not cover an other ....
|
|
During the 1950’s the famous mathematician Paul Erdős and Alfred Rényi put forth the concept of a random graph and in the subsequent years of study transformed the world of combinatorics. The random graph is the perfect example of a good mathematical definition: it’s simple, has surprisingly intricate structure, and yields many applications. In this post we’ll explore basic facts about random graphs, slowly detail a proof on their applicati..
|
|
During the 1950’s the famous mathematician Paul Erdős and Alfred Rényi put forth the concept of a random graph and in the subsequent years of study transformed the world of combinatorics. The random graph is the perfect example of a good mathematical definition: it’s simple, has surprisingly intricate structure, and yields many applications. In this post we’ll explore basic facts about random graphs, slowly detail a proof on their applicati..
|
|
During the 1950’s the famous mathematician Paul Erdős and Alfred Rényi put forth the concept of a random graph and in the subsequent years of study transformed the world of combinatorics. The random graph is the perfect example of a good mathematical definition: it’s simple, has surprisingly intricate structure, and yields many applications. In this post we’ll explore basic facts about random graphs, slowly detail a proof on their applicati..
|
|
How to convert FLAC files from 24/48 bit to 16 bit on Ubuntu Linux
-
duncanlock.net
-
12 years ago
-
eng
I recently needed to convert some FLAC music files from the increasingly common 48 bit encoding, down to 16 bit at 44100 kHz, so that they’ll play on my Sonos. Here’s how to do it: If you don’t already have sox installed, do this to install it: $ sudo apt-get install sox Then run this to do the conversion, in the folder with music in: $ mkdir resampled $ for flac in * .flac ; do sox -S " ${ flac } ..
|
|
My son and I were having fun last weekend building a console based game in Go. I was recreating a game from my youth, back when I was programming on a Kaypro II. I loved this computer. I would write games in BASIC on it all day and night. Did I mention it was portable. The keyboard would strap in and you could carry it around. LOL. But I digress, back to my Go program. I figured out a way to use the VT100 escape ....
|
|
There’s a great movie to be made about the life of Steve Jobs, but Jobs is not it. The primary challenge in making a film about the co-founder of Apple is finding an actor who can play an overtly cerebral, egomaniacal dick, but a dick for whom you want to root. Besides a striking resemblance to the young Steve Jobs, Ashton Kutcher is a terrible choice: There’s nothing about his character that makes you want to root for him, and all of his a..
|
|
Although the first movie adaptation of Christopher Paolini’s Eragon could have passed as a mildly successful yet unremarkable summer movie, it falls far short when compared to the original series from which it borrowed little besides character names and basic plotlines, only to discard the latter whenever the “director” deemed it convenient. Anyone who has ever seen a book-turned-movie undoubtedly read that without any surprise; the book ..
|
|
ShowMOS: How to get rid of the annoying “The Page has Expired” dialog in My Oracle Support
-
tanelpoder.com
-
12 years ago
-
eng
So, how many of you do hate the dialog below? Good news – there is a fix! (or well, a hack around it ;) Before showing the fix, you can vote & give your opinion here: Do you love or hate the MOS “page expired” dialog? The fix is actually super-simple. The page expiration dialog that grays out the browser screen is just a HTML DIV with ID DhtmlZOrderManagerLayerContainer , overlaying the useful content. If you want it to disa..
|
|
ShowMOS: How to get rid of the annoying “The Page has Expired” dialog in My Oracle Support
-
tanelpoder.com
-
12 years ago
-
eng
So, how many of you do hate the dialog below? Good news – there is a fix! (or well, a hack around it ;) Before showing the fix, you can vote & give your opinion here: Do you love or hate the MOS “page expired” dialog? The fix is actually super-simple. The page expiration dialog that grays out the browser screen is just a HTML DIV with ID DhtmlZOrderManagerLayerContainer , overlaying the useful content. If you want it to disa..
|
|
Machine learning is broadly split into two camps, statistical learning and non-statistical learning. The latter we’ve started to get a good picture of on this blog; we approached Perceptrons, decision trees, and neural networks from a non-statistical perspective. And generally “statistical” learning is just that, a perspective. Data is phrased in terms of independent and dependent variables, and statistical techniques are leveraged against ..
|
|
Machine learning is broadly split into two camps, statistical learning and non-statistical learning. The latter we’ve started to get a good picture of on this blog; we approached Perceptrons, decision trees, and neural networks from a non-statistical perspective. And generally “statistical” learning is just that, a perspective. Data is phrased in terms of independent and dependent variables, and statistical techniques are leveraged against ..
|
|
Machine learning is broadly split into two camps, statistical learning and non-statistical learning. The latter we’ve started to get a good picture of on this blog; we approached Perceptrons, decision trees, and neural networks from a non-statistical perspective. And generally “statistical” learning is just that, a perspective. Data is phrased in terms of independent and dependent variables, and statistical techniques are leveraged against ..
|
|
Midnattsloppet is a yearly night-time 10km race in Sweden, taking place in multiple cities including Stockholm. I’ve been signed up for months. It was yesterday. Let me tell you about it.
|
|
Note: this post was going to have pictures. Unfortunately my SD card is MIA. I’ll add them here when I can find it)
|
|
Whereas Matt appears to perhaps unintentionally relegate his condemnation to those producing poorly-formed written work for public consumption, I would take his advice one step further and apply it to every single written sentence, whether that fragment of prose is something so innocuous as a text message or important as a book. Regardless of the medium, there exists no suitable excuse for degrading the writers’ craft with poor work. Per..
|
|
Since I started programming in Go the concept and use of slices has been confusing. This is something completely new to me. They look like an array, and feel like an array, but they are much more than an array. I am constantly reading how slices are used quite a bit by Go programmers and I think it is finally time for me to understand what slices are all about.
|
|
When this article originally made its rounds , I saved it to Instapaper but put off reading the piece. With a title like “Working in the Shed”, I assumed Matt Gemmell had gone off the deep end and actually taken his Macbook out into a backyard shed in an extreme attempt at curbing his Twitter addiction. Having finally gotten around to reading his excellent article though, I’m here to say that Working in the Shed is much, much more than..
|
|
When I graduated from college, I thought I understood what it meant to develop software in the real world. It required process. It required troubleshooting. It required quality. However, to me, process meant waterfall. Troubleshooting meant trying a few things and then asking for help. Quality meant manual testing. Agile methods were not unheard of when I graduated in 2001. My professors noted that iterative development was better than wate..
|
|
As a part of my CS-319 Object-Oriented Software Engineering course, I developed a computer game with Nail Akıncı and Naime Nur Çadırcı, called Izuna Drop. It is a simple space shooter clone. As the design was more imporant in that course, the implementation was not very efficient, it was written on Java, and due to our bugs, it requried approximately 1 GB of memory. If you wonder what that looked like, it is avaialable on GitHub/Izuna.
|
|
Several months back I wrote about how we do higher level, long term planning within the Heroku Postgres team . If you haven’t read the previous article please start there. The exercise or rule of thirds is intended to be approximate prioritization and not a perfect science. Since that time I’m familiar with some teams both in and out of Heroku who have attempted this exercise with varying levels of success. We’ve now done this process 4 ....
|
|
Several months back I wrote about how we do higher level, long term planning within the Heroku Postgres team . If you haven’t read the previous article please start there. The exercise or rule of thirds is intended to be approximate prioritization and not a perfect science. Since that time I’m familiar with some teams both in and out of Heroku who have attempted this exercise with varying levels of success. We’ve now done this process 4 ....
|
|
I promised to write about Oracle 12c new features quite a while ago (when 12c got officially released), but I was actually on (a long) vacation then and so many cool 12c-related white-papers and blog entries started popping up so I took it easy for a while. I plan to be focusing on the less known low-level internal details anyway as you see from this blog entry. As far as I can remember, Oracle has been able to unnest regular subqueries s....
|
|
I promised to write about Oracle 12c new features quite a while ago (when 12c got officially released), but I was actually on (a long) vacation then and so many cool 12c-related white-papers and blog entries started popping up so I took it easy for a while. I plan to be focusing on the less known low-level internal details anyway as you see from this blog entry. As far as I can remember, Oracle has been able to unnest regular subqueries s....
|
|
Since I am writing lots of Vector Space implementations in Go, Python etc… I thought I would add another one in C#. This one is a little more verbose then either the Python or Go implementations. The verbosity is mostly due to not using any of the nice C# LINQ functionality which would really reduce the size. In any case here it is in case you are looking for a simple implementation of this useful class.
|
|
Jim Dalrymple on Apple's rumored September 10 iPhone event
-
www.loopinsight.com
-
12 years ago
-
eng
|
|
With the beta release of Instapaper’s newly overhauled and undeniably much more attractive website, we are finally beginning to see some of the great new features Marco sold Instapaper to Betaworks for. As I said in What Happened to Instapaper? , I’m very excited to see where the company takes Instapaper in the near future. A new website was a wonderful place to begin. And for those thinking Betaworks has sat on their hands for the las..
|
|
Can’t say I love the site, but his flow chart is excellent. That’s all there is to it, folks; it’s not too complicated. Permalink.
|
|
UPDATE – This is now actually available as a real Golang import with tests. Get it at https://github.com/boyter/golangvectorspace I have mentioned this before somewhere but one of the first things I usually attempt to implement in any programming language I want to play with is a vector space. Its my own personal FizzBuzz implementation. It usually covers everything I need to know in a language (imports, functions, string manipulation, ..
|