![\"Facebook\"](\"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/32x32\/facebook.png\" "\\"Share")
<\/a><\/a>![\"twitter\"](\"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/32x32\/twitter.png\" "\\"Share")
<\/a>![\"reddit\"](\"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/32x32\/reddit.png\" "\\"Share")
<\/a>![\"pinterest\"](\"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/32x32\/pinterest.png\" "\\"Pin")
<\/a>![\"linkedin\"](\"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/32x32\/linkedin.png\" "\\"Share")
<\/a>![\"mail\"](\"https:\/\/jafma.net\/ana\/theweekendarchaeologist\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/32x32\/mail.png\" "\\"Share")
<\/a><\/a> https:\/\/code.google.com\/p\/wwwsqldesigner\/wiki\/Installation<\/p>\n create user “sqlExample” with password ‘mypasswd’;<\/em><\/p>\n grant all privileges on database “sqlDesignerExample” TO “sqlExample” with grant option;<\/em><\/p>\n \/\/ Parameters for the application database<\/p>\n function setup_saveloadlist() {<\/em><\/p>\n Define(“HOST_ADDR”, “localhost”);\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\/\/ if the database cluster is on the same server as this application use ‘localhost’ otherwise the appropriate address (192.168.0.2 for example).<\/em><\/p>\n Define(“PORT_NO”, “5432”);\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\/\/ default port is 5432. If you have or had more than one db cluster at the same time, consider ports 5433,… etc.<\/em><\/p>\n Define(“DATABASE_NAME”, “sqlDesignerExample”); \u00a0\u00a0 \u00a0\/\/ leave as is<\/em><\/p>\n Define(“USER_NAME”, “sqlExample”);\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\/\/ leave as is<\/em><\/p>\n Define(“PASSWORD”, “mypasswd”);\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\/\/ leave as is<\/em><\/p>\n Define(“TABLE”, “wwwsqldesigner”);\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\/\/ leave as is<\/em><\/p>\n }<\/em><\/p>\n \/\/ Parameters for the database you want to import in the application<\/p>\n function setup_import() {<\/em><\/p>\n Define(“HOST_ADDR”, “localhost”);\u00a0\u00a0 \u00a0\/\/ if the database cluster is on the same server as this application use ‘localhost’ otherwise the appropriate address (192.168.0.2 for example).<\/em><\/p>\n Define(“PORT_NO”, “5432”);\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\/\/ default port is 5432. If you have or had more than one db cluster at the same time, consider ports 5433,… etc.<\/em><\/p>\n Define(“DATABASE_NAME”, “mybd”);\u00a0\u00a0 \u00a0\/\/ the database you want to import<\/em><\/p>\n Define(“USER_NAME”, “postgres”);\u00a0\u00a0 \u00a0\/\/ role having rights to read the database<\/em><\/p>\n Define(“PASSWORD”, “mypasswd”);\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\/\/ password for role<\/em><\/p>\n Cambiar php.ini: sudo leafpad php.ini en \/opt\/lampp\/etc\u00a0<\/em>(leafpad es el editor que yo uso, puede emplearse cualquier otro)<\/p>\n La extensi\u00f3n que hay que descomentar es extension=”pgsql.so”<\/em> (esa extensi\u00f3n est\u00e1 en \/opt\/lampp\/lib\/php\/extensions\/no-debug-non-zts-20121212 y \/usr\/lib\/php5\/20121212)<\/p>\n <\/a> https:\/\/code.google.com\/p\/wwwsqldesigner\/wiki\/Installation<\/p>\n create user “sqlExample” with password ‘mypasswd’;<\/em><\/p>\n grant all privileges on database “sqlDesignerExample” TO “sqlExample” with grant option;<\/em><\/p>\n \/\/ Parameters for the application database<\/p>\n function setup_saveloadlist() {<\/em><\/p>\n Define(“HOST_ADDR”, “localhost”);\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\/\/ if the database cluster is on the same server as this application use ‘localhost’ otherwise the appropriate address (192.168.0.2 for example).<\/em><\/p>\n Define(“PORT_NO”, “5432”);\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\/\/ default port is 5432. If you have or had more than one db cluster at the same time, consider ports 5433,… etc.<\/em><\/p>\n Define(“DATABASE_NAME”, “sqlDesignerExample”); \u00a0\u00a0 \u00a0\/\/ leave as is<\/em><\/p>\n Define(“USER_NAME”, “sqlExample”);\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\/\/ leave as is<\/em><\/p>\n Define(“PASSWORD”, “mypasswd”);\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\/\/ leave as is<\/em><\/p>\n Define(“TABLE”, “wwwsqldesigner”);\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\/\/ leave as is<\/em><\/p>\n }<\/em><\/p>\n \/\/ Parameters for the database you want to import in the application<\/p>\n function setup_import() {<\/em><\/p>\n Define(“HOST_ADDR”, “localhost”);\u00a0\u00a0 \u00a0\/\/ if the database cluster is on the same server as this application use ‘localhost’ otherwise the appropriate address (192.168.0.2 for example).<\/em><\/p>\n Define(“PORT_NO”, “5432”);\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\/\/ default port is 5432. If you have or had more than one db cluster at the same time, consider ports 5433,… etc.<\/em><\/p>\n Define(“DATABASE_NAME”, “mybd”);\u00a0\u00a0 \u00a0\/\/ the database you want to import<\/em><\/p>\n Define(“USER_NAME”, “postgres”);\u00a0\u00a0 \u00a0\/\/ role having rights to read the database<\/em><\/p>\n Define(“PASSWORD”, “mypasswd”);\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\/\/ password for role<\/em><\/p>\n Change php.ini: sudo leafpad php.ini en \/opt\/lampp\/etc\u00a0<\/em>(leafpad is my text editor, of course you can use any other)<\/p>\n The extension to be uncommented is\u00a0 extension=”pgsql.so”<\/em> (it can be found at \/opt\/lampp\/lib\/php\/extensions\/no-debug-non-zts-20121212 and \/usr\/lib\/php5\/20121212)<\/p>\n","protected":false},"excerpt":{"rendered":" [In English] Para terminar con esta serie de posts, esta es mi experiencia con WWW SQL Designer: WWW SQL Designer\u00a0permite importar una BD de un servidor en el entorno de dise\u00f1o, pero no permite exportar un dise\u00f1o directamente sobre una BD en un servidor. Para importar tu dise\u00f1o en una BD, la opci\u00f3n m\u00e1s sencilla … <\/p>\n
\n[In English]<\/a>
\nPara terminar con esta serie de posts, esta es mi experiencia con WWW SQL Designer:<\/p>\n\n
\n
\n
\n
\n[En espa\u00f1ol]<\/a>
\nLet’s finisht this set of posts with WWW SQL Designer:<\/p>\n\n
\n
\n
\n