Hacker News new | past | comments | ask | show | jobs | submit | kurmouk's comments login

Could you possibly share the tools you use to obfuscate your traffic?


I did start with Yacy. First I would bould something thet search a list on Google or so and the just follow links forever. Finally I just found Yacy a P2P search. I did run it for a couple of years.

https://yacy.net/


I would guess Tor, I2P, Freenet, GNUNet.

But also configuring or avoiding certain other software: https://spyware.neocities.org/articles/index.html


`timestamptz` stores the same data I believe. Only that when using `timestamptz` instead of `timestamp`, the server will convert the returned value based on the server time zone configuration. Both datatypes have 8 bytes.


But normally you have a server between the user and the db, where you also prefer to keeps things as utc, while in memory. Then conversion to local time happens as the very last step in the presentation layer.

So unless you are using the sql result verbatim as presentation layer, is there any big benefit of this? On the contrary it seems like yet another moving part one could mess up and accidentally convert time where it shouldn’t?


It's not what it looks like. Selecting either timestamp or timestamptz gives you a string representation in the database's configured local time zone, which your backend's Postgres driver will convert to whatever date representation (like `Date` in NodeJS). But timestamp leaves the time zone out of the string. Your Postgres driver probably assumes UTC in that case, which is a problem if your database is set to PST.

First off, it's regrettable that Postgres drivers are parsing strings at all. That opens this can of worms.

Secondly, the DB locale setting is weird. It's advisable to always set your Postgres config to UTC locale to eliminate this nonsense, but that's not the default. So if your database is on PST, at least timestamptz will output strings that tell your code the correct time zone.

PST database:

select now() as timestamptz; -- 2022-11-09T14:41:12.110-08

select now() as timestamp; -- 2022-11-09T14:41:12.110

UTC database:

select now() as timestamptz; -- 2022-11-09T22:41:12.110Z, "Z" means UTC

select now() as timestamp; -- 2022-11-09T22:41:12.110

This isn't clearly explained in the official docs, btw. I think the only thing saving a lot of users is how AWS, GCP, etc all set their Postgres instances to UTC by default. Which makes this even more of a landmine if you ever use a DB not configured this way.

Another moral of the story is, every string representation of a datetime has a time zone, so it's better to be explicit about it. Something like "2022-11-09T14:41:12.110" is ambiguous. Put the "+00" or the "Z" if you mean UTC. Unix timestamps, on the other hand, are simply defined as a duration of time that has passed since the epoch and have no concept of time zone (don't even call them UTC).

tl;dr Just say no to `timestamp`


It converts the value either way. But with timestamp, the converted value gets the time zone truncated. It makes no sense.


But what about copyright laws of countries outside the US?


If the click comes from Facebook or Google, you won't need a subscription.


sadly not true for me.


[flagged]


To be fair, the way he surfs is impressively impervious to the threats we worry about bandaiding over every day, and doesn't subject him to non-free code which is an ideal state MANY of us would love to achieve practically.


You could add a list of all Facebook-owned IPs to your host file and resolve them to localhost.

You can get that list here: https://sizeof.cat/post/compile-a-list-of-all-facebook-owned...


It's too late for that. The OP is asking how to remove the data FB ALREADY have on them.


I personally only eat meat of animals I have myself killed.


A cryptocurrency that doesnt have the ability to go on a shared marked isn't reliable and is a true rupture between what institutions believe in and what the people share in common.


Thanks for sharing this. Especially for someone who's thinking about getting a data scientist job.


Join us for AI Startup School this June 16-17 in San Francisco!

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: