Re: newbie questions

Thanks for the info James.  I will look into the tools you suggest.  I do have some level of programming but more of a hack than formal training.  I wrote a homebrew application in the 90's using Borland Delphi and I wrote an iPhone app a few years back to see if I could get it through apple, which I did.  The challenge... I am just confused on the different levels.  What to use for the interface, reporting, etc. with Google as the database.  You gave me some great info, thanks!

Dave

On Friday, June 28, 2013 4:07:58 AM UTC-7, James May wrote:

David,

Unfortunately, you are going to be diving into programming land. Google cloud sql is basically mysql in the cloud. So any book teaching you mysql would work. There are products such as navicat that allow database management with reporting. The problem is that I do not believe that navicat or similar products can connect to google cloud sql because of the driver needed to connect. There are other database management tools such as mysql workbench and dbvisualizer. You should have no problem connecting with squirrel sql and db visualizer because they can be configured with the google java jdbc driver.

The web ui will involve programming. No easy way around that one. I typically use java web development with jsf and primefaces.

My suggestion to you would be to start small. Take the cloud out of it. Cloud is a whole a different beast on top of traditional development. It is a whole different mind shift because of what you can and cannot do. Start with mysql and simple web development on a local server and then branch out from that point.

James May
Co-founding Partner
Bizznetworx Online
http://www.bizznetworxonline.com

On Jun 27, 2013 11:03 PM, "David Kern" <davek...@gmail.com> wrote:

I have a database in MS Access that I wrote about 7 years ago and have been updating to some extent since then.  It has about 30 tables all linked together, many queries and forms and is broken into a front-end and back-end.  I want to migrate this to the web and update the technology in a rewrite.  I am considering Google Cloud SQL as the cloud backend.  I am not a programmer by trade but have been a tinkerer since jr high.  Three big questions as this is new and I don't want to ask too many dumb questions.  Can anyone recommend:

• A good book on creating this type of database in the cloud
• Recommendations on what I should use for my user interface.  Very confused here as I want to to be web based and run in a browser.
• What tool I should use to generate reports?

I know Access sucks but the user interface and reports are easy.  I need to understand this in the context of the cloud and I am a bit confused.

Thanks for any help!

 
 

--
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+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.