jkeisling/hacker-news-corpus-2007-2022 huggingface dataset:
Show HN: Postgres.email – Readable Mailing Lists
https://postgres.email/lists/pgsql-hackers/%3C20220802.133046.1941977979333284049.horikyota.ntt@gmail.com%3E
This is a small POC that I've been developing to transform the Postgres mailing lists[0] more readable

I've linked to a thread "COPY TO (FREEZE)?" in the Show HN link, and the equivalent on the Postgres mailing list site is here:

https://www.postgresql.org/message-id/20220802.133046.194197...

The idea of postgres.email is to make all responses threaded, like the comments here on HN or Reddit.

I created this by using an imap Foreign Data Wrapper to ingest the messages into a Postgres database. I have only ingested 1000 messages for the POC. It also doesn't display attachments.

The code can bew found here:

https://github.com/kiwicopple/postgres.email

The technologies used are:

- Gmail to receive the email

- Steampipe for the FDW: https://hub.steampipe.io/plugins/turbot/imap

- Supabase for the Postgres database / APIs: https://supabase.com

- Remix for the frontend: https://remix.run/

Given the size of the mailing lists, I doubt the current approach will scale much further than the POC, so I'll need to re-think the architecture. I'll probably keep the emails in gmail and and leverage the FDW for older messages.

Some things I'd like to do next:

- explore alternative architectures
- show attachments
- add a REST API
- add search - the size of the mailing lists might make this difficult
- allow readers to toggle on a "markdown" view. Often authors use markdown syntax in their emails
- add a light mode

[0] Mailing lists: https://www.postgresql.org/list/
RubyConf Argentina's Call For Papers is open
http://rubyconfargentina.org/en
Hi Rubyists!

We want to let you know that the Call For Papers is now officially open!

The second edition of RubyConf Argentina will be held October 19/20, and, just like last year, will be dedicated to Ruby and other related technologies.

Submission of proposals is through rubyconfargentina.org. Don't forget to provide your contact information and a brief abstract of your talk.

Keep in mind that the talks should be no longer than 30 minutes, and should focus on Ruby or similar technologies (Sinatra, Ruby on Rails, JRuby, Git, automated testing, agile methodologies, javascript, NoSQL, mobile applications, etc.) Also note that you will need to make a copy of your slides available for conference attendees.

Just like last year, we are going to have a full-day complementary event, specifically dedicated to workshops and tutorials. These sessions will last between 2 and 4 hours and feature much smaller audiences.

The Call For Papers ends on August 17, 2012. We're waiting for your proposal!
Show HN: Mesh – A well engineered SDK for building Cardano blockchain apps
https://mesh.martify.io/
Hi HN! I've been working on Mesh, and I think it is time to it with you guys. Building on Cardano is difficult, because it lacks documentations and proper SDKs. This is where Mesh fills in this gap. With those beginner guides, is incredibly easy to get started, removing the pain of getting the simplest things to work. It is well engineered, the cloest "competitor" package size is over 10MB, while Mesh is less than 300KB, thus its light weight and your dApp will run fast. It is well documented and flexible, so you can build any dApp you can imagine.

From the way the code is written to the way it is being used; Please let me know what you think!
13 Rules for Entrepreneurial Success
http://blog.newscred.com/?p=46
10 from Loic Le Meur, plus a few more from me for good measure. Inspiring stuff.
Ask PG: Hardware/Infrastructure startups and YC?
A number of the ideas I've had for new disruptive companies aren't traditional web applications or services, but instead are hardware producers, new takes on systems software, and re-imagining infrastructure. More SpaceX and NeXT than Hipmonk and Posterous.

These markets are full of slow-moving entrenched players: a ripe target for disruption in a major way. However, it's probably a harder market to get into, with more capital outlay required to get started.

My question is: would YCombinator be interested in such a startup? I imagine that the level of funding YC gives would help a team of founders get a purified idea of what they intend to make, and maybe some very early stage prototypes of software, though probably not hardware. Being successful would entirely depend on getting a funding round once we produce the plans so we can hire talent, purchase materials and start manufacturing.
Show HN: An offensive security toolkit written in Rust
https://github.com/kmanc/remote_code_oxidation
Remote Code Oxidation is a collection of tools that help offensive security professionals quickly adapt payloads to the needs of their engagement. Any and all feedback is welcome!
Ask HN: How to be a good mentor?
More specifically in a software engineering context, how can a mid-level Lead/Manager excel at mentoring the inexperienced engineers reporting to him/her?

Article/Book recommendations and personal anecdotes are all welcome...
Ask HN: Is there any forum where we can discuss our stack/architecture?
Various times Startups end up wasting a lot of money and time all due to wrong tech stack / architecture decisions.

Is there any forum or website where they can discuss before hand executing their idea/app?
Pakistan Drone Pilots Could be Tried for War Crimes
http://gizmodo.com/5528715/drone-pilots-could-be-tried-for-war-crimes-law-prof-says
The pilots of the drones that recently bombed Pakistan could be tried for war crimes, Harold Koh, a law professor at Yale.
Ask HN: Books - how do you read?
I'm having problems finishing up books lately.

My info intake is usually online, and to some extent, I feel it's becoming a fast-food diet.

On the other hand - I can't finish up books from cover to cover. I become easily bored, distracted, paranoid.

Any advice?
Ask HN: Help me understand Python 2.x vs 3.x
I've been trying to teach myself Python recently, with mixed success. (Recently, I have been a little seduced by the availability of resources and community around Ruby, since my interest is mostly in doing things on the web - so e.g. Rails vs. Django, even though I conceptually like the later, for some logistical reasons I am finding the former to be a little tempting to experiment with more.)

However, a principal question I still have concerns the different versions of Python. [http://wiki.python.org/moin/Python2orPython3]

I have read the Wiki and understand some of the differences, or lack-of-differences, but am still unclear. For example, I know some servers or services (eg Google App Engine) are at one version, while others are at another. Should I be concerned about any of this? Is there any reason to try to use Python 3 at present? Etc?

Thanks for any insights here!
A simple document datastore using Redis
http://github.com/solso/jor
The project provides storage for JSON documents that uses Redis as the backend data-store. JOR also provides a MongoDB-like query language for fast retrieval.
The Android which really made it: Openmoko reopen now
http://www.openmoko.com/store.html
Openmoko is a project which encompasses two related sub-projects, with the combined aim of creating a family of open source mobile phones.[1] The project was founded by FIC.

The first sub-project is Openmoko Linux, an open source Linux based operating system designed for mobile phones, built using free software.

The second sub-project is the development of hardware devices on which Openmoko Linux runs. The first device released was the inconsistently-named Neo 1973 or Neo1973[2][3], which was followed up by the Neo Freerunner on the 25th of June 2008.[4] Unlike most other mobile phone platforms, these phones are designed to provide end users with the ability to modify the operating system and software stack. Other Openmoko supported phones are listed here.
Mini game from start to launch in 5 hours
http://pixeltweak.net/superescape/
A quick mini game I made to stay fresh on my Javascript.
Ask HN: Heroku/GAE like service for PHP?
Can anyone point me to a Heroko/Google App Engine like service for PHP? I'm happy with Linode, but it would be nice if I could test out new ideas for free.

Hosting on a home-based server is not possible as my ISP scans for and blocks HTTP servers, on any port :(
Ask HN: Does a "find me a cheap interantional adventure" service exist?
I'm curious if such a service exists: I just want a listing of the cheapest possible international flights with no regard to the departure/return date. Essentially a service that allows me to go on an adventure for cheap. Perhaps the need could be met by a Groupon like model for airfare: cheap, last minute deals at really cheap prices.
Do airlines ever offer cut-rate prices on airfare? Is this where flying standby fits in? Is it even possible to fly standby anymore, or something equivalent to it?
G-Wan web server
http://gwan.com/
Just bumped into a rather impressive even if restrictive/closed source web server.

They quote massive performance improvements compared to IIS -- 5 million times more performant. However, they require the web application to be written in C.
AideRSS + GoogleReader = solve information overload 
http://gr.aiderss.com/
We launched a new firefox extension which intergrates PostRank into GoogleReader. Would love to hear some feedback. First come, first serve invites: http://gr.aiderss.com/?ycomb
Show HN: A just another Cron alternative but with much more capabilities
https://github.com/yohamta/dagu
I have created a Cron alternative that runs DAGs (Directed acyclic graph) defined in a simple YAML format.

Why not Airflow? Airflow and other similar tools are powerful and valuable, but in most cases, they require writing code to manage workflows.

Our ETL pipeline is already hundreds of thousands of lines of complex code in Perl and shell scripts. Adding another layer of Python on top of this would make it difficult to maintain. Instead, we needed a more lightweight solution.

So we developed Dagu, which requires no coding, and is easy-to-use and self-contained, making it ideal for smaller projects with fewer people.
Why do we think about graphs and numbers differently?
http://nielsolson.us/Haversian/2008/11/why_do_we_think_about_numbers.php
This couldn't possibly be considered a complete or authoritative resource, just a spruced up email response, but I thought some folks might find it interesting.
AMA on why patents and copyright should be abolished
http://www.reddit.com/r/IAmA/comments/1727he/i_am_stephan_kinsella_a_patent_attorney_and/
I'm a practicing patent lawyer, and have written and spoken a good deal on libertarian and free market topics. I founded and am executive editor of Libertarian Papers (http://www.libertarianpapers.org/), and director of Center for the Study of Innovative Freedom (http://c4sif.org/). I am a follower of the Austrian school of economics (as exemplified by Mises, Rothbard, and Hoppe) and anarchist libertarian propertarianism, as exemplified by Rothbard and Hoppe. I believe in reason, individualism, the free market, technology, and society, and think the state is evil and should be abolished.
I also believe intellectual property (patent and copyright) is completely unjust, statist, protectionist, and utterly incompatible with private property rights, capitalism, and the free market, and should not be reformed, but abolished.
Ask me anything.
The Persistence Layer with Spring 3.1 and Hibernate
http://www.baeldung.com/2011/12/02/the-persistence-layer-with-spring-3-1-and-hibernate/
How to configure the persistence layer with Spring 3.1 and Hibernate. Focuses on Transaction Management, Hibernate Session management, Spring template best practices and common pitfalls.
Show HN: Vaxiin – IPMI/iDRAC/OOB software stack
https://docs.vaxiin.io/
This was submitted before but it didn't seem to get much attention because I don't think the title was very descriptive and the submitter was brand new. I almost didn't click it but once I did I thought the project was pretty awesome and had a lot of promise. Hope this doesn't violate the rules, I have no horse in the game, but the creator is here on the site so hopefully he'll be able to answer your questions.
Visualized: The world of verified users
https://blog.twitter.com/2013/visualized-the-world-of-verified-users
Ever wondered which of the world’s most famous people follow each other on Twitter?
Ask HN: I am the smartest person in the room. What should I do?
I have been working at a company that has gone through some significant changes recently. When I was hired (not quite 2 years ago), there was an enormous amount of growth potential and I was always learning something.

We went through a "merger" with our parent company, and had a large amount of turnover. Now, I no longer am able to work on projects with any potential and have effectively become tech support/customer service. I have lost all ability to learn through experience.

Being "the smartest guy in the room" is absolutely terrifying. I don't feel like I have a huge amount of knowledge or experience, but I don't think that anyone else understands the consequences of the decisions that get made.

Now the big questions:

1. Am I chasing a pipe dream to keep looking for a better work environment?

2. Is it worth doubling down on time/effort to try to change the culture, or do I cut my losses?
TerraCycle - first mass-produced consumer product to have a negative environmental footprint
http://galai.typepad.com/blog/2006/08/holy_shit.html
Their product is driven by passion to be eco-friendly, not by passion to gain some PR points or appeal to amateur tree-hugger shoppers. Their whole product, end-to-end, is truly eco-friendly. The full story is on their website, but I'll just point out one feature that I LOVED - their amazing packaging:
Show HN: ViruSaas – Virus Checks as a Service
https://app.virusaas.com/
Hi all,

here is a side project I've just launched which might come in handy for certain situations.

It's a very simple and free "do one thing and do it well" online service with exactly one feature: you upload a file, and it tells you — based on a ClamAV check — if that file contains a virus or not.

I'm not having any ambitious plans with this project, but thanks to very low operational costs, I thought I can as well put it out there and keep it alive — maybe it's even useful for some people every now and then (just today, one of my coworkers forwarded me a fishy-looking email with an attachment, and using virusaas.com turned out to be the least painful way to do this kind of one-off check for a virus).

I've also released the source code of the web app under GPLv3 at https://github.com/hygieia-saas/hygieia-webapp, although it's not as polished as it could be (no tests, for example — but see above, no ambitious plans).

The main reason to do the project was to follow through with my own tutorial at https://manuel.kiessling.net/2021/05/02/tutorial-react-singl..., which worked out quite nicely.
Rand Paul Is Filibustering Senate of Patriot Act Renewal
https://twitter.com/RandPaul/status/601079082676318208
Live feed... http://www.c-span.org/networks/?channel=c-span-2
Facebook: Why Applications Suck
http://www.alexkates.com/2007/10/facebook-why-applications-suck.html
My take. Let's hear what you guys think.
An MIT Trick: Computing On Encrypted Databases Without Ever Decrypting Them
http://www.forbes.com/sites/andygreenberg/2011/12/19/an-mit-magic-trick-computing-on-encrypted-databases-without-ever-decrypting-them/
Original paper, CryptDB: Protecting Confidentiality with Encrypted Query Processing http://people.csail.mit.edu/nickolai/papers/raluca-cryptdb.pdf
FT: Facebook sues German StudiVZ
http://d2cft.volantis.net/d2c/0.0?feed-article-id=8cd4ebbe-551f-11dd-ae9c-000077b07658
I wonder if that's all there is to this; I find it hard to believe that StudiVZ actually copied directly from Facebook. Maybe they did in the early days, but I'd have thought that at the very latest the due diligence before acquisition would have found any such cases.

If they have any success with this because the site is "similar" then that would set a precedent for about a gazillion other websites.
Ask HN: Any advice for single-hand typist?
I'm single hand (left hand) typist. I'm mostly using vim editor. Keyboard layout is QWERTY.

What are advices to speedup my typing speed?
EFF Explains: How The NSA Deploys Malware
https://www.eff.org/deeplinks/2013/10/how-nsa-deploys-malware-new-revelations
In addition to making plug-ins "click to play" (in Chrome:

Settings => Show Advanced Settings => Privacy => Content Settings => Plug-ins => Click to play)

be sure to look at your Manage Exceptions. I had a number of sites that had special "Allow" privileges that I no longer think are warranted.
Ask HN: What web database should a newbie learn first?
It seems the field of databases is constantly changing.

As such, what would you recommend someone just getting into website coding and applications should study as their first database, and why?

Are there any databases a beginner should avoid for a while?

Any on the downswing so heavily that maybe they should not be bothered with at all?
Our experience with crowdfunding platform WeFunder
http://blog.pursuit.me/post/35254106035/we-funder
A brief summary of our experience over a few weeks using the platform WeFunder for our Startups early fundraising signal.
Advice for a high school student
http://paulgraham.com/hs.html
I am a high school student and aspiring startup entrepreneur and am wondering what additional advice all of you have?
Flickr Rebellion Brews at Specter of M$ Acquisition
http://blog.wired.com/monkeybites/2008/02/what-would-micr.html
"A small but vocal minority on Flickr are already staging online protests at the prospect of a Microsoft takeover. Flickr is one of several popular Web 2.0 websites owned by Yahoo that loyal users fear will suffer under Microsoft ownership."
Parallel.For for pre C# 4.0
http://coding-time.blogspot.com/2008/03/implement-your-own-parallelfor-in-c.html
Same syntax as System.Threading.Tasks so now[1] us poor enterprise drones, who can't see Visual Studio 2010 and .NET 4 being installed anytime soon, can get our feet wet.

[1]I admit that it's kind of a stretch to use the word now for a blog post that old.
A Journey Through the CPU Pipeline
http://www.gamedev.net/page/resources/_/technical/general-programming/a-journey-through-the-cpu-pipeline-r3115
is good for programmers to understand what goes on inside a processor. The CPU is at the heart of our career.

What goes on inside the CPU? How long does it take for one instruction to run? What does it mean when a new CPU has a 12-stage pipeline, or 18-stage pipeline, or even a "deep" 31-stage pipeline?

Programs generally treat the CPU as a black box. Instructions go into the box in order, instructions come out of the box in order, and some processing magic happens inside.

As a programmer, it is useful to learn what happens inside the box. This is especially true if you will be working on tasks like program optimization. If you don’t know what is going on inside the CPU, how can you optimize for it?
Flatworldknowledge - Freemium business model at work.
http://www.flatworldknowledge.com/
Educators choose the book — students choose format and price.
Show HN: heyhey – Building a Linktree-like app taught me more than college
https://heyhey.to/
Hello Hacker News!

HEYHEY is a service that tries to bridge the siloed platforms of the modern-day internet and be where people come to search for others. So far, I've spent about 2 months developing it, and as a college student, it honestly helped me learn more about computer science than any undergrad course we have. Also, after getting the inspiration from HN, I wanted to prove to myself that, in 2022, anyone could build a full-fledged web service. Thanks to its modern-yet-traditional infrastructure, HEYHEY is costing me about 0 dollars a month to run (so far!).

I really wanted to keep the service simple but functional. So naturally, I tried to stay away from a JS-based front-end. Instead, HEYHEY uses simple HTML pages with modern CSS and forms to function (you can disable JS!). Last week, I silently turned on registers, and if you register today, you will have a 10% chance to get Pro for life — it enables custom usernames (heyhey.to/[username]) and rich themes.

I am not trying to take over the "Linktree space" nor trying to build a unicorn startup. After making HEYHEY presentable, I just wanted others to have access to it as well. I hope to keep developing HEYHEY so that it can further integrate with other social platforms while staying lightweight and functional. Would love to hear your feedback!

If you registered and want to delete your account, just shoot an email to: friends@heyhey.to
Ask HN: Should I stay on board?
Recently, I was the lead developer on a project with a friend.

That friend has now taken the necessary steps to make it into a profitable company.

He's making great strides in his plan (which was the plan all along) and has come back to me with possibly good news. I'm beginning to get questions like what sort of hardware it will take to keep this thing going strong and what positions need to be filled and all that jazz.

I am very fast approaching territory that I have no clue about and tbh it's freaking me the hell out. Should I research the hell out what it would take to be someones boss or should I kind of step down and hope that I'm kept on board when someone who knows more than me steps up?

I know this is one of those Lead, Follow, or get out of the way situations and I'd like to lead but I have no idea what I'm doing.

And the only reason I'm asking HN instead of a psychiatrist or my parents is because I know this place has an extensive collection of people who have more than likely gone through the same thing hopefully.
Ask HN:  Top 3 tips Advice on selling enterprise SaaS
What are your top 3 tips on selling software to the enterprise?

I'm launching a SaaS startup and need a little advice on how to approach big companies.

Advice is appreciated.

Cheers.
Show HN: Bookable Schedule – Schedule meetings directly inside ONE email
https://www.boomeranggmail.com/meeting-scheduling/
Hi Hacker News!

We released a new meeting scheduling product today! You can use Bookable Schedule in Boomerang for Gmail or our iOS app to create a set of availabilities and share it as many times as you’d like inside your email. Recipients receive an image of your live availabilities and through the use of image maps, they can see and pick the right appointment slots directly inside whichever email client they’re using.

If the recipient also has Boomerang, they can overlay their calendar on top of the schedule (still inside the email) to see which times work best for them! It works great for things like office hours, client appointments, sales calls, and more. It also doesn't shift the work of scheduling meetings to the person you're inviting, so it's better etiquette[1] and easier for recipients as well as the scheduler.

Please feel free to take a look and play with it, we’d love to hear your thoughts!

[1] https://twitter.com/JCornebise/status/1486809751602319371

(By the way, we are hiring for frontend and fullstack devs - i.want.to.work at baydin . com)
What do you love in people?
http://www.ilovepeoplewho.com/
Your cure against cynicism ;)
A long time between Macs
http://blog.jedwhite.com/2009/04/long-time-between-macs.html
One coder's story of why he switched back to Macs after years on PCs, Windows and Linux.
Ask HN: Are Herman Miller Aerons worth the money?
I need a new chair. The Herman Miller Aeron seems solid, though I haven't actually sat in one yet. At $400-500 on Craigslist, they're not exactly cheap and I want to make sure I'm not missing something.

Are they worth the $400-500?
Zynga: the whole "they treat their employees badly" thing is a lie
http://charlesyay.wordpress.com/2012/08/12/zynga/
All that stuff about Zynga treating its employees terribly? I don't believe it. Maybe they just really really love what they do, maybe even more than you.