Re: [Ledger-smb-devel] PostgreSQL 9.0 released, notes about LedgerSMB compatibility

2010-09-23 Thread Josh Berkus
> relies on affected areas much more than 1.2. Hmmm? You've been overloading column names as variables? -- -- Josh Berkus PostgreSQL Experts Inc. http

[Ledger-smb-devel] OT: any LSMB speakers in the Bay Area?

2010-09-02 Thread Josh Berkus
If anyone from the LSMB community is in the Bay Area and can do a talk on LSMB at PostgreSQL West (November, San Francisco), I'd love to have you submit one. http://www.postgresqlconference.org -- -- Josh Berkus Postg

Re: [Ledger-smb-devel] Postgres Security Update

2010-01-27 Thread Josh Berkus
On 1/27/10 2:33 PM, David Godfrey wrote: > A heads up for all, > > There is a security update available for postgres. > It also fixes some memory leaks and other things. Are you referring to 8.4.2? That came out a while ago ... -

Re: [Ledger-smb-devel] Row-level security?

2009-02-10 Thread Josh Berkus
Chris Travers wrote: > On Tue, Feb 10, 2009 at 1:36 PM, Roderick A. Anderson > wrote: >> I understand that 1.3 (or maybe 1.4) will have access to tables >> controlled via a role. (Did I state that correctly?). >> >> While doing some searching I read that row-level security wasn't going >> to be

Re: [Ledger-smb-devel] Persistent connections to database?

2007-11-16 Thread Josh Berkus
You can also use pgBouncer: http://developer.skype.com/SkypeGarage/DbProjects/PgBouncer -- --Josh Josh Berkus PostgreSQL @ Sun San Francisco - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) V

Re: [Ledger-smb-devel] Proposal: License Change for Manual And Standardization of Licenses for Official Docs

2007-10-23 Thread Josh Berkus
nse compatibility more than any other. -- Josh Berkus PostgreSQL @ Sun San Francisco - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configu

Re: [Ledger-smb-devel] Re-authentication proposal for LedgerSMB 1.3 (HTTP Auth)

2007-10-04 Thread Josh Berkus
works with application users stored in a table. However, LedgerSMB desires to use *database users* (i.e. ROLES) so that the same set of access restrictions can be maintained across 3rd-party applications which connect to the database. -- Josh Berkus PostgreS

Re: [Ledger-smb-devel] GPL v3? Other license options?

2007-08-21 Thread Josh Berkus
Guys, This whole discussion is pointless. We got the code under the GPL; our only choice to change licenses is GPLv3. Since we're incrementally replacing Dieter's code, we can't ever relicense it. --Josh - This SF.net em

Re: [Ledger-smb-devel] GPL v3? Other license options?

2007-08-19 Thread Josh Berkus
for PostgreSQL? -- --Josh Josh Berkus PostgreSQL @ Sun San Francisco - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX

Re: [Ledger-smb-devel] RFC: Moving menu.ini information into the database

2007-06-28 Thread Josh Berkus
Josh Berkus wrote: > Chris, > >> Unfortunately, SQL is pretty bad at handling arbitrary-depth menus >> (esp. without WITH RECURSIVE or CONNECT BY). Fortunately, the amount >> of data is likely to be pretty small, so it is not too bad using >> stored procedures. >

Re: [Ledger-smb-devel] RFC: Moving menu.ini information into the database

2007-06-28 Thread Josh Berkus
Chris, > Unfortunately, SQL is pretty bad at handling arbitrary-depth menus > (esp. without WITH RECURSIVE or CONNECT BY). Fortunately, the amount > of data is likely to be pretty small, so it is not too bad using > stored procedures. See connect_by() in tablefunc. Please don't reinvent the whe

Re: [Ledger-smb-devel] For those interested in the CRM/Enti ty management

2007-06-19 Thread Josh Berkus
ltiples where they are called for (multiple offices, for example). Although I'm not convinced that tax info should be attached to customers necessarily; of course, I don't really understand VAT as an American. This is a basic struc

[Ledger-smb-devel] Time to take down the fork notice?

2007-06-14 Thread Josh Berkus
e package. It performs the work of popular software like QuickBooks and Peachtree, with additional modules for Point of Sale, Inventory and other features." Then we can put the Dieter-fork sentence somewhere towards the end of the About page. -- Jo

[Ledger-smb-devel] Fwd: [Foundations] Invitation to 2nd annual State Of Lightning Talks at OSCON

2007-05-16 Thread Josh Berkus
People: If we don't have another LSMB talk at OSCON, then please let's do a SOLT. -- Forwarded Message -- Subject: [Foundations] Invitation to 2nd annual State Of Lightning Talks at OSCON Date: Tuesday 15 May 2007 13:04 From: Josh Berkus <[EMAIL PROTECTED

Re: [Ledger-smb-devel] Checklist for 1.3

2007-03-05 Thread Josh Berkus
ss rules in a way which can be easily isolated to specific data regions. -- Josh Berkus PostgreSQL @ Sun San Francisco - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and yo

Re: [Ledger-smb-devel] Light manufacturing moduels....

2007-01-30 Thread Josh Berkus
Jeff, Is there a reason why you're drawn to ERP? I ask because there are a bunch of open source ERP projects already (Compiere, OpenBravo, etc.) but there are not really good time&billing or payroll tools. -- --Josh Josh Berkus PostgreSQL @ Sun San

Re: [Ledger-smb-devel] OSCON talks? Need to take action

2007-01-30 Thread Josh Berkus
Chris, > I am not too far away. It is approx 6 hrs by car for me and I have > friends in the Portland area. Well, please submit both of those, or something similar. I'm on the committee, so if you want me to review your submission before you send it it, I'm game. -- --J

[Ledger-smb-devel] OSCON talks? Need to take action

2007-01-30 Thread Josh Berkus
eone who's hacking the actual code present if possible. Anyone else planning on going to OSCON? Josh? -- --Josh Josh Berkus PostgreSQL @ Sun San Francisco - Take Surveys. Earn Cash. Influence the Future of IT Join So

Re: [Ledger-smb-devel] Self-documenting API Proposal

2007-01-30 Thread Josh Berkus
Chris, > I think it is better to attach internal catalogs which maintain these > functions. But that is more work for us and I am happy to reconsider http://www.pgfoundry.org/projects/newsysviews -- Josh Berkus PostgreSQL @ Sun San Fra

Re: [Ledger-smb-devel] Self-documenting API Proposal

2007-01-30 Thread Josh Berkus
x27;s specific approach, but I can certainly see having a centralized function map. > I can get argument types out, but not argument names. Eh? Why not? -- Josh Berkus PostgreSQL @ Sun San Francisco - Take Surveys. Earn

Re: [Ledger-smb-devel] Language wars...

2007-01-25 Thread Josh Berkus
. This is the sort of thing I though Catalyst and Rails would excel at. Instead, it actually took me considerably less time to just write some simple PHP scripts than to make what I wanted fit the MVC framework and work around its bugs/limitations. -- --Josh Josh Berkus PostgreS

Re: [Ledger-smb-devel] future of LedgerSMB

2007-01-21 Thread Josh Berkus
gure out when it's used and when it's not. -- Josh Berkus PostgreSQL @ Sun San Francisco - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance

Re: [Ledger-smb-devel] future of LedgerSMB

2007-01-21 Thread Josh Berkus
. So I'd like to explore adding a GL table to the data model. -- Josh Berkus PostgreSQL @ Sun San Francisco - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get th

Re: [Ledger-smb-devel] Adding extra custom reports

2006-11-07 Thread Josh Berkus
tgreSQL also gives us the option of writing our SPs in Perl. -- --Josh Josh Berkus PostgreSQL @ Sun San Francisco - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-inte

Re: [Ledger-smb-devel] Moving to a central db

2006-11-06 Thread Josh Berkus
Chris, > I dunno. I think there are plenty of reasons not to do this also. > There are pro's and cons but the basic issue is that businesses are > supposed to be separate entities. I presume you're talking about schema-per-LSMB-instance rather than schema-for-users her

Re: [Ledger-smb-devel] Moving to a central db

2006-11-05 Thread Josh Berkus
ould just have a schema. If we start with a separate schema, it's relatively easy to have it in a separate DB, or not, via a simple configuration option. -- Josh Berkus PostgreSQL @ Sun San Francisco - Using Tomcat but

Re: [Ledger-smb-devel] Moving to a central db

2006-11-03 Thread Josh Berkus
ike viewing and editing users for example). Hmmm ... can you explain the reason for using a separate DB? Is this so you can support multiple LedgerSMB databases? -- Josh Berkus PostgreSQL @ Sun San Francisco - Using Tomcat

Re: [Ledger-smb-devel] Links to good double-entry explanations

2006-10-12 Thread Josh Berkus
John, > I'm collecting links to good explanations of double-entry bookkeeping for > the manual. Suggestions? Gnumeric used to have one. Not sure if they still do, or where it is. --Josh - Using Tomcat but need to do more

Re: [Ledger-smb-devel] postgre-sql to mysql translation?

2006-10-09 Thread Josh Berkus
All, > Actually, if you are a corporation that puts it's financial data into > mysql, then it deserves the extreme audit reaming that it will > receive at some point in the future: OK, enough beating up on MySQL, guys. I think that "MO's" question has been answered

Re: [Ledger-smb-devel] postgre-sql to mysql translation?

2006-10-08 Thread Josh Berkus
to support MySQL, > the few times I have had to use it in the past weren't much fun. ... not to mention that some of us are involved in porting SugarCRM to PostgreSQL, in order to fix some chronic performance issues with the MySQL version ... -- --Josh Josh Berkus Postg

Re: [Ledger-smb-devel] Community Documentation Architecture, was LaTeX templates, was Docmentation/FAQs

2006-10-06 Thread Josh Berkus
ation Architecture", not Report-Writing. -- --Josh Josh Berkus PostgreSQL @ Sun San Francisco - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance

Re: [Ledger-smb-devel] Beyond 1.2: Contact management requirements

2006-10-02 Thread Josh Berkus
2) The contact records will be made aware of standard extended fields > for "contact," "customer," and "vendor" entities. Multiple "people" associated with a "company", each with

Re: [Ledger-smb-devel] Community Documentation Architecture, was LaTeX templates, was Docmentation/FAQs

2006-10-01 Thread Josh Berkus
ribute documentation is not the way to do this. We need to use something which allows doc contributors to "just write" and not need them to acquire specialized technical knowledge beyond knowledge of LedgerSMB. So, HTML, LaTeX, OO, wiki, whatever, but NOT Docbook