- Feature Articles
- CodeSOD
- Error'd
- Forums
-
Other Articles
- Random Article
- Other Series
- Alex's Soapbox
- Announcements
- Best of…
- Best of Email
- Best of the Sidebar
- Bring Your Own Code
- Coded Smorgasbord
- Mandatory Fun Day
- Off Topic
- Representative Line
- News Roundup
- Editor's Soapbox
- Software on the Rocks
- Souvenir Potpourri
- Sponsor Post
- Tales from the Interview
- The Daily WTF: Live
- Virtudyne
Admin
[This comment intentionally left blank]
Admin
So the real challenge of national service is not to kill your supervisor?
Captcha - vindico, a vindictive directive.
Admin
But they could use oracle to crunch and massage the data into the correct report format, export it to a flat file as fixed length fields (e.g.: one field consisting of <line-length> columns and one field consisting of CRLF), and have the flat file then "processed" into the final report.
It'd still be within the imposed rules.
Admin
Admin
Many? Like about 10 of roughly 50.
Admin
Admin
I thought Nordic countries were moderately competent.
Admin
Obviously, TRWTF is... hey! They didn't mention the programming language this was written in! What a rip off.
Admin
Surely that's cheap: only 50€/page ???
Admin
Apparently I changed some numbers in one of my edits but didn't redo my math. Corrected for accuracy and basic arithmetic.
Admin
No direct access to the database is a good idea.
And there IS some SQL being used in the PL/SQL routine. What you might want is to modify or add a new PL/SQL routine to give you the data you want in its final form, but it isn't a total WTF to not allow direct SQL calls to a database that can have sensitive data on it that you don't wish to allow accses to.
Admin
Admin
Admin
I hoped the supervisor would choke on dust and die as he closed the binder...
Admin
Yes but that would be the smart thing to do, whereas only stupid people and/or drug addicts choose siviilipalvelus. (There's a myth that gay guys do as well but it's pretty obvious they all choose the sausage fest that is Finnish Defense Force.)
Admin
Sampo asked the wrong questions. If instead of finding out how the report was generated, he tried to find out how the data was used, I'm pretty sure he could have saved the finnish taxpayer EUR 50,000 per year. No specifications? Probably shelf-ware.
Admin
TRWTF is finding out that the pension payments were homosexual.
そして、サンポさんが散歩をしました
Admin
FAS? Somewhat surprisingly, I don't find any original information about FAS as such on the net. http://www.cse.tkk.fi/fi/opinnot/T-106.5800/2009_Autumn-History_of_Programming_Languages/slides/suomi.pdf contains some information (in Finnish, but the code snippet examples might be interesting anyway). As important as that programming language was in government data processing in Finland in the 70s and 80s, one would think somebody would out of historical interest put a manual or something up on the net...
I used FAS myself when doing my siviilipalvelus in 1983 at the City of Oulu's Department of Health.
Admin
Admin
Well, SQL is a standard since 1986, 10 years after the manual.
Anyway technically using SQL is not direct acces to database.
Admin
Honest to Peat, I thought he was going to discover that the ultimate source of the data was... the output of last year's run.
Admin
Admin
I feel it reasonably safe to assume that this came true.
Admin
You know, that's one of those rare situations where XML is usefull. Of course, he'd do better with JSON, CSV, or any other format that is simple, but even XML is better than fixed lenght fields.
Admin
In Finnish folklore, the Sampo is a mythical device that brings the bearer good fortune. According to one interpretation, it is a millstone that can mill salt, flour, and gold from thin air.
I think the Sampo in this story is most likely going to be milling a lot of spaghetti and bile, though.
Admin
Admin
What is much more important that my tongue-in-cheek pedantry is that highly variable and proprietary nature of database formats is not true any longer. SQL was meant and to larger extent is a solution to this problem. It is an open standard: it is neither highly variable (slightly variable because of extensions to standard etc.) nor proprietary.
Admin
If they changed the print routine to print a blank page after each page of text, they could reduce the cost per page to 25 Euro. If he did that, he should get a bonus.
Admin
The real WTF is idiots that don't update their programming standards when the times change.
Admin
WTF is this article showing on this site.
Admin
Even IF one would want to use a flat file, I'd say it's a better idea to import the flat file into a local(host), temporary database, do all the stuff on it, and then remove the database...
Admin
That's why they give the task to a conscientious objector - keeps down the murder rate.
Admin
Admin
that's not the point, the point is that they don't want you to have any access to the database at all, not even indirect.
The database provides you with the data you need to know and that is what you get access to.
Of course they could get the data received from the master database, import it into SQLite or whatever then process queries using that, but given they have had programs in place to handle the flat files before SQLite came into existence, assuming they work efficiently enough, there is no reason not to use them.
Admin
This reminds me of the European Union "Celex" database. At some point it was decided that all legal documents produced by the EU must be in a database. The French insisted that only their technology be used, so it was a Groupe Bull setup (basically, all the cast offs from Honeywell*). My company wanted to produce a searchable database of this information on CD-ROM, and updated quarterly. The data could only be provided by the EU on reels of 1/2" mag tape, despite this being 1996 when more compact and reliable tape formats were the norm. We read the data into an otherwise redundant Vax, since it was the only machine we had with a reel to reel mag tape reader. Then we had to parse the data which was in some ISO standard format. Except the French engineers had modified the format, and if the modifications were ever documented then that documentation had been lost. That took some reverse engineering ...
Admin
Admin
You surely mean a bereuamancer.
Admin
The true WTF is that I couldn't finish the article because of all the damn unicorns.
yes, finish.
captcha: saluto. i need a drinko
Admin
Admin
Admin
Last time I looked, all RDBM systems worth their salt also included rather fine-grained controls on what kind of operations and to which data any sql user/role can have access to. GRANT command, anyone? Heck, if you want to really separate things you could even set up another database which only has the needed data, possibly pre-formatted for the spesific applications' needs... like a previous poster suggested with SQLite, actually.
So, if the system needed a read-only access to a specific subset of the data, asking if you "can run unfettered SQL queries" is also completely unnecessary and off topic. Anyway, as a Finnish taxpayer, I think I'm already somewhat cynically desensitized to the mess that is the IT in our public sector. Coding standards from 1976... I'd like to say "holy shit", but actually, it seems to be par for the course.
Admin
yoooneekornz!!
Admin
I actually see this as a rather admirable (for 1976) attempt to avoid vendor lock-in, which was a BIG problem with databases at the time. They were essentially all proprietary. Flat files were about the only thing you could guarantee you could interchange, or read in the future if your software vendor went out of business.
In other words, the problem isn't that the original requirement was unreasonable, it's that they haven't updated it in a reasonable amount of time.
Admin
Iusto - I used to care.
Admin
Brilant.
I am also disapointed they have not pictured a wooden table somewhere in the process.
Admin
Wow. These finnish people are funny. No wondering that finland is now bankrupt.
Admin
Admin
Admin
The Central Bureaucracy would be proud. He must be Bureaucrat Grade 19, at least.
Admin