Posted by jpluimers on 2016/09/28
Common table expressions are awesome. They work in at least Oracle and SQL Server.
You cannot nest them, but you can use them consecutively. Thanks spender for explaining that:
WITH
x AS
(
SELECT * FROM MyTable
),
y AS
(
SELECT * FROM x
)
SELECT * FROM y
–jeroen
via: sql – Can you create nested WITH clauses for Common Table Expressions? – Stack Overflow.
Posted in Database Development, Development, OracleDB, SQL Server, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014 | Leave a Comment »
Posted by jpluimers on 2016/09/28
A few pieces of Delphi compiler history:
Most notably, the Object Pascal/Delphi compiler is written in mostly C with a smattering of C++, the editor kernel (sans display rendering) and debugger engine (process control/symbol table management) were written in C++. All of which I’ve worked on throughout my 24+ years on that team.
The 16bit compiler was written in pure assembler. The current compiler is written in C. It was derived from an Amiga 68000 Turbo Pascal compatible compiler. It’s never been written in Object Pascal.
That being said, there was an effort several years ago to completely rework/re-architect the compiler. That was done in OP. It just barely got to the “hello world” stage before it was set aside.
Source: The Oracle at Delphi: Set in my ways [WayBack]
–jeroen
Posted in Delphi, Development, History, Software Development | 1 Comment »
Posted by jpluimers on 2016/09/27
On my research list:
Slow pages lose users: research from Bing and Google indicates that delays as small as half a second can impact business metrics. To build fast sites, developers need powerful tools to analyze the …
Source: Analyzing website performance with the Windows Performance Toolkit | Microsoft Edge Dev Blog
via:
–jeroen
Posted in .NET, Delphi, Development, Software Development | Leave a Comment »
Posted by jpluimers on 2016/09/27
I recently learned that you can do cross database queries in Oracle using database links.
You need to prefix your objects with the right schema/owner (for instance dbo.) and suffix with an @ sign followed by the database link name.
This query finds all configured database links:
select * from all_db_links;
–jeroen
via: Ask Tom “database link”.
Posted in Database Development, Development, OracleDB | Leave a Comment »
Posted by jpluimers on 2016/09/26
Interesting reads:
–jeroen
via http://applehelpwriter.com/2016/08/29/discovering-how-dropbox-hacks-your-mac/ – Joe C. Hecht – Google+ [WayBack]
Posted in DropBox, SocialMedia | Leave a Comment »
Posted by jpluimers on 2016/09/26
“Heittps enabled.” and working for most parts: Verschlüsselung: heise online und Heise-Onlinedienste per HTTPS erreichbar heise.de [WayBack]
A hard part in getting there is fixing “Mixed Content” errors. Report them at https://www.heise.de/newsticker/meldung/Verschluesselung-heise-online-und-Heise-Onlinedienste-per-HTTPS-erreichbar-3331421.html
Earlier this Dutch tech site did the same: Tweakers stapt over op https – Waarom https? – Achtergrond – Tweakers [WayBack] and faced similar “Mixed Content” fixing challenges [WayBack].
–jeroen
Source: Na endlich. – Kristian Köhntopp – Google+
Posted in https, Security | Leave a Comment »
Posted by jpluimers on 2016/09/26
Various steps showing How to Remove Duplicates & Customize the “Open With” Menu in Mac OS X « Mac Tips
–jeroen
Posted in Apple, Mac, Mac OS X / OS X / MacOS, MacBook, MacBook Retina, MacBook-Air, MacBook-Pro, MacMini, OS X 10.10 Yosemite, OS X 10.11 El Capitan, OS X 10.9 Mavericks, Power User | Leave a Comment »
Posted by jpluimers on 2016/09/26
Awesome vim cheat sheet for your consideration. Download http://vimcheatsheet.com
You can either
–jeroen
via:
Posted in *nix, *nix-tools, Linux, openSuSE, Power User, SuSE Linux | Leave a Comment »
Posted by jpluimers on 2016/09/23
HTTPSWatch tracks the HTTPS support of prominent websites.
Source: HTTPSWatch | Global
Like on the right side.
https isn’t everywhere yet, but growing.
–jeroen
Posted in https, Power User, Security | Leave a Comment »
Posted by jpluimers on 2016/09/23
Steps to disable the security questions in Yahoo:
Disable security questions – yahoo thinks they’re a bad idea anyway
–jeroen
Posted in Power User, Security | Leave a Comment »
The Wiert Corner - irregular stream of stuff 