Posted by jpluimers on 2018/07/20
Looking at [WayBack] /dev/lawyer Open Source License Business Perception Report it seems that the [Archive.is] Apache License 2.0 causes the least pain and confusion for lawyers.
Via: [WayBack] Open Source License Business Perception Report: the pain and confusion of common open licenses, roughly quantified – This is why I Code – Google+
–jeroen
Posted in Development, Open Source, Software Development | Leave a Comment »
Posted by jpluimers on 2018/07/19
As I need both responsive resizing and zooming iframes one day:
–jeroen
Posted in CSS, Development, HTML, JavaScript/ECMAScript, JSFiddle, Scripting, Software Development, Web Development | Leave a Comment »
Posted by jpluimers on 2018/07/19
On [WayBack] Delphi Community Edition available: – Uwe Raabe – Google+, the links to the [WayBack] EULA, [WayBack] FAQ and [WayBack] Feature Matrix were shared.
In summary (read the G+ thread for more), the Delphi Community Edition is a web-installer of version 10.2.3 feature equivalent to the Delphi Professional Edition.
I think it is a good move to make Delphi more accessible to many more people.
A few restrictions apply, for instance there is also a C++ Builder Community Edition equivalent to the C++ Builder Professional edition, but you cannot install them on the same system at the time time.
Also, you cannot move around the command-line compiler to a different system (for instance a build-machine for Continuous Integration purposes).
The financial restriction that applies can be summarised as this: When the revenue you make during the year exceeds USD 5000 you have to stop using the Community Edition license.
Note that this is about revenue, not about income (which many define as “net of revenues and expenses”), and does not mention the revenue source, so watch this during the years you use the Community Edition.
Furthermore, Embarcadero indicates they collect information about your use of the Community Edition, but the [WayBack] privacy statement is not clear how.
All in all I hope this move attracts fresh people into the Delphi community.
The heise – the German flagship IT journal – likes it too: [WayBack] Delphi und C ++ Builder als Community Edition | heise Developer (via [WayBack] Some nice PR … Embarcadero-konfektioniert-Delphi-und-C-Builder-als-Community-Edition-4115563… – Roland Kossow – Google+)
Yes, Embarcadero is going after your employer if you register Delphi Community with a corporate email address.
See [WayBack] Embarcadero wants me to pay for a download. : legaladvice – Joseph Mitzen – Google+ and [WayBack] Embarcadero wants me to pay for a download. : legaladvice
–jeroen
Posted in Delphi, Development, Software Development | 2 Comments »
Posted by jpluimers on 2018/07/19
The testing was done with Firebird 2.5.x x86 on Windows 7 x64.
Where other relational database platforms have plenty of opportunities to generate sequences (see for instance the below links on Oracle and SQL Server), with Firebird you can use a WITH RECURSIVE query construct that normally is being used to manage tree structures ([WayBack] PkLab – Firebird: Tree data mangement with recursive CTE).
However, that uses query stack which has a depth limit of 1024 levels. When you reach the limit, Firebird gives you an error like this:
with
recursive
sequence(n) as (
-- When you select more than 1024 values, this error occurs:
-- Error while fetching data: Too many concurrent executions of the same request
select 0 -- start
from rdb$database
union all
select sequence.n + 1
from sequence
where sequence.n < 1023 -- finish
)
select sequence.n
from sequence
--where sequence.n in (24, 38)
order by sequence.n
It however is a pretty quick and CU bound solution: on my system ([WayBack] AMD A8-7600 @ 3.1 Ghz), it runs 1000 records within ~0.1 seconds.
In such a short time, it’s hard to see how the speed is bound, so I wanted to go for some orders of magnitude more. In ~0.1 seconds, the processor executes about 0.3 * 10^9 cycles generating 1000 numbers which is ~ 300-thousand cycles per number. That sounds like a lot of cycles for so few numbers. Would this become a better ratio for more numbers?
Posted in Database Development, Development, Firebird, IKEA hacks, OracleDB, SQL, SQL Server | Leave a Comment »
Posted by jpluimers on 2018/07/19
There is a lot of noise in the agility world. Choosing what practices your team does and why can be a tedious job. Each team is different and evolves over time, so you need to find the ones best fitting to your team and repeat that.
The [WayBack] Agile &: Core Agile Practices post has done a pre-selection of practices that could work well for your team. Try them, test them out and find which work well as best practice for your team.
Via: [WayBack] Core Agile Practices – Marjan Venema – Google+
–jeroen
Posted in Agile, Development, Software Development | Leave a Comment »
Posted by jpluimers on 2018/07/18
I was looking for a HTML pretty printer (…) but in Visual Studio code, that is called code formatting, which supports many languages out of the box (including HTML) without requiring extensions like Atom.io (see below).
The shortcuts are at [WayBack] How do you format code in Visual Studio Code (VSCode) – Stack Overflow.
For Mac OS X/OS X/MacOS they are (the second one only appears when you have a code selection):
- document:
Shift–Option–F- selection:
Command–KCommand–F
Posted in Development, Software Development, Visual Studio and tools, vscode Visual Studio Code | Leave a Comment »
Posted by jpluimers on 2018/07/18
Hopefully my blog will last longer than the original delphi.about.org articles.
Last year, I noticed yet another path into bit rot: [WayBack] The title reads “Source Code for the TColorButton Delphi Component”… I must be going blind because I can’t find it – Thomas Mueller (dummzeuch) – Google+
In this case, http://delphi.about.com/library/weekly/aa061104a.htm got redirected via http://delphi.about.com/od/vclusing/fl/Source-Code-for-the-TColorButton-Delphi-Component.htm to [WayBack] https://www.thoughtco.com/source-code-for-tcolorbutton-4077901 which is a copy of the original article failing to preserve the download links of the original source code.
It doesn’t help that the original source download at http://delphi.about.com/library/code/ncaa061104a.htm also redirects to https://www.thoughtco.com/delphi-programming-4133475 a generic catch all of [WayBack] Delphi Programming where http://delphi.about.com also redirects to.
In other words:
http://delphi.about.com got hi-jacked.
So here are some links to various forms of that source code:
–jeroen
Posted in Color (software development), Delphi, Development, Software Development | 2 Comments »
Posted by jpluimers on 2018/07/18
I was amazed the influence on how you compare dates would be a factor 1000 change in fetch times even though I wrote about date, time and timestamp conversions before in Source: Firebird – adjusting Delphi stored TDateTime (or OLE Automation date) fields that contain Dates, Times or DateTimes.
All queries were ran at 20170410.
Slow
select id, date '1899-12-30' + data.datadate as datestamp
from data
where 1=1
-- slow: prepared 0.066 sec; fetched 10.549 sec 250 rows
and date '1899-12-30' + data.datadate >= '2017-04-08' -- last 2 days
and date '1899-12-30' + data.datadate <= '2017-04-10' -- today
Fast
select id, date '1899-12-30' + data.datadate as datestamp
from data
where 1=1
-- fast: prepared 0.063 sec; fetched 0.009 sec 250 rows
and data.DATADATE >= date 'Now' - date '1899-12-30' - 2 -- last 2 days
and data.DATADATE <= date 'Now' - date '1899-12-30' -- today
Fast
select id, date '1899-12-30' + data.datadate as datestamp
from data
where 1=1
-- fast: prepared 0.070 sec; fetched 0.011 sec 250 rows
and data.DATADATE >= date '2017-04-10' - date '1899-12-30' - 2 -- last 2 days
and data.DATADATE <= date '2017-04-10' - date '1899-12-30' -- today
Fast
select id, date '1899-12-30' + data.datadate as datestamp
from data
where 1=1
-- fast: prepared 0.073 sec; fetched 0.009 sec 250 rows
and data.DATADATE >= date '2016-04-08' - date '1899-12-30' -- specific date range start
and data.DATADATE <= date '2016-04-10' - date '1899-12-30' -- specific date range end
The table looks like this:
CREATE TABLE "DATA" ( ID INTEGER NOT NULL, DATADATE DOUBLE PRECISION, DATATIME DOUBLE PRECISION ); CREATE ASC INDEX DATA_DATADATE ON "DATA" (DATADATE);
–jeroen
Posted in Database Development, Development, Firebird | Leave a Comment »
Posted by jpluimers on 2018/07/17
An interesting discussion sprouted from the bragging [WayBack] Did you know the IDE starts almost twice as fast in 10.2.2 as it did in 10.1? https://community.embarcadero.com/blogs/entry/new-in-10-2-2-welcome-page-… – David Millington – Google+.
I do not care very much about IDE start times (Visual Studio starts faster, others like Android Studio start slower than Delphi), more about productivity.
Which means loading projects, opening files and forms, switching projects, etcetera need to be fast and stable.
For me this is when on Delphi projects, I start about half a dozen copies of Delphi about 10 seconds apart (otherwise you get exceptions in any Galileo version), make some tea, then come back.
Each time an IDE crashes, I kill it, start a new one, switch to an existing one, load the projects I need and continue. On a full day working with Delphi, this happens about a dozen times a day.
After that I want to be productive.
Here is where I was so surprised by the great tip from Yusuf Zorlu
+Asbjørn Heid you should try to disable all “livebinding” packages + rename dclbindcomp250.bpl . If i opened a form before i had to wait 20 to 40 seconds … now it is superfast and opens forms under 5 seconds. I don’t need LiveBindings …
and the response by Asbjørn Heid
+Yusuf Zorlu Thank you! Holy cow that’s a difference! As you say, even our most complex forms are down to 4 seconds now.
I never use LiveBindings as they are way to convoluted, unstable and result in logic being in designers as opposed to tool-manageable code.
In addition, LiveBindings have never been really optimised since their inception in Delphi XE2.
This saves a lot of time!
So one day, I need to update Source: Delphi packages I have disabled by prefixing their description with an underscore (and why) and create a batch file with the various [WayBack] reg add commands modifying the package loads.
Related:
–jeroen
Posted in Conference Topics, Conferences, Delphi, Development, Event, Software Development | 2 Comments »
Posted by jpluimers on 2018/07/17
I totally forgot about [Archive.is] GExperts Help: Set Component Properties
The main reason is that I hardly use any live connections in Delphi applications any more for mainly two reasons:
But once every while I’m on a new site that has their own tool-chain installed and I see screens like this one:
The good thing is that it can bring certain components into a know state before compiling your application.
But this is a thing your CI environment should already do for you.
–jeroen
Posted in Delphi, Development, GExperts, Software Development | Leave a Comment »
The Wiert Corner - irregular stream of stuff 