6 ms·

PostgreSQL Database Modeler

121 points by motter 14y ago

Thunderer 14y ago
All READMEs in English, all code in Portuguese? Really?
- mariusmg 14y ago
  I'd never understood while people code in their native language. It's just so.....wrong.
  - fhars 14y ago
    So, which language should American programmers use in their code?
    - FraaJad 14y ago
      What nation do you belong to?
      - mariusmg 14y ago
        I'm from Romania. Coding in your native language is likely used as a safeguard....it means it will be very hard to outsource the product :) . Coding in your native language on a OSS project is even worse.
  - route66 14y ago
    I'll help you. Develop an application for support of financial and tax regulations for a certain country. You will have verbs and nouns which describe the situation clearly. You develop an application from specifications written another language than English. They exist. The biggest failure I keep seeing are futile attempts to translate concepts under these circumstances into English. I agree in this case: when you want to invite collaboration on github, English (or Chinese?) would be better suited.
    - Thunderer 14y ago
      Even in financial / tax software it is possible to create an abstraction in which you can safely write English code and move all specific terms into some i18n module. Of course if you are not clever enough to do that it's not that bad to use /required/ language, but in this case we talk about strictly technical tool for database modeling, so no excuses - it definitely needs to be translated in order to be accessible for other GitHubbers.
  - dserodio 14y ago
    Ever heard of Domain Driven Design? Your customer's problem domain is best expressed in their native language. But for Open Source projects coding in English is probably the best way to attract contributors.
- lzm 14y ago
  Most people don't speak English in Brazil, or do so very poorly.
  - nealabq 14y ago
    Same situation in the USA.
- rcamera 14y ago
  I might fork it later tonight and translate both code and comments to English. Might be an interesting experience... Will update here later with an English fork.
jiggy2011 14y ago
It all compiled ok, but didn't seem to create the executable in the build/ folder..
motter 14y ago
Note the warning from the README: "Although this is a major upgrade version of pgModeler it is recommended NOT EXPORT the models created directly to production environments. Not all possible code generation were tested in this way, is its your own risk export the models into environments that are not intended for testing. The project's author is not responsible for any possible loss of data due the inappropriate use of this tool." https://github.com/pgmodeler/pgmodeler#warning https://github.com/pgmodeler/pgmodeler#warning
- joesb 14y ago
  Looks like standard disclaimer to me. What open source project would be bold enough to say he will be responsible for all loss due to using his tool.
  - rbanffy 14y ago
    > What open source project would be bold enough to say he will be responsible for all loss due to using his tool. How many proprietary products would? Last time I checked a very popular one prohibited customers from even publishing their own benchmarks...
- CaptainZapp 14y ago
  Frankly, Even with tools costing thousands of Euros it would be incredible stupid to export models, or generated code into production environment.
  - mgummelt 14y ago
    Why?
    - jacques_chester 14y ago
      Some data is more valuable than kitten photos and chat logs.
      - 14y ago
garindra 14y ago
For the people that have already tried it, is this finally a good Postgres client for the MacOSX? Haven't found any that comes close to Sequel Pro for MySQL.
- epo 14y ago
  See my link for DbVisualizer.
- artiom 14y ago
  its not Sequel Pro but you can try http://inductionapp.com http://inductionapp.com
  - dmishe 14y ago
    It's a great app, but for different purpose. Induction is mainly for viewing/analyzing _data_, where pgAdmin, while horrible looking, is for managing database schema.
- davyjones 14y ago
  My understanding is that this is not exactly a GUI client. You can give pgXplorer (http://pgxplorer.com http://pgxplorer.com) a shot which is open source and the binaries are readily available. Disclaimer: I am the lead dev of pgXplorer.
- mhurron 14y ago
  What's wrong with PgAdmin? No, I don't count 'not looking native' as a problem.
- agildehaus 14y ago
  The good news is that the Sequel Pro guys have started to work on their Postgres framework: http://stuconnolly.com/blog/sequel-pro-postgresql-support/ http://stuconnolly.com/blog/sequel-pro-postgresql-support/
- nathancahill 14y ago
  I've had a good experience with Tuple: http://www.tuplesapp.com/ http://www.tuplesapp.com/
xabi 14y ago
Mountain Lion compilation is broken. OS not supported.
- dserodio 14y ago
  Thanks for the heads-up so I don't waste time trying to build it. Did you file an issue on their Github?
ericcholis 14y ago
Random thought, this is a pretty decent example of using Bootstrap out of the box. I can tell it's Bootstrap, but the splash logo draws me in.

121 points by motter 14y ago

Thunderer 14y ago

All READMEs in English, all code in Portuguese? Really?

mariusmg 14y ago
I'd never understood while people code in their native language. It's just so.....wrong.
- fhars 14y ago
  So, which language should American programmers use in their code?
  - FraaJad 14y ago
    What nation do you belong to?
    - mariusmg 14y ago
      I'm from Romania. Coding in your native language is likely used as a safeguard....it means it will be very hard to outsource the product :) . Coding in your native language on a OSS project is even worse.
- route66 14y ago
  I'll help you. Develop an application for support of financial and tax regulations for a certain country. You will have verbs and nouns which describe the situation clearly. You develop an application from specifications written another language than English. They exist. The biggest failure I keep seeing are futile attempts to translate concepts under these circumstances into English. I agree in this case: when you want to invite collaboration on github, English (or Chinese?) would be better suited.
  - Thunderer 14y ago
    Even in financial / tax software it is possible to create an abstraction in which you can safely write English code and move all specific terms into some i18n module. Of course if you are not clever enough to do that it's not that bad to use /required/ language, but in this case we talk about strictly technical tool for database modeling, so no excuses - it definitely needs to be translated in order to be accessible for other GitHubbers.
- dserodio 14y ago
  Ever heard of Domain Driven Design? Your customer's problem domain is best expressed in their native language. But for Open Source projects coding in English is probably the best way to attract contributors.
lzm 14y ago
Most people don't speak English in Brazil, or do so very poorly.
- nealabq 14y ago
  Same situation in the USA.
rcamera 14y ago
I might fork it later tonight and translate both code and comments to English. Might be an interesting experience... Will update here later with an English fork.

jiggy2011 14y ago

It all compiled ok, but didn't seem to create the executable in the build/ folder..

motter 14y ago

Note the warning from the README: "Although this is a major upgrade version of pgModeler it is recommended NOT EXPORT the models created directly to production environments. Not all possible code generation were tested in this way, is its your own risk export the models into environments that are not intended for testing. The project's author is not responsible for any possible loss of data due the inappropriate use of this tool." https://github.com/pgmodeler/pgmodeler#warning https://github.com/pgmodeler/pgmodeler#warning

joesb 14y ago
Looks like standard disclaimer to me. What open source project would be bold enough to say he will be responsible for all loss due to using his tool.
- rbanffy 14y ago
  > What open source project would be bold enough to say he will be responsible for all loss due to using his tool. How many proprietary products would? Last time I checked a very popular one prohibited customers from even publishing their own benchmarks...
CaptainZapp 14y ago
Frankly, Even with tools costing thousands of Euros it would be incredible stupid to export models, or generated code into production environment.
- mgummelt 14y ago
  Why?
  - jacques_chester 14y ago
    Some data is more valuable than kitten photos and chat logs.
    - 14y ago

garindra 14y ago

For the people that have already tried it, is this finally a good Postgres client for the MacOSX? Haven't found any that comes close to Sequel Pro for MySQL.

epo 14y ago
See my link for DbVisualizer.
artiom 14y ago
its not Sequel Pro but you can try http://inductionapp.com http://inductionapp.com
- dmishe 14y ago
  It's a great app, but for different purpose. Induction is mainly for viewing/analyzing _data_, where pgAdmin, while horrible looking, is for managing database schema.
davyjones 14y ago
My understanding is that this is not exactly a GUI client. You can give pgXplorer (http://pgxplorer.com http://pgxplorer.com) a shot which is open source and the binaries are readily available. Disclaimer: I am the lead dev of pgXplorer.
mhurron 14y ago
What's wrong with PgAdmin? No, I don't count 'not looking native' as a problem.
agildehaus 14y ago
The good news is that the Sequel Pro guys have started to work on their Postgres framework: http://stuconnolly.com/blog/sequel-pro-postgresql-support/ http://stuconnolly.com/blog/sequel-pro-postgresql-support/
nathancahill 14y ago
I've had a good experience with Tuple: http://www.tuplesapp.com/ http://www.tuplesapp.com/

xabi 14y ago

Mountain Lion compilation is broken. OS not supported.

dserodio 14y ago
Thanks for the heads-up so I don't waste time trying to build it. Did you file an issue on their Github?

ericcholis 14y ago

Random thought, this is a pretty decent example of using Bootstrap out of the box. I can tell it's Bootstrap, but the splash logo draws me in.