Kostya's Programming Language Implementation Benchmark

These data taken from https://github.com/kostya/benchmarks with some values removed, I only take the best result, and number of implementation is greater or equal to 3 (Comp, this could be the indicator how easy it's to implement). No further delay, here's the recap:

Implementation	Json		Brainfuck		Mandel		Base64		Matmul		Havlak		Comp	Avg Time	Avg RAM
Nim Clang 0.12.0	3.37	849.60	3.21	0.70	28.96	1.00	4.67	52.70	3.70	142.30	17.36	907.00	6	10.21	325.55
Rust 1.5.0-nightly	1.35	208.70	5.46	4.90	46.34	4.90	4.25	42.90	4.61	76.90			5	12.40	67.66
Crystal 0.10.0-9d59a34	2.63	1.20	6.97	1.30	48.62	1.30	2.21	85.80	3.83	72.20	15.87	398.10	6	13.36	93.32
Nim Gcc 0.12.0	3.49	903.50	4.52	0.60	50.45	0.90	4.57	52.70	3.76	152.70	17.51	889.10	6	14.05	333.25
Java 1.8.0_45	1.48	518.30	4.94	147.60	55.14	69.90			3.50	136.20			4	16.27	218.00
D 2.068.0	12.42	1,417.10	6.57	1.00	45.29	1.20	6.18	89.10	2.30	71.30	28.90	418.20	6	16.94	332.98
C++ 4.8.2	0.72	1.00	5.08	1.10	56.63	1.10	5.45	65.20			17.72	174.50	5	17.12	48.58
D Ldc 0.15.2-beta1	27.23	919.60	6.61	0.90	43.30	0.90	3.27	44.10	2.01	68.90	25.15	214.90	6	17.93	208.22
D Gdc 1.20.0-232-gc746732	0.34	226.70	8.87	1.00	70.12	1.50	3.16	45.20	2.33	73.00	31.79	197.60	6	19.44	90.83
Go 1.5	4.62	273.10	7.29	1.30	52.56	7.60	13.27	106.20	4.76	73.30	35.34	347.10	6	19.64	134.77
Javascript Node v5.0.0	2.80	829.90	8.74	15.00	92.65	15.80	4.38	628.40	5.88	85.90			5	22.89	315.00
Julia 0.3.11	10.27	2,353.90	9.25	59.00	94.33	56.90	14.76	380.20	31.34	375.80			5	31.99	645.16
Go Gcc 4.9.1	17.64	473.10	13.60	10.00	85.67	10.70	39.56	185.50	3.90	84.50	32.94	365.70	6	32.22	188.25
Python Pypy 4.0.0 with GCC 4.8.4	4.81	1,553.00	13.94	55.40	126.46	64.50	7.32	582.30	7.68	122.60	45.51	625.90	6	34.29	500.62
C# Mono 4.0.1	25.74	3,757.90	18.08	15.40	118.72	13.60	9.01	71.70	15.17	83.60	40.54	270.00	6	37.88	702.03
Javascript Jx 0.10.40	2.73	706.80	17.14	11.00	192.23	12.40	6.97	710.60	5.92	83.80			5	45.00	304.92
Scala 2.11.6	360.95	2,789.00	5.90	116.30	64.37	126.40	10.69	292.50	3.62	136.20	32.18	363.00	6	79.62	637.23
Ruby Jruby 1.7.20	21.98	2,761.10	87.05	124.10			12.65	514.90	416.12	582.40			4	134.45	995.63
Ruby 2.1.2p95	8.23	1,085.50	226.86	8.00			2.73	125.30	338.40	82.80			4	144.06	325.40
Ruby Jruby9K 9.0.0.0.pre2	16.53	2,050.50	160.15	297.20			12.16	530.60	467.59	608.30			4	164.11	871.65
Python3 3.4.3	5.92	1,037.80	480.78	5.50			8.16	47.50					3	164.95	363.60
Python 2.7.6	5.07	1,352.90	452.44	4.90			7.62	52.60	3.08	65.30	396.54	724.00	5	172.95	439.94
Perl 5.18.2	2.68	888.40					3.63	47.90	666.46	604.10			3	224.26	513.47
Ruby Rbx 2.2.10	67.13	4,681.00	472.08	45.00			4.29	30.70	591.70	325.00			4	283.80	1,270.43
Tcl 8.6			262.20	2.70			7.20	66.00	1,066.66	279.90			3	445.35	116.20

For now i'm still betting on Crystal (LLVM-based) and Golang. For next I think I'll try D, maybe with DLangIDE or CoEdit..

If Programming Language were Woman

A sexist joke..

PHP is your teenage sweetheart, the girl you first awkwardly fumbled around with that one summer. Just don't try and start a more serious relationship - this girl has serious issues.

Perl is PHP's older sister. She might be a bit old for you, but she was pretty popular back in the 90s. In a long-term relationship with Larry Wall, so her standards have dropped, and she's looking seriously fugly now. "I don't care what y'all say, I still love her!", he says. No-one else does.

Ruby is the cool kid of the scripting family. When you first saw her, she took your breath away with her beauty. She was fun, too. At the time she seemed a bit slow and ditzy - though she's matured a lot in the last few years.

Python is Ruby's more sensible sister. She's elegant, classy, and sophisticated. She's perhaps too perfect. Most guys are like "dude, how can you not like Python!?". Sure, you like Python. You just consider her the boring version of the edgy and romantic Ruby.

Java is a successful career woman. Some people who've worked with feel she owes her position less to ability and more to her knack for impressing the middle-management types. You might feel that she's the sensible type you should settle down with. Just prepare for years of "NO THAT DOESNT GO THERE GOD YOU ALWAYS USE THE WRONG TYPE INTERFACE AND YOU MISSED A SEMICOLON" nagging.

C++ is Java's cousin. Similar to Java in many ways, the main difference being she grew up in a more innocent time and doesn't believe in using protection. By "protection", I mean automatic memory management, of course. What did you think I meant?

C is C++'s mom. Mention her name to some old grey beard hackers and they're sure to reminisce with a twinkle in their eye.

Objective C is another member of the C family. She joined that weird church a while back, and won't date anyone outside of it.

Haskell, Clojure, Scheme and their friends are those hipster, artsy, intellectual girls you probably spent a blissful college summer with a few years ago. The first girls who really challenged you. Of course, it could never have become something more serious (you tell yourself). Though you'll always be left asking "what if?"

You might be put off C# due to her family's reputation. But they've gone legit, the last few years, they tell you. Once you're one of us, you're one of us, you hear? You need a database? Her brother MSSQL will hook you up. Need a place to stay? Heck, her daddy will even buy you your own mansion on Azure avenue. What's that, you're having second thoughts about all these overly friendly relatives? No, you can never leave. You're part of the family, now, ya hear?

Javascript - hey, wasn't that the girl you first kissed, way before even PHP came on the scene? I wonder what she's doing now. I hear her career's really taken off in the last few years. Would be cool to catch up some time, if only for old time's sake... (You catch sight of her, dressed head to toe in designer jQuery)... wow, somebody grew into a beautiful swan...e else does.

Reblogged from utest.

Let's add some more..

VB, C#'s little sister that easier to talk to, she was quite ugly back then (VB6).

Go, new kids on the block, quite mature for her age.

Delphi, the successful career woman that anyone forgotten or leave for family reasons, but deep down inside we know that we could achieve more with her.

Check the previous blogpost about if programming language were religion.

Techempower Framework Benchmark Round 11

The result of the infamous Techempower Framework Benchmark round 11 is out. As usual, the only important part is the "Data Updates" benchmark.

C++, Scala, Dart, Perl, Javascript, Clojure, Go, Ruby, PHP, Python, Lua are the top performers.

Here's the result when removing Platform (only MicroFramwork or FullStack):

State of JSON in SQLite and NoSQL

Another news for those who like JSON format, there's JSON1 extension for SQLite, this is a great news for those who only need embedded database for their app. Their functions are similar to PostgreSQL's JSON/JSONB functions. On other hand, there's already a lot of BSON solution in NoSQL world, such as the infamous MongoDB  (and TokuMX) RethinkDB, ArangoDB (SQL-like syntax), PouchDB (Javascript version of CouchDB),  SequoiaDB,  DjonDB, etc. For more information about those databases, see the video below.

SQLite 3 Tutorial

PostgreSQL 9.4's JSONB

What's new in MongoDB 3

Fractal Tree Index (TokuMX)

RethinkDB

ArangoDB

EDIT Hey, apparently there are also JSON data type support in MySQL 5.7.8 (2015-08-03, Release Candidate).

Query for Student Transcript (and Cumulative GPA)

There are some rules to generate transcript, some universities will use bet the highest grade, but some other will use get the latest grade. For example if we have this schema

CREATE TABLE schedules (
  id BIGSERIAL PRIMARY KEY,
  subject_id BIGINT FOREIGN KEY REFERENCES subjects(id),
  semester VARCHAR(5) -- YYYYS -- year and semester
);
CREATE TABLE enrollments (
  id BIGSERIAL PRIMARY KEY,
  student_id BIGINT FOREIGN KEY REFERENCES students(id),
  schedule_id BIGINT FOREIGN KEY REFERENCES schedules(id),
  grade VARCHAR(2) -- letter
);

If the university rule for transcript is get the highest score, the query is quite simple, first you'll need to make sure that grade is ordered in certain way on MAX agregate (for example: A+ > A > A- > B+ > ...) , then you'll need to do this query:

SELECT s.subject_id
  , MAX(e.grade)
FROM enrollments e
  JOIN schedules s
    ON e.schedule_id = s.id
WHERE e.student_id = ?
GROUP BY 1

If the university rules is get the latest score, first of all, you'll need to make sure that the semester is ordered (for example: 2015A < 2015B < 2015C < 2015A < ...), then you'll need to find the latest semester of each subject, for example:

SELECT s.subject_id
  , MAX(s.semester)
FROM enrollments e
  JOIN schedules s
    ON e.schedule_id = s.id
WHERE e.student_id = ?
GROUP BY 1

Then you'll need to fetch the credits that is the latest semester, for example:

SELECT s.subject_id
  , e.grade
FROM enrollments e
  JOIN schedules s
    ON e.schedule_id = s.id
WHERE e.student_id = ?
  AND (s.subject_id, s.semester) IN
    ( SELECT s.subject_id
        , MAX(s.semester)
      FROM enrollments e
        JOIN schedules s
          ON e.schedule_id = s.id
      WHERE e.student_id = ?
      GROUP BY 1
    )
GROUP BY 1

That way, it you'll only get the latest grade (as defined on the sub-query).

There are another alternative for this, you can use aggregate with OVER and PARTITION BY syntax, then compare the result with the aggregate to remove the previous scores, for example:

SELECT r.subject_id
  , r.grade
FROM (
  SELECT s.subject_id
    , e.grade
    , s.semester
    , MAX(s.semester) OVER (PARTITION BY s.subject_id) max_sem
  FROM enrollments e
    JOIN schedules s
      ON e.schedule_id = s.id
  WHERE e.student_id = ?) r
WHERE r.semester_id = r.max_sem

That's it, that's the way to get the transcript. Those queries can be modified to fetch the Cumulative GPA. just add one more join with subjects table to get the units/credits, then just calculate the SUM(subjects.unit * enrollments.num_grade) / SUM(subjects.unit)
You can also calculate the Cumulative GPA per semester by adding the semester for the partition/group by part. If you wonder, why do I write this post? because I have googled and not found any posts that write about this.

Go 1.5 Compile Speed

Go 1.5 has been released few days ago, today we will measure the compile speed of Go application. The source code for the measurement is around 36K lines (1.39 MB).

$ alias time
alias time='/usr/bin/time -f "\nCPU: %Us\tReal: %es\tRAM: %MKB"'

# Quad core i7 4700MQ, 16GB RAM, Linux 4.1.5 x86_64

# go version go1.3.3 linux/amd64
CPU: 4.39s Real: 2.54s RAM: 202944KB
CPU: 4.34s Real: 2.57s RAM: 202840KB
CPU: 4.47s Real: 2.60s RAM: 202844KB

# go version go1.4.2 linux/amd64
CPU: 4.23s Real: 2.39s RAM: 204656KB
CPU: 4.20s Real: 2.41s RAM: 204660KB
CPU: 4.71s Real: 2.81s RAM: 204624KB

# go version go1.5 linux/amd64
CPU: 17.09s Real: 6.35s RAM: 198416KB
CPU: 17.36s Real: 6.41s RAM: 198308KB
CPU: 17.35s Real: 6.21s RAM: 198000KB


The compile speed as stated on their mailing list, becomes significantly slower, I guess, I'll stick with 1.4 branch until 1.7 ready.

How to Install Go 1.5 on Windows 10

This tutorial will show you how to install Go 1.5 (but why?) on Windows 10. First of all you'll need to open your browser and go to http://golang.org

Click on the "Download Go" button, it will redirect to another page:

Click on the "Microsoft Windows" button, it will download an .msi file. After the download complete, run the file.

Click "Run": 

Click "Next", "Next", and so on until installed:

After finished, click the start menu, type "computer", right click on "This PC", choose "Properties":

Then choose "Advanced system settings", "Environment Variables..", click "New" on "user variables" panel.

Set the "GOPATH" to "%HOMEDRIVE%%HOMEPATH%\Documents\go" or anywhere else for your main go directory, something like this:

Click "OK" on all dialog, next, just open a "Command Prompt" window and create required directory, type 

go version
:: go version go1.5 windows/amd64
mkdir Documents\go\src
:: creating a directory, only required for the first time
cd Documents\go\src
:: change directory to %GOPATH%\src
notepad hello.go
:: edit a new source code

Create a new source code and type something like this:

package main
import `fmt`
func main() {
  fmt.Println( `Hello from Indonesia~ 1+1 =`, 1+1 )
}

Save, then go back to command prompt, type:

go run hello.go

A line will printed, and that's how you could install and run a example go program.

For more resources on how to learn programming in Go, please refer to the documentation (that can be viewed offline also, search for "GoDocServer" on the start menu.

There are some recommended IDE:

1. IntelliJ IDEA with go-lang-idea-plugins
2. LiteIDE (no-cost)
3. Atom with go-plus (no-cost)
4. Sublime Text with GoSublime
5. Wide (no-cost)
6. ZeusEdit
7. KomodoIDE
8. Eclipse PDE with GoClipse (no-cost)

That's it~ Btw how many "go" words in this article? 

Moving PostgreSQL Database to RAM

If you are software developer, sometimes you need to test your program faster. Normally the bottleneck of your program are in the database (writing to disk). You can increase the performance of your development/testing, by moving the database to the RAM if you have enough free RAM (>3GB). In this article, I will guide you to move your PostgreSQL database to RAM. First of all, you'll need to stop and disable the PostgreSQL, so the port won't conflict:

sudo systemctl stop postgresql
sudo systemctl disable postgresql

As we already know, /tmp folder on Linux mostly use tmpfs, that is a RAM file system. So if we create the database on the /tmp directory, it's on the RAM. What you'll need to do is create a script containing something like this:

#!/usr/bin/env bash
sudo killall postgres
# init directories
src=/tmp/data
sudo rm -rf $src
mkdir -p $src
sudo chown postgres:postgres $src
sudo su - postgres <<EOF
initdb --locale en_CA.UTF-8 -E UTF8 -D '/tmp/data'
sed -i -- 's/max_connections = 100/max_connections = 1024/' /tmp/data/postgresql.conf
sed -i -- 's/#logging_collector = off/logging_collector = on/' /tmp/data/postgresql.conf
sed -i -- "s/#log_directory = 'pg_log'/log_directory = '\/tmp'/" /tmp/data/postgresql.conf
sed -i -- "s/#log_file_mode = 0600/log_file_mode = 0644/" /tmp/data/postgresql.conf
sed -i -- "s/#log_min_duration_statement = -1/log_min_duration_statement = 0/" /tmp/data/postgresql.conf
sed -i -- "s/#log_error_verbosity = default/log_error_verbosity = verbose/" /tmp/data/postgresql.conf
sed -i -- "s/#log_statement = 'none'/log_statement = 'all'/" /tmp/data/postgresql.conf
# sed -i -- "s///" /tmp/data/postgresql.conf
postgres -D /tmp/data &
echo sleep 2 seconds..
sleep 2
createuser xxx
createdb xxx
psql -c 'GRANT ALL PRIVILEGES ON DATABASE xxx TO xxx;'
echo you can restore database now..
EOF

This script will erase all your database and create a new empty database on the RAM, that you can restore into later. This script will also create a log file that shows all queries that could help on the softwade development process. Lastly, to measure your PostgreSQL's data directory size in MB you can type this command:

$ sudo du -s -B 1M /tmp/data/
336     /tmp/data/

That's it, as a measurement, to restore a 137 MB database (about 300k records) in my PC normally it took about 17 seconds, when the database moved to RAM, it only took 5 seconds, so yes, it's a huge improvement.

Tilde terminal/console text editor, a vim alternative

I've been working with windows since 4th grade, and I know that learning vim is not easy, as there so many shortcuts to remember. I've read vimtutor 3 times, but still I could not remember the command for find-replace words (I must google it again and again, is it :%s/needle/gold/g or something)  For beginner I found that tilde is one of the best out there, you can install on ArchLinux by typing:

yaourt --needed --noconfirm -S --force tilde

The user interface much like DOS' edit (or Turbo C++), and the shortcut works as expected as in Windows' notepad (shift+arrow to highlight, ctrl+Z undo, ctrl+Y redo, ctrl+C to copy, ctrl+V to paste, ctrl+X to cut, ctrl+F to search, F3 to find next, ctrl+R to replace, ctrl+Q to quit). It also have basic syntax highlighting.

Another alternative would be diakonos (requires Ruby) and sanos editor (only one source code, requires C compiler).

Atom vs Brackets vs LightTable vs Zed

Today we will review about some text editor that seems to be gaining popularity lately, that are Atom (Github), Brackets (Adobe), LightTable and Zed. To install them on ArchLinux, just type:

yaourt --needed --noconfirm -S --force brackets-bin atom-editor-bin lighttable zed slap

First one is Atom 1.0.2-1, it uses 131MB of RAM at the first run, the Javascript autocomplete seems not working.

The second one is Brackets 1.3-1, it uses 75MB of RAM at the first run, the Javascript autocomplete works fine.

The third one is LightTable 0.7.2-1, it uses 70MB of RAM at the first run, the Javascript autocomplete not as good as Bracket's..

The fourth one is Zed 1.1.0-1, it uses 54MB of RAM at the first run, there are no built-in Javascript autocomplete.

Bonus: Slap is terminal-based text-editor that aims to be similar to SublimeText. It uses 101MB of RAM at the first run, and the key shortcut (PgUp, PgDn, Up, Down) seems not working well. LimeText (currently broken: lime-git) also tried to be SublimeText clone.

The winner for now would be Brackets..