The security/privacy blog.

Get ready for a new blog post, dark theme and a new domain name today!

Sorry, I love to announce stuff 😊

Get ready for the second comment on your 529th rant.
//Announcing stuff is pun.....

@Alice Too badly not :P. As someone who likes Telegram a lot you might not like it by the way 😆

@Alice Ah fair enough

👌

I am frantically checking rss....

@linuxxx your date generation for the site and the feed seem to be a bit off...

@ewpratten What do you mean?

@linuxxx your first post on the website is a later date than the second. I think it's the same on the rss as well.

@ewpratten Oh and it'll be hours until it's online haha

@ewpratten Uhm what exactly is off about that? Those dates are right haha

@ewpratten
dd-mm-yyyy
05-12-2017 is after
30-11-2017

But I think the posts should be displayed in a descending order @linuxxx

I'll just randomly throw this in: https://forum.xda-developers.com/an...
Might be of interest by @linuxxx

@Forside As for the way I load posts in the overview right now (I do it highly inefficient, I admit that one 😅 it's easier to do it ascending imo.

I'll have to rewrite that part anyways once I get more posts so that will be fixed in the not so distant future :)

As for the link, I've read about wireguard, yes!

It's ok, we love your announcements

New domain :O
It took me a week to memorize the old one, I even had to go through your rants to remember it last time :|

@gitpush The old one will remain as well!

@linuxxx great, please never delete or I will be lost :|

@linuxxx any room for an 'orderby' in the query? So that the most recent post are on the top of the page?
😇

@incognito I'm using a very bad method for loading the index 😅
Want to rewrite it but sql isn't a strong point of mine, would you have an idea on that one?

@linuxxx Can you show the source?

@linuxxx I'm going to assume you have a table called blog_posts in there you have the column id (created_at datetime is even better, but you can guess the latest post based on id) and message, (of course a few more but this will do)

The following query will get your blog_post in the order newest first :

SELECT
*
FROM
blog_posts
ORDERBY
# either created_at or id, or even
# (but unnecessary) both
ASC

Just hit me up if this is still unclear, I don't know your specific database setup 😉

Let me explain you that over Signal, it's too bad mention on here 😅