Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [google-app-engine]

17 questions
17
votes
2 answers

Get and Put performance testing on Google BigTables (and other integrated DBs)

What are some effective ways to perform programmatic performance testing on database operations, especially in environments where the databases themselves do not offer dedicated tools? For example, in Google App Engine, entire page-loads are…
Brian Ballsun-Stanton
  • 4,731
  • 2
  • 30
  • 36
12
votes
1 answer

What are the performance implications of polymodels versus normal Bigtable models in Google App Engine?

What produces the best performance in regular Google App Engine use, a polymodel or a normal "Bigtable" model? The polymodel, effectively, creates a column in the parent table called "class" which provides the inheritance tracking. Whereas a normal…
Brian Ballsun-Stanton
  • 4,731
  • 2
  • 30
  • 36
9
votes
2 answers

In Google App Engine, what is the most effective many-to-many join model?

The BigTable design rejects many of the philosophies of standard relational models, explicitly preferring denormalization to a big host of tiny tables. One of the larger areas where this is a problem is in the modelling of many to many joins. One…
Brian Ballsun-Stanton
  • 4,731
  • 2
  • 30
  • 36
4
votes
3 answers

google database api

I would like to use my google account to store so data (time series) Is there an easy way to do it? I use R and if possible would like to create/use and API to send and receive data from/to R and from/to my google account EDIT: I want to have an…
RockScience
  • 398
  • 2
  • 5
  • 14
3
votes
2 answers

How to connect external database to AppEngine?

Are there any ways (better than using UrlFetch) to connect to any external database from AppEngine? I already know about hosted SQL databases in App Engine for Business, but they are not free and will be avialable in Q2 2011, so it's not an option…
Alex Bolotov
  • 371
  • 4
  • 9
2
votes
1 answer

How to migrate data from Google AppEngine Datastore

How to migrate data from Google AppEngine's Datastore to other database (not Datastore)? There is appcfg.py download_data but it produces sqlite3 file with empty bulkloader_database_signature and useless result tables.
Alex Bolotov
  • 371
  • 4
  • 9
1
vote
0 answers

X-devAPI not working inside of Google cloud SQL

I am tryng to use X-devAPI inside of Google cloud SQL but getting the following error from MySQL client comp@user:~$ sudo mysqlsh -u root -h XX.XXX.XX.XXX --mysql --dba enableXProtocol [sudo] password for philo: Creating a Classic session to…
Geek Guy
  • 111
  • 2
1
vote
1 answer

how to config SSRS 2005 email setting with google apps

My Company recently switches email service to google apps (asp.google.com). all the current subscriptions in SSRS2005 are configured to MS exchange server and no longer workable. Do someone knows how to configure subscriptions to google apps. Thanks…
user1188125
  • 223
  • 2
  • 7
1
vote
1 answer

Google Datastore model User and Messages efficently

I have two kinds: USER and MESSAGES. A user can send/receive many messages to/from another user. Thinking in a relational way the relationship would suggest a user can have many messages, and a message can only be created by one user. So if user A…
user2924127
  • 305
  • 2
  • 11
1
vote
0 answers

Data Model for a popular/basic type of social app

I am trying to learn about Google Datastore and creating a basic application to have some practical experience with it opposed to just reading the docs. I would like to create a basic social application where users can send messages to their friends…
user2924127
  • 305
  • 2
  • 11
1
vote
2 answers

Connecting to Google Cloud SQL via SSH

The network I'm using doesn't allow port 3306 so I can't connect to Google Cloud SQL. How do I set up a proxy server (on a different network that allows 3306) that I could connect to via SSH to communicate with GCS directly using Navicat/MySQL…
Eustace
  • 125
  • 1
  • 4
1
vote
2 answers

MYSQL Row Count Limits?

What is the maximum row count for a table in MYSQL? I have a system with around 600,000,000 rows in three tables. Average Data Length (from data_length column) for these tables is 58,000,000,000 bytes. Upon reaching how many rows should there be an…
Michael Massey
  • 111
  • 1
  • 4
0
votes
1 answer

How to store multiple vendor data in Google Cloud SQL?

I am designing a mobile app in which I need to host my vendor data and give access to that data after analysis to only the specified users. Since I will have multiple vendors with different set of data and users, should I have multiple database 1 of…
Vic
  • 103
  • 4
0
votes
1 answer

How do you make manual/one-off log-based queries?

My app engine instances are logging incoming requests and I'd like to be able to run manual/one-off queries for data analysis. As an example, I would like to be able to determine how many requests are made to each end-point, within a given…
pleasedesktop
0
votes
1 answer

App Engine - Datastore ; Exclude columns on backup

I want to backup a table without some columns. Can I exclude column/s? Is there any way to do this?
Yalcin Yavas
1
2