SQLiteJDBC 5 row/s vs. CSV

Using SqliteJDBC v056, inserting around 3000 records into a SQlite table, no index, no trigger or any thing, just a plain table - and it took over 10 minutes to finish the job. Roughly 5 records per second.

Switched back to pure text file(CSV), 3000 records, it only took a couple of seconds.

Artificial stupidity in Oracle SQL Developer

Oracle SQL Developer automatically generates GROUP BY clause when it senses there's any aggregation functions in select clause. This might be helpful when writing a new SQL, but when it comes to debugging a huge complex PL/SQL, it is really annoying.

Fortunately there's an option to disable it, Tools > Preferences > Code Editor > Completion Insight > Autogenerate GROUP BY clause.

A template script for debuging PL/SQL procedures

When I get used to the convenience of Eclipse JDT, I can't stand for the awkwardness of Oracle PL/SQL and its IDE. Switching between today's technology and technology from 20 years ago is really a pain. So here is a script template to relief the pain a little bit.

SET serveroutput ON;
DECLARE
ai_instanceid NUMBER;
v_return curType;
rec recType;
BEGIN
ai_instanceid := 5000606;
v_return := plsql_pkg.getparameters(ai_instanceid);
LOOP
FETCH v_return INTO rec;
EXIT
WHEN v_return%notfound;
dbms_output.put_line(rec.portfolionm || ' ' || rec.templateid || ' ' || rec.statementenddt);
END LOOP;
CLOSE v_return;
END;