Can I use Postgresql with Jotform Application?

  • Profile Image
    nkitson
    Asked 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
    aytekin
    Answered 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
    nkitson
    Answered 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
    aytekin
    Answered 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
    nkitson
    Answered on January 28, 2011 at 10:16 AM

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

  • Profile Image
    nkitson
    Answered on February 08, 2011 at 10:39 AM

    Hi Aytekin,

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

    Thanks

  • Profile Image
    aytekin
    Answered on February 08, 2011 at 11:59 AM

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

  • Profile Image
    Nick
    Answered 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
    NeilVicente
    Answered 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
    aytekin
    Answered 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
    clarioncall
    Answered 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)