What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Can I use Postgresql with Jotform Application?

    Asked by nkitson on January 28, 2011 at 08:17 AM

    Hi,

    Great looking product.  I'm thinking of licencing Jotform Application.  I'm considering integrating it with our application which uses postresql.  Would it be fairly easy to modify Jotform to use postgesql?

    Thanks,

    Nick

  • Profile Image
    JotForm Founder

    Answered by aytekin on January 28, 2011 at 09:29 AM

    JotForm Application uses Mysql Innodb database. So, it might require some code changes before you can use it with postresql.

  • Profile Image

    Answered by nkitson on January 28, 2011 at 09:52 AM

    Hi, thanks for the quick response.  I'm sure 'some' code changes will be required but I'm interested to get a feel for how much work will be required which depends to an extent on how JotForm has been written.

     

    Is there a developer who could be a little more specific?  I don't want to buy the licence and find that its just not practical.

    Thanks,

    Nick

  • Profile Image
    JotForm Founder

    Answered by aytekin on January 28, 2011 at 10:07 AM

    I also write code for JotForm, so I can talk about code related issues. Unfortunately, nobody in the JotForm Team is very familiar with postresql. If you would like I can send you JotForm schema and you can take a look at it yourself. Please email us for further discussion. 

  • Profile Image

    Answered by nkitson on January 28, 2011 at 10:16 AM

    That would be great - many thanks, will email to you.

  • Profile Image

    Answered by nkitson on February 08, 2011 at 10:39 AM

    Hi Aytekin,

    Did you get my follow up email on Feb 4th?

    Thanks

  • Profile Image
    JotForm Founder

    Answered by aytekin on February 08, 2011 at 11:59 AM

    Yes, I received. I will answer to it as soon as possible. 

  • Profile Image

    Answered by Nick on May 19, 2011 at 08:40 AM

    Hi, I stumbled on this thread from a google search.

    I too would like to use JotForm with postgresql, and I'm considering purchasing the JotForm Application license today - can you email me the schema please?

    On a related note, is all the database code contained in one or two files, or is it distributed throughout the codebase?

    Many thanks

  • Profile Image
    JotForm Support

    Answered by NeilVicente on May 20, 2011 at 02:55 AM

    Hi Nick,

    Thank you for taking interest in Jotform Application. Since Jotform Support members do not have access to what you're asking for, I have submitted a ticket to have this escalated to the proper department who can handle your request.  Thank you for your patience.


    Neil

  • Profile Image
    JotForm Founder

    Answered by aytekin on May 20, 2011 at 03:36 AM

    I too would like to use JotForm with postgresql, and I'm considering purchasing the JotForm Application license today - can you email me the schema please?

    Unfortunately no, it is not possible to use JotForm with postgresql. It requires Mysql Innodb.However, since it comes with full source code, you are free to modify it and make it work with postgresql.

    I have just emailed you the schema.

    On a related note, is all the database code contained in one or two files, or is it distributed throughout the codebase?

    They are distributed throughout the codebase.

  • Profile Image

    Answered by clarioncall on May 20, 2011 at 01:34 PM

    Hi Aytekin,

    Can you clarify how your licence works, specifically how 'users' are counted?

    We are considering integrating Jotform in to our online text and email application.  The application resides on a single server.  We have numerous customers ('Users' in your context?) although the ability to create Jotforms would be an optional feature so not all our customers would use it.  

    Our users would not be required to log in to Jotform (we have a very experienced developer and are not expecting significant problems modifying the code)  Is there any code which cannot be removed, that is intended to stop a customer having more than 100/1000 users, that would prevent us from integrating the application as I describe?

    FYI, I expect to use JotForm for creating and submitting the form but not for displaying the results or reporting.

    Final question! - we have a development server and a live server - does the licence allow us to use JotForm on both servers at the same time (The development server is a PC.  It is exposed to the internet but there is no customer access)

    Thanks for your advice,

    Nick

    (ps, I'm the same Nick that started this thread)