Today’s guest post comes from Maarten Balliauw, Technical Evangelist at JetBrains, the vendor of smart developer tools such as IntelliJ IDEA, PyCharm, PhpStorm, Android Studio and many more. At JetBrains we are building tools that aim to enhance developers’ productivity by automating routine tasks and helping you concentrate on coding.
Our IDE for PHP,
PhpStorm, provides seamless integration with
Google App Engine for PHP — allowing you to locally develop, debug and deploy your PHP applications on Google App Engine. When testing your application locally, we also support full emulation of App Engine services through the App Engine Development server.
The following video shows how to get started with Google App Engine for PHP in PhpStorm. We also have a
comprehensive tutorial which covers Google App Engine with PhpStorm in detail.
When creating
Google App Engine applications in PHP using PhpStorm, chances are that you’ll also be using
Google Cloud SQL to store data. For these next steps, we will have assumed you have
created a Cloud SQL instance from the Google Cloud Console.
PhpStorm, as well as IntelliJ IDEA and PyCharm, provides database management tools (see the right-hand side of the IDE or hit
Ctrl+Alt+A (Cmd+Alt+A on Mac) and search for “Database”). You can use these built-in tools to create new tables, run arbitrary SQL commands and insert, update and delete data.
Opening the database pane, you can create a new connection or Data Source. You’ll have to specify the JDBC database driver to be used to connect to our database. Since
Google Cloud SQL supports native MySQL connections, we can use the standard MySQL connector and enter connection details.
 |
| Connecting to a Google Cloud SQL database using PhpStorm database tools |
The JDBC driver to use is com.mysql.jdbc.Driver, the database URL will be jdbc:mysql://
:3306/ where cloudsql_ip_address is the IP address of our Google Cloud SQL instance, and database_name is the name of the specific database on that instance to which you want to connect.
As for database credentials, you can create a root user password through the Google Cloud Console or manually create a new user through PhpStorm using the following SQL statement:
CREATE USER user_here@% IDENTIFIED BY password_here;
GRANT ALL PRIVILEGES ON *.* TO user_here@% WITH GRANT OPTION;
You can now make use of these new credentials to connect to Google Cloud SQL and do things like create tables.
 |
| Creating a table in Google Cloud SQL using PhpStorm database tools |
Now, from our PHP code, you can easily
create a new connection to our Google Cloud SQL instance using PDO:
 |
| Connecting to a Google Cloud SQL database using PDO |
Give it a try (a trial version is available for
PhpStorm) and let us know your thoughts through the comments below.
-Contributed by Maarten Balliauw, Technical Evangelist, JetBrains
Leopard finally gets its second patch, and boy does it fix a lot of stuff. The first patch hit back in November, with test builds of the second making it out a month later.
Smartphone Sony Xperia Ion mulai pre-order di USA. Smartphone Sony Xperia Ion yang baru diperkenalkan dengan peningkatan spesifikasi dan fasilitas untuk handphone 2012, mulai di jual terbatas di negara USA. melalui pemesanan pre-order untuk mendapatkan handphone Sony Xperia Ion Baru yang menawarkan keunggulan teknologi high-end, smartphone keren Sony Xperia Ion akan tersedia sebagai versi unlocked di pasar AS. Penjualan pre-oder versi unlocked smartphone baru Sony Xperia Ion dapat akan muncul dengan harga $ 569,50.
Picky netbook users will be drawn to its 12 inch widescreen, questioning whether its a netbook. The size of the screen and its 1.280 by 800 resolution dont suffer the same limitations as a 10 inch screen with a 1,024 by 600 resolution (scrolling, for instance, is minimized with long web pages and Adobes Photoshop CS series has a 1.024 by 768 resolution requirement). Its not unusual, though, as all of its 12 inch peers possess the same screen characteristics.
Merlin: The Complete Second Season
Merlin: The Complete First Season
Samsung announced the Samsungs DualView TL225 and TL220 Digital Cameras gadget. What makes these two new digital cameras stand out is the Dual LCDs one at the front and one at the back. Both cameras features a 1.5-inch LCD display on the front which enables the users to take self-portraits and profile pictures with ease. On the back you will find a 3.5-inch wide touchscreen LCD display on the TL225 and on the TL220 you will find a 3.0-inch touchscreen LCD display. Both Cameras also comes with Schneider-KREUZNACH lens and the option to shoot 720p HD / H.264 videos however the TL225 comes with an optional HDMI Port.
Battery life isnt as impressive as other Sony Walkmans and the screen is tiny, but the B-Series hits the mark with an array of features suitable for on the go use.
Calculate complex equations, track shipments, build a Web site, and more--all on Google. Plus, how not to move a palm tree.
