SQL

4 Articles 0 Followers


Oh, CRUD! SQLite is not performant by default.

5 Jul 2023 4 minute read 0 comments Great White Snark

Today, I submitted a job application, in which I was required to list certain skills that I have. One of the advantages of interacting with people whom specialise in recuiting IT/development personel is that the person with whom I was dealing was sha...

When On-chain Analytics Meets Technical Indicators

29 Jun 2023 2 minute read 0 comments SocioCrypto

Introduction When it comes to analyzing and evaluating blockchain projects, there are two main approaches: technical analysis and fundamental analysis. Technical analysis involves studying historical price and trading volume data to identify patterns...

The Great Blind Adventure

7 Oct 2021 24 minute read 0 comments 7R!XxSec

    Introduction Welcome! My name is 7R!Xx and I invite you to partake alongside me in this valiant quest for knowledge. Possessing an intermediate grasp of the essential concepts involved in offensive security practices I set out several days ago t...

Oracle PL/SQL CASE-Statement Pitfall

14 Feb 2020 1 minute read 0 comments pSub

Some companies in finance and insurance use Oracle PL/SQL to implement business logic in their Oracle database. This is not everyone's cup of tea, because this language has some unexpected pitfalls. Today I stumbled upon a new pitfall. What might be...