Python Database Apps

[Prateek]

Re: Python Database Apps

On Sep 13, 4:55 am, Ed Leafe <e...@leafe.com wrote:

On Sep 12, 2007, at 10:53 AM, darien.watk...@ gmail.com wrote:
>

Thanks for ideas Ed. I am checking out dabo now. I do have a few
questions about it. Packaging. Is it easy to package into a quick
install for windows. The users are going to want to get too in
depth.

>
py2exe is your friend here. I know several developers who have used
this to distribute Dabo apps, so we could certainly help you get your
setup.py working.
>

Second, data sources. When I'm adding a data source to the
window in class designer, it always picks up the one I created (which
incidentally was a sample, my form for connection manager isn't
working at the moment.) My idea is to have the the local sqlite
database as the only viewable data source, and the server side only
for syncing. So they logon, sync up, sync down, and view. I'm
worried about having to get them to install python, dabo, and the app.

>
The users would never see any of the Class Designer, connection
editor, or any of the other development tools. I would imagine that
you would need to code the sync parts by getting the current changed
data from the local SQLite database, creating a connection to the
server DB, doing the insert/update as needed, grabbing the latest
from the server, disconnecting from the server, and then updating the
local data. The user would probably need to do nothing more than
click a button to start running your code.
>
As far as what the user must install, that's what will happen with
any Python solution. py2exe takes care of all of that, bundling
Python, Dabo, your database modules, and any other dependencies into
a single .exe file. You can then use something like Inno Setup to
create a basic Installer that will look and work like any other
Windows application installer.
>
-- Ed Leafe
--http://leafe.com
--http://dabodev.com

Have you checked out Brainwave?

http://www.brainwavelive.com

We provide a schema-free non-relational database bundled with an app
server which is basically CherryPy with a few enhancements (rich JS
widgets, Cheetah/Clearsilver templates). Free for non-commercial use.



--Prateek Sureka

[Jonathan Gardner]

Re: Python Database Apps

On Sep 12, 9:38 pm, Prateek <sure...@gmail. comwrote:

Have you checked out Brainwave?http://www.brainwavelive.com
>
We provide a schema-free non-relational database bundled with an app
server which is basically CherryPy with a few enhancements (rich JS
widgets, Cheetah/Clearsilver templates). Free for non-commercial use.
>

You might want to rethink how you are handling databases. What sets
your database apart from hierarchical or object-oriented databases? Do
you understand why people prefer relational databases over the other
options? There's a reason why SQL has won out over all the other
options available. You would do well to understand it rather than
trying out things we already know do not work.

[Prateek]

Re: Python Database Apps

On Sep 14, 1:00 am, Jonathan Gardner
<jgardner.jonat hangardner....@ gmail.comwrote:

On Sep 12, 9:38 pm, Prateek <sure...@gmail. comwrote:
>

Have you checked out Brainwave?http://www.brainwavelive.com

>

We provide a schema-free non-relational database bundled with an app
server which is basically CherryPy with a few enhancements (rich JS
widgets, Cheetah/Clearsilver templates). Free for non-commercial use.

>
You might want to rethink how you are handling databases. What sets
your database apart from hierarchical or object-oriented databases? Do
you understand why people prefer relational databases over the other
options? There's a reason why SQL has won out over all the other
options available. You would do well to understand it rather than
trying out things we already know do not work.

I didn't mention any details in my previous post. Basically, the
Brainwave database is very similar to an RDF triple store which
captures semantic information.
There are some fundamental differences however, (e.g. a simplified
API, no schema, ability to store objects by introspecting and breaking
it up into its primitives etc.)

In general, it works well if you're dealing with a lot of unstructured
data or even semi-structured/structured data where the structure is
constantly changing. Key areas of benefit are in terms of integrating
legacy databases and also analytics heavy applications. This is
because there is no concept of normalized/denormalized schemas so your
data does not need to go through any structural transformations in
preparation for OLAP use.

Since we're new, I probably won't recommend using it with very very
large data-sets. However, we've seen significant benefits with small
and medium sized data-sets. At any rate, whatever you choose, you can
import and export all data in CSV/XML at any time so your data is
safe.

Some of the benefits I have described above have been shown to be
areas of concern when dealing with SQL stores. There is a lot of
research and many opinion pieces available on this subject. I'd be
happy to discuss any aspect with you further.

Sorry for the delayed response. I've been in and around airplanes for
the last 24 hours (and its not over yet).

-Prateek