Apps for education customer onsidering building database in CloudSQL: startup questions

[Tom Bonner]

We are currently preparing to build our student information database in CloudSQL and have the following questions that will dictate how we proceed:

1. Does Google plan on continuing support for PHP in the long term?
2. In order to handle security & meet our school's needs, does google recommend entirely separate instances on Cloud SQL, using Users service to enforce authorization, a bit of both (like permissions in shared DB, but data in another), or another solution?
   
3. Is Cloud SQL (assuming that SSL is set up) able to handle health data from a HIPAA privacy / security perspective?  (In otherwords, is  Cloud SQL HIPAA-compliant?)
   
4. For connecting to a Cloud SQL instance, in regards to performance, reliability, transactions, and error-handling, is GAE's rdbms module better than MySQLdb?  What may be best most useful module or package to use?
   
5. We're finding Jinja templates to work well for prototyping, but feel that Django will be best for production - is Django truly better?
   

I was looking to talk through these questions with a google rep, but here's hoping this forum will be helpful.

[Tony Tseng]

Hi Tom,

For 4, please use the MySQLdb module. See https://developers.google.com/appengine/docs/python/cloud-sql/. That should offer you higher fidelity and better performance. 

For 5, either Jinja or Django would work. I don't know which one is better in your specific situation. That's probably a question for the AppEngine user community.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-d...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/73140fdc-fd4c-4e68-9285-a0d5a986bda8%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[Joe Faith]

Hi Tom

On Tue, Nov 5, 2013 at 9:36 AM, Tom Bonner <tbo...@christinaseixacademy.org> wrote:

We are currently preparing to build our student information database in CloudSQL and have the following questions that will dictate how we proceed:

1. Does Google plan on continuing support for PHP in the long term?

Yes -- it's a core part of the platform.

The PHP runtime of GAE should shortly becoming GA, at which point it will be covered by the deprecation policy.

1. In order to handle security & meet our school's needs, does google recommend entirely separate instances on Cloud SQL, using Users service to enforce authorization, a bit of both (like permissions in shared DB, but data in another), or another solution?

Its very hard to say without knowing a lot more about your application, security requirements, and development environment, but the Users service leverages the Google authorization platform and so is an effective mechanism for user auth.

1. Is Cloud SQL (assuming that SSL is set up) able to handle health data from a HIPAA privacy / security perspective?  (In otherwords, is  Cloud SQL HIPAA-compliant?)
   

Not currently, but it is on our roadmap 

2. For connecting to a Cloud SQL instance, in regards to performance, reliability, transactions, and error-handling, is GAE's rdbms module better than MySQLdb?  What may be best most useful module or package to use?
   
3. We're finding Jinja templates to work well for prototyping, but feel that Django will be best for production - is Django truly better?
   

I was looking to talk through these questions with a google rep, but here's hoping this forum will be helpful.

See below for these questions.

Hope this helps

j

 

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-d...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/73140fdc-fd4c-4e68-9285-a0d5a986bda8%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
Joe Faith | Product Manager | Google Cloud

[Tom Bonner]

thank you--extremely helpful.

[Tom Bonner]

thank you Joe, this is a big help

On Tuesday, November 5, 2013 1:12:45 PM UTC-5, Joe Faith wrote:

Hi Tom

On Tue, Nov 5, 2013 at 9:36 AM, Tom Bonner <tbo...@christinaseixacademy.org> wrote:

We are currently preparing to build our student information database in CloudSQL and have the following questions that will dictate how we proceed:

1. Does Google plan on continuing support for PHP in the long term?

Yes -- it's a core part of the platform.

The PHP runtime of GAE should shortly becoming GA, at which point it will be covered by the deprecation policy.

1. In order to handle security & meet our school's needs, does google recommend entirely separate instances on Cloud SQL, using Users service to enforce authorization, a bit of both (like permissions in shared DB, but data in another), or another solution?

Its very hard to say without knowing a lot more about your application, security requirements, and development environment, but the Users service leverages the Google authorization platform and so is an effective mechanism for user auth.

1. Is Cloud SQL (assuming that SSL is set up) able to handle health data from a HIPAA privacy / security perspective?  (In otherwords, is  Cloud SQL HIPAA-compliant?)
   

Not currently, but it is on our roadmap 

2. For connecting to a Cloud SQL instance, in regards to performance, reliability, transactions, and error-handling, is GAE's rdbms module better than MySQLdb?  What may be best most useful module or package to use?
   
3. We're finding Jinja templates to work well for prototyping, but feel that Django will be best for production - is Django truly better?
   

I was looking to talk through these questions with a google rep, but here's hoping this forum will be helpful.

See below for these questions.

Hope this helps

j

 

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.

To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsub...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/73140fdc-fd4c-4e68-9285-a0d5a986bda8%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.