Anybody interested in a Datastore Manager for GAE?

498 views
Skip to first unread message

Backpack

unread,
Aug 8, 2012, 5:41:52 PM8/8/12
to Google App Engine
Something like phpMyAdmin for MySQL but adapted to the datastore.
If so, answer these questions:

- What datastore: db, ndb or SQL?
- How much would you pay for that?
- Pay once use forever with yearly versions? ~$100/ver
- or pay monthly with free updates? ~$10/mo
- web based or desktop app?

I am thinking on doing one with the latest HTML,CSS,JS stuff (sorry
IE) and just wanted to see if there was any interest in a tool like
that. The data viewer and data admin stuff offered by gae are limited
in functionality.

Thanks for your time in answering the questions.

Drake

unread,
Aug 8, 2012, 6:56:53 PM8/8/12
to google-a...@googlegroups.com
Possibly. The Admin Console does suck, I would be happy to look at some
screen shots, see what you bring to the table. We'd rather pay once.

When we looked in to this, the challenge was really that the datastore calls
add up fast.
> --
> You received this message because you are subscribed to the Google Groups
> "Google App Engine" group.
> To post to this group, send email to google-a...@googlegroups.com.
> To unsubscribe from this group, send email to google-
> appengine+...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/google-appengine?hl=en.



Emanuele Ziglioli

unread,
Aug 8, 2012, 7:06:20 PM8/8/12
to google-a...@googlegroups.com
Something like AppWrench would be nice! it's a shame it looks like abandonware at the moment

Backpack

unread,
Aug 8, 2012, 7:24:07 PM8/8/12
to Google App Engine
Here is a mockup of what I envision:

http://georgenava.appspot.com/static/images/datamanager.png

It fits better the table model of MySQL but right now it works with
the datastore just fine.

Inline editing, SQL console, import, export, and all the stuff, will
be a huge undertaking, that's why I want to measure initial response.

Thanks for your feedback.
Message has been deleted

Emanuele Ziglioli

unread,
Aug 9, 2012, 5:55:42 PM8/9/12
to google-a...@googlegroups.com
it looks really good.

I've used the evaluation of AppWrench and have found very useful the ability to edit both local and remote store. I find painful you can't add fields to an existing entity from the official web console (or can you?).

Haven't been able to run the profiler but I'd love to have tools like AppWrench in order to profile memory usage and other parameters that are unique to the GAE's production environment and that are not currently covered by AppStats.
Although, that'd be outside the focus of your project I suspect.

Cesium

unread,
Aug 10, 2012, 11:58:50 AM8/10/12
to google-a...@googlegroups.com
After studying your mockup, I would be very interested in joining you for lunch at Mortons. Wow!

Arvind S

unread,
Jun 7, 2014, 5:02:35 PM6/7/14
to google-a...@googlegroups.com
Why dont we guys have a discussion and start a opensource project for this. Either a Eclipse Plugin or Chrome Extension? What you guys think ?

Doug Anderson

unread,
Jun 20, 2014, 11:09:02 PM6/20/14
to google-a...@googlegroups.com
If the Admin Console would add support for editing repeated fields I'd be a happy camper.  That's the primary reason I have to do custom admin pages.  I've also implemented my own bulk upload for HRD... my implementation isn't terribly generic though.

Vinny P

unread,
Jun 21, 2014, 8:52:22 AM6/21/14
to google-a...@googlegroups.com
On Sat, Jun 7, 2014 at 4:02 PM, Arvind S <arvin...@gmail.com> wrote:
Why dont we guys have a discussion and start a opensource project for this. Either a Eclipse Plugin or Chrome Extension? What you guys think ?


If this is being done, I'd prefer it packaged as a WAR or other form of ready-to-deploy web app. Making it a Eclipse or Chrome extension makes it difficult to make changes when on the road/otherwise unable to get access to one's main dev machine.

 
-----------------
-Vinny P
Technology & Media Advisor
Chicago, IL

App Engine Code Samples: http://www.learntogoogleit.com

Rafael

unread,
Jun 21, 2014, 1:20:49 PM6/21/14
to google-appengine

Depends on what language to support. My feedback is based on java.

You could bundle as a simple jar that you define on your web.xml. similar to what pipeline does.

If you build on java and the jar is in the classpath, it would be great because you can edit the multiple rows and then use reflection to edit also serialized objects inside the row fields. That would be really powerful.

Something that I built custom and I use a lot is a mapreduce task that updates all objects using code that I type on a web console. Its like the bigtable version of the update sql command :)
The benefit of having it on a web console is that I don't need to go through all the hassle of doing another release just to run some simple db update. It's also well tested and I know its going to work and be maintained.

Rafa

On Jun 20, 2014 7:47 AM, "Arvind S" <arvin...@gmail.com> wrote:
Why dont we guys have a discussion and start a opensource project for this. Either a Eclipse Plugin or Chrome Extension? What you guys think ?

--
You received this message because you are subscribed to the Google Groups "Google App Engine" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-appengi...@googlegroups.com.

To post to this group, send email to google-a...@googlegroups.com.

Emanuele Ziglioli

unread,
Jun 21, 2014, 9:05:27 PM6/21/14
to google-a...@googlegroups.com
I don't know if you guys remember AppWrench. I've found what looks like its source code on Google Code:

It was a very good project but it doesn't work anymore on Eclipse's current version.
So, I thought we could contact its original author and ask what his plans are about it.
It could be a good start for an Eclipse plugin

Adam Wildavsky

unread,
Jun 22, 2014, 6:58:38 PM6/22/14
to google-a...@googlegroups.com
I would pay what you propose for this if it supported ndb -- either payment model would be fine.

I have no preference for desktop vs web, except that for me it needs to run on MacOS. Web might be easiest unless you know a good environment for cross platform Linux/Mac/Windows desktop app development. 

Emanuele Ziglioli

unread,
Jun 25, 2014, 10:59:19 PM6/25/14
to google-a...@googlegroups.com
SDK 1.9.7, from this video https://www.youtube.com/watch?v=1jcgYI7rlCg. will bring a local console that matches the cloud console.
Also they're showing a new "Big Data" menu, related to the new "Data Flow" API (a new Hadoop).

I wonder how easy will be to use Docker, and whether or not it'll be required, or even mandatory.

Emlyn

unread,
Jun 26, 2014, 11:11:16 PM6/26/14
to google-a...@googlegroups.com
Great idea, I'm interested too.

There's always the issue that datastore objects have code associated
with them, that you can't tend to touch in a console. But that's ok I
think.

ndb is my datastore of choice.

I'd like to see one that you could upload as an alternate "version" of
your codebase, so it can get right in there and do anything your code
can do.
> --
> You received this message because you are subscribed to the Google Groups "Google App Engine" group.
> To post to this group, send email to google-a...@googlegroups.com.
> To unsubscribe from this group, send email to google-appengi...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en.
>



--
Emlyn

http://point7.wordpress.com - My blog
https://plus.google.com/u/0/100281903174934656260 - Google+
Reply all
Reply to author
Forward
0 new messages