Databases
StackOverflow2013
Postsdbo
POIs a PHP, Python, PostgreSQL design suitable for a business application?
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POIs a PHP, Python, PostgreSQL design suitable for a business application?
    text
    copied!<p>I'm looking for some quick thoughts about a business application I am looking to build. I'd like to separate the three layers of <strong>presentation</strong>, <strong>domain logic</strong>, and <strong>data</strong> using <strong>PHP</strong>, <strong>Python</strong>, and <strong>PostgreSQL</strong>, respectively. I would like to hear, possibly from other folks who have gone down this path before, if there are problems with this approach, if I am targeting the wrong tools, etc.</p> <ul> <li><p>I'm looking at <strong>PHP</strong> because it is widely used, fairly mature, and I can find ample people with skills in PHP interface design.</p></li> <li><p>I'm looking at <strong>Python</strong> because of the benefits of readable code, because I hear can find more Python programmers that also have subject-matter skills (in this case, finance), and it's an open source language. Plus, it seems easier to code with.</p></li> <li><p>I'm looking at <strong>PostgreSQL</strong> for the transaction-level features. <strong>MySQL</strong> is also an option here, but I don't need to debate this aspect.</p></li> </ul> <p>This is not a web application, although I would like to utilize a browser for the user interface. This is more of an Enterprise Application, but for a small business with moderate numbers of users (maybe 5-10) and a modest number of daily transactions. </p> <p>What is important is that we are able to upgrade the database or domain logic or interface separate from the other layers in the future.</p> <p><em>I'm NOT looking for a buy vs. build debate</em>, as that's a different discussion.</p> <p>Thanks for any insight</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload