Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>First of all, there is an Erlang PostGreySQL Client here: <b><a href="https://github.com/wg/epgsql" rel="nofollow">https://github.com/wg/epgsql</a></b>. Another thing is that you may want to check out <b><a href="http://zotonic.com/" rel="nofollow">ZOTONIC</a></b>. Its a CMS written in Erlang but it is a Web framework as well. One of its features is that it has integrated PostGreySQL Database very well and so all Erlang applications behind Zotoniuc would benefit from this. It is very good when developing MVC or Event driven Web apps. <br><br>Also, you may want to check out <b><a href="http://nitrogenproject.com/" rel="nofollow">Nitrogen Web Framework</a></b> and <b><a href="http://www.chicagoboss.org/" rel="nofollow">Chicago Boss</a></b> which are also web frameworks for Erlang Web apps. I have personally developed Erlang web apps using Nitrogen, Yaws and Mnesia as a complete set. One very nice advantage is that you can have several many Erlang Applications behind this technology stack. Yaws web Server with its <b><a href="http://yaws.hyber.org/appmods.yaws" rel="nofollow">Appmods</a></b> and <b><a href="http://yaws.hyber.org/dynamic.yaws" rel="nofollow">dynamic Content Serving ability</a></b> (so <b><a href="http://www.infoq.com/articles/vinoski-erlang-rest" rel="nofollow">RESTFUL</a></b> i can assure you that), it has empowered our JavaScript Driven Frontend Web Apps with such amazing simplicity and beauty, providing Services from a bunch of several Erlang Applications.<br><br></p> <p>If you want to have a fast Web Front End , with Ajaxy/HTML5 like features , then hurry, quick! and grab your self the <b><a href="http://nitrogenproject.com/" rel="nofollow">Nitrogen Web Framework</a></b>. Since you are an Erlang Programmer already, this will be so fast for you. With Templating, you can write HTML4.X / HTML5 Templates, or use a <b><a href="http://www.webpage-maker.com/" rel="nofollow">Web page Maker/Studio Software</a></b> to create template(s) for you. Then later, you will show Nitrogen where to come in, binding your Erlang Backends to those nice Pages using Dynamically Generated <b><a href="http://jquery.com/" rel="nofollow">JQuery</a></b> Code arising from your Erlang Code.<br><br> You will find the documentation very simple. Nitrogen is just a collection of Erlang Records, with each record standing for an HTML Tag. Other records are used for defining effects and events that will be POST back into your Erlang Application. Developing Web beautiful interfaces in Nitrogen is so fast. Infact, with the dynamically generated <b><a href="http://jquery.com/" rel="nofollow">JQuery</a></b> code, you can write your own JavaScript into the Template to accompany the entire functionality say, making use of another JavaScript library like <b><a href="http://www.sencha.com/products/extjs" rel="nofollow">EXT JS</a></b>, or <b><a href="http://mootools.net/" rel="nofollow">MooTools</a></b> or <b><a href="http://www.prototypejs.org/" rel="nofollow">prototype js</a></b>. Within the template is where you will point out where Nitrogen should render the dynamically generated HTML Elements as well as JQuery which will "AJaxically" act on these elements. A template in this case simply means an HTML Page.</p> <p><br> Remember to become a member of its mailing list to find more assistance as well as keep asking any more questions here on StackOverflow. Welcome to the world of Erlang Web Development. Some several links you may be interested in (<br><b><a href="http://www.kth.se/polopoly_fs/1.162674!/Menu/general/column-content/attachment/ieee.pdf" rel="nofollow">IEEE Paper on Web Development in Erlang</a></b>,<br><b><a href="http://www.erlang-web.org/" rel="nofollow">Erlang Web Framework</a></b>,<br><b><a href="http://code.google.com/p/erlydtl/" rel="nofollow">erlydtl - Erlang Django like Templating Implementation</a></b>, <br><b><a href="https://github.com/yariv/erlyweb" rel="nofollow">ErlyWeb Framework</a></b><br>) Success ! <br><br><hr><br> <b>EDIT</b> <br>Now, what you say is actually true. Finding Developers to Maintain it would be a task. However, <a href="http://en.wikipedia.org/wiki/Zotonic" rel="nofollow"><b>Zotonic</b></a> as i mentioned earlier is a full fledged (Web) <a href="http://en.wikipedia.org/wiki/List_of_content_management_systems" rel="nofollow"><b>CMS</b></a> just as Joomla or Word Press e.t.c. With it you, yourself can actually manage/maintain the site/application. <br> <br>However, you could also develope the Web front using Django, or Ruby on Rails but create Secure Services using JSON Formatted Data to <b><a href="https://github.com/mochi/mochiweb" rel="nofollow">Mochiweb</a></b> from your Web front. Then, using <a href="https://github.com/mochi/mochiweb/blob/master/src/mochijson2.erl" rel="nofollow"><b>Mochijson2.erl</b></a> which comes with mochiweb, you parse the JSON and translate it into requests or methods and arguments in your Erlang Back-end. This would be done in both directions i.e. you make requests to your Erlang applications, get the returned results and render them as JSON data.<br> <br> Mochiweb is the powerful tool that can interface any Erlang Back End with any Web technology at the front using Service/ RESTFul Model. Its simple and light weight. Its fast and all it needs is you to point it to which methods to handle POST, GET, PUT e.t.c HTTP requests and it would wait for the results for sending back. Mochiweb has been used in very many Erlang systems e.g. <a href="http://couchdb.apache.org/" rel="nofollow"><b>Couch DB</b></a> (one of the most advanced NoSQL DBMS changing the way we understand the Web and SOA Systems) and all those other systems such as <b><a href="http://www.couchbase.org/get/couchbase/current" rel="nofollow">Membase Single Server</a></b>, <b><a href="https://cloudant.com/" rel="nofollow">Big Couch / Cloudant</a></b>, e.t.c. You could see someone putting mochiweb in action <b><a href="http://www.metabrew.com/article/a-million-user-comet-application-with-mochiweb-part-1" rel="nofollow">here</a></b>, <a href="http://www.metabrew.com/article/a-million-user-comet-application-with-mochiweb-part-2" rel="nofollow"><b>then here</b></a> and <b><a href="http://www.metabrew.com/article/a-million-user-comet-application-with-mochiweb-part-3" rel="nofollow">lastly here</a></b>.<br><br> Django, Twisted, PHP, or Ruby on Rails frameworks make JSON requests and expect JSON responses from Erlang Back ends powered by Mochiweb. Another great RESTful interface for Erlang Web Back-ends is <a href="http://code.google.com/p/misultin/" rel="nofollow"><b>Misultin</b></a>, which even supports Web Sockets and is sometimes feared to be the fastest/ or most responsive Erlang HTTP library :)<br><br> In my experience, i have worked with PHP gurus, JavaScript gurus e.t.c. but we find development cheaper whenever we put our Web server as <a href="http://yaws.hyber.org/" rel="nofollow"><b>yaws</b></a> with a <a href="http://en.wikipedia.org/wiki/Service-oriented_architecture" rel="nofollow">Service Oriented Model</a> using JSON requests and responses from both Directions. In this case we donot lose on Erlang's availability and fault tolerance and by the way, you can make many requests to as many distributed Erlang Servers even if they are hidden in different Sub nets of Domains by using <a href="http://en.wikipedia.org/wiki/JSONP" rel="nofollow"><b>JSONP</b></a> which is supported by all JavaScript and/or Front-web frameworks. I strongly advise you to put Mochiweb or Misultin in-front of your erlang Backend and have which ever Web framework you choose to make requests using JSON Format (or even XML, which you would parse using <b><a href="http://erlsom.sourceforge.net/erlsom.htm" rel="nofollow">erlsom</a></b> , download it <a href="https://github.com/willemdj/erlsom" rel="nofollow"><b>here</b></a>). I hope you do get what am suggesting. Success!!!</p>
    singulars
    1. This table or related slice is empty.
    1. POUsing OTP/Erlang as a part of the component-based architecture of a web application
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USMuzaaya Joshua
    1. USMuzaaya Joshua
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POUsing OTP/Erlang as a part of the component-based architecture of a web application
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COThanks! I have updated my question a bit.
      singulars
      1. PO
      1. USskanatek
    2. COThat was a really nice edit of your answer! Could you please refer me to some source where I can read more about "Secure Services using JSON Formatted Data to Mochiweb"? I know what Mochiweb is, but I have never hear about Secure Services in connection to Mochiweb.
      singulars
      1. PO
      1. USskanatek
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

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