git diff --no-prefix @~
Via various sources:
- The
@~syntax to get the previous commit - The
--no-prefixto make the patch svn compatible
–jeroen
Archive for 2020
getting a svn compatible patch diff from the latest commit in a git branch
Posted by jpluimers on 2020/09/03
Posted in Development, DVCS - Distributed Version Control, git, Software Development, Source Code Management, Subversion/SVN | Leave a Comment »
Interesting: SQL Server FileStream and FileTable
Posted by jpluimers on 2020/09/03
Some links for my research (when writing this a few years back, I had not done a lot of SQL Server BLOB work for a while, so I missed a lot of interesting progress).
As of SQL Server 2008, one can use FileStream, which SQL Server installs on an NTFS file system local to the SQL Server instance, but is accessible over the SQL Server API. It benefits from a lot of SQL Server features (including transactional and backup related).
As of SQL Server 2012, FileTable has extended FileStream, which makes it even easier to access the files from Windows applications.
Over the years, FileStream and FileTable has improved a lot.
Some links to get a feel:
- https://social.msdn.microsoft.com/Forums/sqlserver/en-US/b1e33aab-73e8-4f05-bc70-544dccea1c0d/storing-documents-in-sql-database?forum=databasedesign&prof=required
- https://docs.microsoft.com/en-us/sql/relational-databases/blob/filestream-sql-server?view=sql-server-2017
- https://docs.microsoft.com/en-us/sql/relational-databases/blob/filetables-sql-server?view=sql-server-2017
- https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
- https://docs.microsoft.com/en-us/sql/relational-databases/blob/compare-options-for-storing-blobs-sql-server?view=sql-server-2017
- https://stackoverflow.com/questions/2863559/any-succesful-document-management-sytem-application-using-documents-intensively
- http://www.filestreamsystems.co.uk/backup-filestream-edms.htm
- https://kohera.be/nl/blog/sql-server-nl/overview-working-files-sql-server/
- https://docs.microsoft.com/en-us/sql/relational-databases/blob/create-a-filestream-enabled-database?view=sql-server-2017
- https://docs.microsoft.com/en-us/sql/relational-databases/blob/create-a-table-for-storing-filestream-data?view=sql-server-2017
- http://dba-presents.com/index.php/databases/sql-server/64-filestream-performance-test
- https://docs.microsoft.com/en-us/sql/relational-databases/blob/filestream-compatibility-with-other-sql-server-features?view=sql-server-2017
–jeroen
Share this:
Posted in Database Development, Development, SQL Server, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014 | Leave a Comment »
Mike Versteeg tried getting Hi-DPI to work in Delphi 10.2
Posted by jpluimers on 2020/09/03
Wondering how far Mike Versteeg has gotten in the mean time with the newer versions of Delphi that have come up: [WayBack] I’m having a go at multi monitor high DPI support for my styled 64 bit VCL app, which is still not supported in 10.2. Using Scaled and ScaleBy I can com… – Mike Versteeg – Google+
–jeroen
Share this:
Posted in Delphi, Development, Software Development | Leave a Comment »
undo – Can I delete a git commit but keep the changes – Stack Overflow
Posted by jpluimers on 2020/09/02
I wanted to undo a commit, but forgot how to do that.
[WayBack] undo – Can I delete a git commit but keep the changes – Stack Overflow mentions to use
git reset HEAD^
However, on Windows, the ^ caret is an escape character, so there you have to use a ~ tilde instead:
git reset HEAD~
The last one is used in [WayBack] Git – Reset Demystified, and shorthand for
git reset --mixed HEAD~
The differences between --soft, --mixed and --hard is even better explained in [WayBack] The difference between git reset –mixed, –soft and –hard. From http://stackoverflow.com/questions/3528245/whats-the-difference-between-git-reset-mixed-soft-and-hard · GitHub.
In short:
--softkeeps the changes of the undone commit in theindex(or staging area)--mixed(default) keeps the changes of the undone commit in the working directory--harddeletes the changes
–jeroen
Share this:
Posted in Development, DVCS - Distributed Version Control, git, Software Development, Source Code Management | Leave a Comment »
Cynefin framework – Wikipedia
Posted by jpluimers on 2020/09/02
A long while ago, Kristian Köhntopp explained most of the categories in [WayBack] Cynefin framework – Wikipedia using very simple terms, which I have translated like below.
- Specifications work if you are operating in in “Obvious”. Then all constraints are discoverable and known.
- In “Disorder” (the middle, or “Explorative”) that is not possible and you have to iterate to .
- In “Complicated” the constraints are, after all, static.
- In “Complex”, the active constraints depend on past decisions made.
- In “Chaotic”, there is no plan and you have to try around wild and see what’s going on. This is the world of venture capital to finance start-ups.
I like the bigger picture below a lot better, as it at least names the “Disorder” middle section which is not in the summary diagram on the right. “Disorder” is exactly the place you want to get and stay out of.
All pictures from WikiMedia.
Via: [WayBack] “Kitzel mich!” “Kitzel mich, aber nur bis ich Stop rufe!” “Kitzel mich, aber nur bis ich Stop rufe! Und unter der Bettdecke bin ich sicher!” “Kitzel m… – Kristian Köhntopp – Google+
(“Tickle Me!” “Tickle me, but only until I stop calling!” “Tickle me, but only until I call Stop! And under the blanket, I’m safe!” “Tickle me, but only until I call Stop! And under the blanket, I’m safe! And pulling away the blanket is forbidden!” The son is bound to become a software developer.)
“Obvious” is what a lot of (government) organisations think you and they are in when applying regulations. In reality, “Complex” likely applies best.
–jeroen
Share this:
Posted in Development, Software Development | Leave a Comment »
Delphi consensus: interface implementing classes expose methods at private or protected level.
Posted by jpluimers on 2020/09/02
Interesting consensus at which is very similar to my experience: [WayBack] I’ve inherited a project and the developer uses lots of interfaces (All good here!). Then when they develop the interfaced classes, the methods from th… – John Kouraklis – Google+
Some go even further and even declare the classes in implementation sections, but for me that gives too much RTTI hassle:
Private types (types in the implementation section of units) do not get qualified names.
via: Delphi: TRttiContext.GetType versus TRttiContext.GetTypes is not about singular versus plural…
–jeroen
Share this:
Posted in Delphi, Development, Software Development | Leave a Comment »
Some banking apps are not so privacy friendly
Posted by jpluimers on 2020/09/01
Some baking apps want a lot of permissions, including privacy sensitive ones.
Maybe they should split themselves in a small, non-intrusive app that allows payment confirmation, and fatter (hopefully less intrusive than now) app for account management.
For now, I try to avoid these apps as they are single points of failures.
ING had a great TAN code system on paper. It hardly had any side-channel attack vectors, and by putting some copies in geographically distinct locations, you had good and safe back-ups too.
It looks like the successor is a single point of failure: only one scanner device per account holder is possible.
Let’s see what the future will bring.
Related:
- [WayBack] Roderick Gadellaa on Twitter: “@ingnl Ik begrijp dat jullie gaan stoppen met TAN codes. Juich ik toe, 2FA met sms is behoorlijk lek. Maar nu moet ik jullie app gaan gebruiken. Ik werp 1 blik op de permissions die jullie app wil en denk: Neen.… “
- [WayBack] ING Nederland on Twitter: “er blijft zeker een alternatief bestaan, meer hierover is via deze link te lezen: https://t.co/gSCwYUG2JM ^Sabrina… “
- Bevestigen met de ING scanner – ING – Mobiel en internetbankieren (cannot be archived, see [WayBack/Archive.is]
Opdrachten bevestigen in Mijn ING verandert. De TAN-code stopt. Mobiel bevestigen wordt de standaard. Heb je geen smartphone of tablet? Dan ga je een ING Scanner gebruiken.
- [WayBack] “Apps like Google Authenticator or 1Password are much more convenient and secure” One problem that I start to see more often is that a lot of governmen… – Roderick Gadellaa – Google+
- [WayBack] Major SMS security lapse is a reminder to use authenticator apps instead – The Verge: 26 million customer texts were exposed
–jeroen
Share this:
Posted in LifeHacker, Power User, Security | Leave a Comment »
hash – Why is Git not considered a “block chain”? – Stack Overflow
Posted by jpluimers on 2020/09/01
Still an interesting question: [WayBack] hash – Why is Git not considered a “block chain”? – Stack Overflow.
With my limited knowledge of both, I think git is a Merkle tree without both a proof of work and consensus system. That would make it the chain part of block chain, and the without bits the block.
How wrong am I?
It seems I still have a lot to learn about Merkle tree related stuff, so on my research list:
- [WayBack] Merkle Tree | Brilliant Math & Science Wiki
- InterPlanetary File System – Wikipedia IPFS is a peer-to-peer distributed file system that seeks to connect all computing devices with the same system of files. In some ways, IPFS is similar to the World Wide Web, but IPFS could be seen as a single BitTorrent swarm, exchanging objects within one Git repository. In other words, IPFS provides a high-throughput, content-addressed block storage model, with content-addressed hyperlinks.[11] This forms a generalized Merkle directed acyclic graph (DAG). IPFS combines a distributed hash table, an incentivized block exchange, and a self-certifying namespace. IPFS has no single point of failure, and nodes do not need to trust each other, except for every node they are connected to.[12]Distributed Content Delivery saves bandwidth and prevents DDoS attacks, which HTTP struggles with.[5]
- [WayBack] Is Git a Block Chain? | Hacker News
- Need to decide which of these videos explain the Merkel tree best:
- What is the merkle tree in Bitcoin?
- Introduction Oneway ,SHA256, and Merkle Tree – Merkle Tree
- Programmer explains Merkle Tree | Blockchain technology
- Blockchain Basics Explained – Hashes with Mining and Merkle trees
- How secure is 256 bit security?
- Ever wonder how Bitcoin (and other cryptocurrencies) actually work?
–jeroen
Share this:
Posted in Development, DVCS - Distributed Version Control, git, LifeHacker, Power User, Software Development, Source Code Management | Leave a Comment »
The iron triangle of planning | Atlassian
Posted by jpluimers on 2020/09/01
The traditional iron triangle of planning is turned up-side down when being agile: [WayBack] The iron triangle of planning | Atlassian.
On the left, the traditional triangle, on the right the agile one.
Via: [WayBack] The iron triangle of planning The Agile Coach – Marjan Venema – Google+
–jeroen
Share this:
Posted in Agile, Development, Software Development | Leave a Comment »
HOW TO: Configure Shared Diagnostic Partition on VMware ESX host | vStrong.info
Posted by jpluimers on 2020/08/31
Interesting for vSphere clusters: [WayBack] HOW TO: Configure Shared Diagnostic Partition on VMware ESX host | vStrong.info
–jeroen
Share this:
Posted in Power User, Virtualization, VMware, VMware ESXi | Leave a Comment »
The Wiert Corner - irregular stream of stuff 