Details
-
Aboutsome random dude on the internet
-
SkillsC, C++, C#, Visual Studio, somewhat confident with Linux, currently glueing together a programming language
-
LocationGermany
-
Github
Joined devRant on 2/28/2017
Join devRant
Do all the things like
++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatar
Sign Up
Pipeless API
From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple API
Learn More
-
The new figma plugins are actually insane lol, some examples:
- font scale, always struggled with having to apply the formula myself or finding the right one so it scales nicely
- image tracer, that plugin replaces adobe illustrator for me, since I only used it to convert pixels to vector images
- removebg, 99% of what I pulled photoshop up for
still have to test them some more, but so far it literally replaces all that adobe crap for me.
https://figma.com/c/plugin/...
https://figma.com/c/plugin/...
https://figma.com/c/plugin/...
6 -
Found this guy by accident while searching for some render, mind blowing what you can do in excel.
https://youtube.com/watch/...
https://youtube.com/watch/...
https://youtube.com/watch/...
26 -
Today, for fun, I wrote prime number generation upto 1000 using pure single MySQL query.
No already created tables, no procedures, no variables. Just pure SQL using derived tables.
So does this mean that pure SQL statements do not have the halting problem?
Putting an EXPLAIN over the query I could see how MySQL guessed that the total number of calculations would be 1000*1000 even before executing the query in itself and this is amazing ♥️
I have attached a screenshot of the query and if you are curious, I have also left below the plain text.
PS this was a SQL problem in Hackerrank.
MySQL query:
select group_concat(primeNumber SEPARATOR '&') from
(select numberTable.number as primeNumber from
(select cast((concat(tens, units, hundreds)+1) as UNSIGNED) as number from
(select 0 as units union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) unitsTable,
(select 0 as tens union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) tensTable,
(select 0 as hundreds union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) hundredsTable order by number) numberTable
inner join
(select cast((concat(tens, units, hundreds)+1) as UNSIGNED) as divisor from
(select 0 as units union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) unitsTable,
(select 0 as tens union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) tensTable,
(select 0 as hundreds union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 union select 7 union select 8 union select 9) hundredsTable order by divisor) divisorTable
on (divisorTable.divisor<=numberTable.number and divisorTable.divisor!=1)
where numberTable.number%divisorTable.divisor=0
group by numberTable.number having count(*)<=1 order by numberTable.number) resultTable;
9 -
I just found this `Cyberpunk` VS Code theme and I'm a fan 🤩
https://marketplace.visualstudio.com/...
6
