HNHacker News
TopNewBestAskShowJobs

agopaul

366 karma · joined September 7, 2012

Co-Founder at Redokun (https://redokun.com)

Gmail: paul.ago Twitter: @ago_paul

submissionscomments
agopaul··on How Carders Can Use EBay as a Virtual ATM
> 3. Credit card number was pasted instead of typed.

This wouldn't probably work. You have to consider that some browsers (eg. Chrome) save the CC data, so you don't have to type them. This validation step would block legit customers from buying what they want.

Also, bots can run on real browsers simulating real humans using infected PCs as proxy so that their IP addresses result on the same country/state of the real customer.

agopaul··on PostgreSQL on the Command Line
In MySQL you append \G at the end of the query instead of ; to get the same result as \x.

Weird I know, but it works. Still psql is a superior client IMHO.

agopaul··on MariaDB 10.1 can do 1M queries per second
Mechanical or flash storage? Compression could give advantage on mechanical disks due to the reduced time spent on seeking, but I'm curious to know how they perform on SSD for which seek time is reduced to a minimum if not 0.
agopaul··on Transit: JSON Data Interchange Format
So it's basically a set of libraries used to marshal/unmarshal objects without using a schema or can it also be used as an RPC library?
agopaul··on One founder, zero staff, making $1.2M in monthly recurring revenue
Agreed. But in the other hand, this also gives a false image of the startup world, to the people unfamiliar with it, where the vast majority of this kind of startup fail.

Stil a great piece to read, though. It reminds me of the Plenty Of Fish story: 1/2 guys team and a 7 figures revenue

agopaul··on One founder, zero staff, making $1.2M in monthly recurring revenue
+1 I wonder how many people just harvest whois info for email addresses
agopaul··on Guide to Logging
I'm impressed by how only a few people mentioned what I think it's the main point of application/system logging: debugging problems. Especially in small projects when you don't work 'at scale and you don't have metrics.

Am I the only one that stash GBs of low-level log messages in order to diagnose bugs that occurred in the past?

agopaul··on Ask HN: What are your opinions and experiences coding on a 13“ or 15” laptop?
He mentioned that he does iOS development, so Macs are the only way to go
agopaul··on The Dukes: 7 years of Russian cyber-espionage
I ordered this a few days ago after seeing plenty of good reviews: https://www.goodreads.com/book/show/18465875-countdown-to-ze...

It covers the Stuxnet worm, which was allegedly built by the US and the Israeli government to target the Iranian nuclear program.

agopaul··on Ask HN: How do software consultants deal with maintenance?
This is very interesting and I'm convinced. But the problem the companies I worked for in the past faced is that sometimes the client has a tight budget and have to share it with other projects too. So they need to have a precise view of the cost of the project not only short-term (initial development) but also long-term (maintenance).

The solution would be finding the clients willing to go down the road of non-FB projects, but hey, sometimes the market is what it is.

agopaul··on Migrating bajillions of database records at Stripe
They used Mongo, but I'm not sure this is still the case. I guess they use multiple datastores across the company services.

I thought the same thing, how many can they be? Even considering Stripe operates globally, I'd say it's a number in the tens of millions.

Edit: lots of typos

agopaul··on Phoenix 1.0
@oomkiller: again, so interesting, especially when used in combination with RethinkDB.

I'll have a look at the slides

agopaul··on Phoenix 1.0
This is very interesting as Phoenix could become the next Rails. I loved Rails and ruby, for the most part, but ruby MRI still lack 'Native Threading', and Jruby isn't viable if you are using external C extensions.

To overcome the lack, I've used Resque (or beanstalkd in PHP, which has the exact same problem) as a background job manager, but then I had to write my own layer and rely on the database to handle the 'job' result.

Which parts of the framework leverage the concurrency model, other than the routing/request handling part?

agopaul··on Ask HN: Do you use an antivirus?
Even more interesting: are you using an AV on MacOSX?
agopaul··on Windows 10 users are being banned from torrent sites
Yes it is, I just finished it.

Although his writing style isn't always consistent, the book is totally worth reading just to get a clue on how 'cyber criminals' (used to) operate on a global scale. I said 'used to' because the facts narrated in the book occurred mainly in 2009-2011, but in the final chapter there is also some recent events.

Although the title refers to the spam problem, It's not just about spam itself, but it gives a full image of the surrounding cybercrime environment. Give it a try ;)

agopaul··on Windows 10 users are being banned from torrent sites
After reading Krebs' book, I think twice before running this kind of tool, even if it looks legit
agopaul··on Bootstrap 4 alpha
Ok, so? I'm sure that Pure CSS has as many components and options as Bootstrap
agopaul··on The Ashley Madison Database Was Leaked
This, you don't even need to be PCI compliant to store the last 4 digits and the expiration date. This way you can show this info to the user and email the user before the card expires (in case of recurring payments).

If you work with external payment gateways sometimes you are provided with this information even if the card processing is done directly on the processor page (you only have access to limited information about the card and the transaction)

agopaul··on NYC Mesh is trying to get around the big ISPs one node at a time
This is very interesting, but I wonder: how do you guys handle abuses? Especially when it comes to sharing the home connection to the 'outer' Internet with strangers. Do you keep logs? If so, how do you handle the privacy part?

I think in part this is a problem that also Tor relay owners have (minus the log keeping obviously).

agopaul··on Database versioning best practices
Interesting point, though I've never thought about this situation because I've never worked with software versioning. If I need to rollback, I have to check which migrations are present in the SCM repository in a specific revision that I need to rollback to
agopaul··on Database versioning best practices
I have a similar approach, but with timestamps instead of an incremental int.

I'd use a tool for this, but then I would need to change how I deploy the apps given that usually, it's best to run the migrations and then update the codebase to prevent exceptions.

In case there are new columns, the best solution would be: execute the migrations (if there are new columns, make them NULL), deploy the code, fill the new columns via SQL or code, if the new columns must be not-NULL, change the table definition and make the columns not-NULL.

Given the complexity I find better to do it by hand.

agopaul··on Database versioning best practices
Why not timestamps + description? This way, even if you create migrations on different branches, you don't have version number overlap. Rails does that if I remember correctly.

eg:

201509102039-add-this-to-table.sql

201510220840-add-that-to-table.sql

agopaul··on Hackers Exploit 'Flash' Vulnerability in Yahoo Ads
I've removed it immediately after reading the Hacking Team story and never looked back
agopaul··on Amazon Aurora Now Available
I think Aurora doesn't compare to any other host-it-yourself solution, being managed and 'replicated' across multiple datacenters.

Plus, Hetzner, really?

agopaul··on Behind Germany’s refusal to grant Greece debt relief
See, I'm Italian and the thing that is insulting is how Schäuble and Merkel sometimes make decisions in this situation without even consulting the rest of the creditors (France, Italy and others).

I get that your government has to work with internal politics, but, on the other hand, our government find increasingly difficult to justify this idea of a German-centric Europe to our public opinion (no matter if the German government is actually a mediator between the 'north' and the 'south' Europe or not), because that's how it's perceived here.

agopaul··on Behind Germany’s refusal to grant Greece debt relief
As a European I find German foreign policy quite insulting. This needs to change in one way or the other.
agopaul··on Postico: A Modern PostgreSQL Client for OS X
I would buy it immediately if it wasn't for the lack of a graphical schema designer like MySQL Workbench (https://www.mysql.com/common/images/products/MySQL_Workbench...)

That would be a huge thing, considering that there is not a valid tool that has it for pg yet. Maybe Navicat has it, but the price is quite high IMO (~$200).

Looks very good thought, nice UI

agopaul··on Postico: A Modern PostgreSQL Client for OS X
Looks good. Still, pg doesn't have a client with a good graphical editor yet (to draw tables and their relationships between them).

On the other hand, MySQL has MySQL Workbench which works quite well, even if it has some bugs

agopaul··on Hacking Team hacked, attackers claim 400GB in dumped data
Orwell's 1984?
agopaul··on An update about the new Chrome bookmarks manager
As a heavy bookmarks user, I'm happy they reverted to the more practical old solution
← PreviousPage 5 of 6Next →