Perspectives on LedgerSMB

Most-linked posts?

1. Introduction to PostgreSQL as Object-Relational Database Management System
   3 people · 3 mentions · first linked 2012-08-22
2. A Software Architect's View of the Design of Double Entry Accounting (2012)
   2 people · 4 mentions · first linked 2012-08-10
3. In Praise of Perl 5
   2 people · 3 mentions · first linked 2014-02-27
4. O/R modelling interlude: PostgreSQL vs MySQL
   2 people · 2 mentions · first linked 2012-09-08
5. Which is worse when working on production databases? Being drunk or tired?
   2 people · 2 mentions · first linked 2023-03-09
6. Intro to Tables as Classes in PostgreSQL
   2 people · 2 mentions · first linked 2012-08-25

What Hacker News says?

1. einhverfr · 2011-11-07

   > I don't follow your argument here. Could you restate it? Sure. Quick note, will use PostgreSQL SQL for this post. Ok, take a simple example regarding US street addresses. A street address contains the following important portions: 1) Street address designation (may or may not start with a digit). We will call this 'address' for relational purposes. 2) City 3) State 4) Zipcode As for data value dependencies: zipcod…

   Comment linking /

   on “Don't use MongoDB”
2. ceyhunkazel · 2011-11-02

   Submitted Underrated Features of PostgreSQL as a story · 185 points

   HN discussion
3. einhverfr · 2013-06-10

   Metadata cannot be protected as well as the actual content can. One of the keys of good security is to ask what has to be compromised for your data to be compromised, though. If you have SSL-protected connections, BCG hijacking alone isn't going to reveal your communications but BCG hijacking along with a fake certificate issued by a trusted CA under court order or merely voluntarily) would allow a MITM attack. The…

   Comment linking /

   on “Did Obama Just Destroy the U.S. Internet Industry?”
4. Mithaldu · 2014-02-27

   Submitted In Praise of Perl 5 as a story · 125 points

   HN discussion
5. einhverfr · 2012-07-20

   Since way back when the tablefunc contrib module had a connectby() function, but it has some limitations being a C function. The better way is to use WITH RECURSIVE CTE's. See http://ledgersmbdev.blogspot.com/2012/07/ctes-and-ledgersmb.... for how we use them in LedgerSMB for hierarchical data.

   Comment linking /2012/07/ctes-and-ledgersmb.html

   on “PostgreSQL Rising”
6. Dobbs · 2014-08-08

   Submitted A Software Architect's View of the Design of Double Entry Accounting (2012) as a story · 79 points

   HN discussion
7. einhverfr · 2013-06-10

   Here's my view. I recently wrote an article on my blog ( http://ledgersmbdev.blogspot.com/2013/06/tangent-design-thou... ) which was on the front page of HN for a while. I want to summarize both my thoughts again and things that have occurred to me after writing it. All of our existing key interchange systems are amazingly brittle. With X509, there's no reason to assume the NSA couldn't order verisign to produce a c…

   Comment linking /2013/06/tangent-design-thougths-about-next-gen.html

   on “Why we can't go back to business as usual post-PRISM”
8. einhverfr · 2012-07-17

   Submitted Why use Moose? A PostgreSQL perspective. as a story · 60 points

   HN discussion
9. einhverfr · 2014-03-25

   I wrote a blog post which entirely disagrees with you that got around 11000 hits to date (many from here on HN).[1] It is true that one way to do something is foreign to Perl culture. It is also true that the best Perl code is pretty unreadable if you expect to read it as a C/C++/Java programmer. Perl is a very different language, and good Perl code reads very differently. I am not going to get in a language war of…

   Comment linking /2014/02/in-praise-of-perl-5.html

   on “Why I like Java”
10. einhverfr · 2013-06-08

    Submitted Design thoughts on next-gen PKI for better privacy as a story · 49 points

    HN discussion
11. einhverfr · 2013-10-21

    Also I wrote a blog piece( http://ledgersmbdev.blogspot.com/2013/04/a-distributist-view... ) about Distributism and open source, which comes around to favoring BSD-style licenses on a work-ownership theory. The piece can be an introduction to Distributist theory for open source developers as well as an introduction to open source for Distributists.

    Comment linking /2013/04/a-distributist-view-on-software-freedom.html

    on “Have young people in Japan stopped having sex?”
12. einhverfr · 2012-03-04

    Submitted Application vs Database Programming as a story · 39 points

    HN discussion
13. jeffdavis · 2012-09-10

    Regarding the inheritance features, he's been writing an extensive series on the subject recently: http://ledgersmbdev.blogspot.com/2012/08/intro-to-postgresql... (though he should provide forward/backward links in the posts -- as it stands you need to find the other parts in the archive links on the right)

    Comment linking /2012/08/intro-to-postgresql-as-object.html

    on “PostgreSQL 9.2 released”
14. einhverfr · 2012-07-12

    Submitted PostgreSQL Common Table Expressions and LedgerSMB as a story · 30 points

    HN discussion
15. einhverfr · 2011-11-05

    I am often both playing with experimental technologies and pushing the envelope vs best programming practices. If you look at the approach of LedgerSMB's use of PostgreSQL (see http://ledgersmbdev.blogspot.com/2011/10/design-of-ledgersmb... and http://ledgersmbdev.blogspot.com/2011/10/introduction-to-sod... for more) and also being critical of our approaches (see http://ledgersmbdev.blogspot.com/2011/10/soda-in-ledg…

    Comment linking /2011/10/soda-in-ledgersmb-13-critical.html

    on “The Number One Trait of a Great Developer”
16. einhverfr · 2016-12-11

    Submitted What Git got right and wrong as a story · 18 points

    HN discussion
17. einhverfr · 2012-08-15

    We are probably on the same page. I wrote this: http://ledgersmbdev.blogspot.com/2012/08/patterns-and-anti-p... Comments are not for maintainability.

    Comment linking /2012/08/patterns-and-anti-patterns-in-code.html

    on “Thoughts on being a programmer”
18. einhverfr · 2012-08-14

    Submitted ACID as basic building block of eventually consistent distributed transactions as a story · 12 points

    HN discussion
19. einhverfr · 2012-09-18

    I suspect that a lot of NoSQL folks come to NoSQL from MySQL. As for this part: >"When you have multiple applications accessing the same database, each with their own implementation of consistency rules and their own internal idea of the data schema, come back and explain how that is more fun than using an RDBMS and being able to sleep nights." The obvious answer from the MySQL/NoSQL folks is "What? That's crazy! Mu…

    Comment linking /2012/09/or-modelling-interlude-postgresql-vs.html

    on “Why I Migrated Away From MongoDB”
20. einhverfr · 2012-08-03

    Submitted Patterns and Anti-Patterns in Code Comments as a story · 11 points

    HN discussion
21. porker · 2017-11-03

    > I'm personally a little annoyed at PG's efforts to turn SQL into half an OO programming language (see http://ledgersmbdev.blogspot.com/2012/08/postgresql-or-model... . for examples) I read that link and didn't get it - has anyone a fuller explanation or other links to recommend?

    Comment linking /2012/08/postgresql-or-model..

    on “MySQL vs. MariaDB: Reality Check”
22. einhverfr · 2019-05-26

    Submitted PostgreSQL: Table Inheritance – What's It Good For? as a story · 9 points

    HN discussion
23. zzzeek · 2017-11-03

    If I was doing brand new development somewhere I'm sure I'd use Postgresql, since from a developer point of view it's the most consistent and flexible. While for the last few years I've worked way more with MySQL / MariaDB and at the moment the MySQL side of things is a bit more familiar to me, I still appreciate PG's vastly superior query planner and index features. Certainly in the SQLAlchemy world when i want to…

    Comment linking /2012/08/postgresql-or-modelling-part-2-intro-to.html

    on “MySQL vs. MariaDB: Reality Check”
24. soopurman · 2023-03-09

    Submitted Which is worse when working on production databases? Being drunk or tired? as a story · 3 points

    HN discussion
25. einhverfr · 2012-08-16

    Let's see in PostgreSQL 8.4 and higher... a is accomplished by windowing functions. These can also do running totals among other things which is really helpful in accounting environments. b has been supported since at least 8.3. I think a column can actually be an array of complex types in 8.4 and higher (it can be a tuple in 8.0-8.3 at least though I reported a bug in this in 7.3 which resulted in a "don't do that"…

    Comment linking /2012/07/ctes-and-ledgersmb.html

    on “MySQL vs PostgreSQL”
26. okket · 2019-05-26

    Submitted Table Inheritance: What's It Good For? as a story · 3 points

    HN discussion
27. einhverfr · 2012-09-09

    I am actually thinking of writing one. My blog (yes I am the author of the article, http://ledgersmbdev.blogspot.com ) is basically running a fairly large series on these features. The big thing to realize is that there are two aspects here: development efficiency and complexity cost on one hand, and db performance on the other. A lot of the O/R capabilities really do have a significant complexity cost and it is eas…

    Comment linking /

    on “ PostgreSQL vs MySQL: an apples to oranges comparison”
28. okket · 2018-09-21

    Submitted PostgreSQL at 20TB and Beyond as a story · 3 points

    HN discussion
29. einhverfr · 2014-03-20

    I think Stallman misses the point that many of us who are at least latent distributists see in free/open source software. Freedom can't be defined as a freedom from restriction or a Lockean framework of liberty, as Stallman imagines, but rather the freedom to engage creative or productive endeavors without micromanagement from others.[1] The question, rather literally is who has a right to tell you what license your…

    Comment linking /2013/04/a-distributist-view-on-software-freedom.html

    on “Why Open Source misses the point of Free Software”
30. einhverfr · 2017-01-26

    Submitted PL/Perl and Large PostgreSQL Databases as a story · 3 points

    HN discussion

Search all of HN for ledgersmbdev.blogspot.com

Linked by the same people?

• BBonesMoses.orgbonesmoses.org
• RRobert Haasrhaas.blogspot.com
• CCrunchy Datacrunchydata.com
• CCitus Datacitusdata.com
• PPerconapercona.com
• TThe GitHub Bloggithub.blog