cneu · HackerTrans

3 jaar geledendiscuss

The main reason why server-side stuff is slow is poor use of the database. Doing e.g. nested loops in a compiled language uses way less CPU than a scripting language, but it should be done in the DB in the first place.

cneu

4 jaar geledendiscuss

I used XMonad for about 1 year. Back at FVWM since ca. 8 years, but XMonad influenced the setup quite a bit. The WM is barely noticeable, it manages 2 full screen rxvt/ssh/screen windows, Firefox, Zoom and little else. Keybindings + integration with a self written Plan9 plumber-like tool (edit/modify selection, link to bug db, jira, ... based on selection contents) are the real productivity boosters.

cneu

5 jaar geledendiscuss

Some things are partially implemented:

  - type BOOLEAN is (FALSE, TRUE);
  - type VARCHAR2 is NEW CHAR_BASE;
  - generic collections
  - varargs

Unfortunately, they are only available for the PL/SQL team itself.

cneu

6 jaar geledendiscuss

Cool, good luck with your project!

cneu

6 jaar geledendiscuss

21 years ago, I joined a young team that wrote an ERP, with all business logic in PL/SQL. Customers are still amazed how fast these guys are going. 10 years ago I joined Oracle to work on APEX (created in 1999), which is a web app development and runtime environment, written in PL/SQL. We estimate that there are about 260K developers world-wide who are developing apps with APEX. All of their business logic is also on the server. Call me biased because I am working for the man, but my data points are completely different.

cneu

6 jaar geledendiscuss

Very true.

cneu

6 jaar geledendiscuss

That has been in 2017, when there was also this famous discussion between Hancock, Carlson and Shermer on the JRE. Shermer is the publisher of Skeptic Magazine, which you quoted. He recently tweeted this: https://twitter.com/michaelshermer/status/123755946996742144...

cneu

6 jaar geledendiscuss

Some of his claims are quite far-fetched and esoteric. However, even Michael Shermer, head of Skeptic magazine, recently admitted (https://twitter.com/michaelshermer/status/123755946996742144...) that there is some plausibility for the younger dryas impact hypothesis, which is currently an important part of Hancock's lost civilization claims. Such a major catastrophe would of course have a reset effect on any existing advanced civilization. This alone is not proof that there was one, of course.

cneu

6 jaar geledendiscuss

That's not entirely correct. A hard parse causes the optimizer to do bind variable peeking, i.e. it chooses the execution plan based on the bind variable value.

https://docs.oracle.com/cd/E11882_01/server.112/e41573/optim...

cneu

11 jaar geledendiscuss

Very nice proof of concept. Just a word of warning: In practice you want to sanitize your input. The code in "Serving static files" allows to break out of document-root with "..".

comments