Sql Admin & Email apps?

> Basically, I am wondering whether someone has made the following in
> Smalltalk/AIDA/Seaside:
> * An SQL/db administration app ... similar to phpmyadmin... or even better,
> similar to DabbleDB (http://dabbledb.com/demo/)
> * An email app
> * all open source
>
> Now for the long details:
>
> I would like to have some kind of app that allows me to manage a list of
> contacts in a database like fashion (where I can add new table columns and
> add new data to people).  Yet, at the same time, I would like to program in
> more features over time.  For example, I would like to integrate the
> database with a web based email system.  Instead of having one inbox, I'd
> have one inbox per contact in my database.  I can then add more features
> over time, like a notification if someone never responds to an email, and so
> on....
> In fact, I eventually would like to extend the database aspect to have some
> visual views of the data and who knows what else.
>
> So, I figured I could use a web framework.  Then take a pre-built sql
> admin app and a pre-built email system and combine the two with minimal
> effort.  In fact, if I was using PHP, that is exactly what I'd do; I would
> find the two apps and combine them, since it would save me so much time.
>
> Are there any "PostgreSQL admin" apps or "email apps" already made
> using Smalltalk or would I have to build a sql admin and a browser based
> email all from "scratch"?
> Has anyone done any work on an open source app similar to DabbleDB?
>
> Or... perhaps, there is some other way that I can build what I need?  like a
> CMS?
>
> Would it help if I explained the concept in more detail or if I asked this
> in a different mailing list?
>
> Thanks,
> Kevin
>
> ________________________________
> Windows Live™ SkyDrive: Get 25 GB of free online storage. Check it out.
> _______________________________________________
> seaside mailing list
> [hidden email]
> http://lists.squeakfoundation.org/cgi-bin/mailman/listinfo/seaside
>
>

> SQL is not a requirement...  just need something db like where I can attach
> new data, filter, etc... like in SQL, like in DabbleDB.
>
>> Date: Wed, 25 Mar 2009 12:32:09 -0500
>> Subject: Re: [Seaside] Sql Admin & Email apps?
>> From: [hidden email]
>> To: [hidden email]
>>
>> Note that DabbleDB doesn't use an SQL backend. Basically every session
>> gets an image.
>>
>> Celeste is a single user Squeak email client. You might want to look
>> at putting a web front-end on it.
>>
>> SQL will lead to ORM which will mean GLORP. If you are OK with
>> Postgres, you're OK in Squeak. Otherwise look at SqueakDBX. See
>> discussion this week on squeak-dev.
>>
>> If you aren't wed to SQL, there are image + logging (like Prevayler).
>> See Ramon Leon's OnSmalltalk blog.
>>
>> Also take a look at Magma. A good app to review is Gjallar (issue
>> tracker). Magma docs are on the wiki.
>>
>> 2009/3/25 Kevin Ar18 <[hidden email]>:
>> > Basically, I am wondering whether someone has made the following in
>> > Smalltalk/AIDA/Seaside:
>> > * An SQL/db administration app ... similar to phpmyadmin... or even
>> > better,
>> > similar to DabbleDB (http://dabbledb.com/demo/)
>> > * An email app
>> > * all open source
>> >
>> > Now for the long details:
>> >
>> > I would like to have some kind of app that allows me to manage a list of
>> > contacts in a database like fashion (where I can add new table columns
>> > and
>> > add new data to people).  Yet, at the same time, I would like to program
>> > in
>> > more features over time.  For example, I would like to integrate the
>> > database with a web based email system.  Instead of having one inbox,
>> > I'd
>> > have one inbox per contact in my database.  I can then add more features
>> > over time, like a notification if someone never responds to an email,
>> > and so
>> > on....
>> > In fact, I eventually would like to extend the database aspect to have
>> > some
>> > visual views of the data and who knows what else.
>> >
>> > So, I figured I could use a web framework.  Then take a pre-built sql
>> > admin app and a pre-built email system and combine the two with minimal
>> > effort.  In fact, if I was using PHP, that is exactly what I'd do; I
>> > would
>> > find the two apps and combine them, since it would save me so much time.
>> >
>> > Are there any "PostgreSQL admin" apps or "email apps" already made
>> > using Smalltalk or would I have to build a sql admin and a browser based
>> > email all from "scratch"?
>> > Has anyone done any work on an open source app similar to DabbleDB?
>> >
>> > Or... perhaps, there is some other way that I can build what I need?
>> > like a
>> > CMS?
>> >
>> > Would it help if I explained the concept in more detail or if I asked
>> > this
>> > in a different mailing list?
>> >
>> > Thanks,
>> > Kevin
>> >
>> > ________________________________
>> > Windows Live™ SkyDrive: Get 25 GB of free online storage. Check it out.
>> > _______________________________________________
>> > seaside mailing list
>> > [hidden email]
>> > http://lists.squeakfoundation.org/cgi-bin/mailman/listinfo/seaside
>> >
>> >
>> _______________________________________________
>> seaside mailing list
>> [hidden email]
>> http://lists.squeakfoundation.org/cgi-bin/mailman/listinfo/seaside
>
> ________________________________
> Hotmail® is up to 70% faster. Now good news travels really fast. Find out
> more.

> Date: Wed, 25 Mar 2009 21:50:37 +0100
> From: [hidden email]
> To: [hidden email]
> Subject: Re: [Seaside] Sql Admin & Email apps?
>
> Hi!
>
> In short!
> Have a look at www.query-vision.com.
>
> It even gives you the abillity to implement small datavie and analysis apps.
> So far as I know .csv, Access, MySQL, DB2 and Oracle are supported.
> It's in development stage but steadily evolving.
>
> Cheers!
> Sebastian
>
>
> ___________________________________________________________
> Telefonate ohne weitere Kosten vom PC zum PC: http://messenger.yahoo.de
>
> _______________________________________________
> seaside mailing list
> [hidden email]
> http://lists.squeakfoundation.org/cgi-bin/mailman/listinfo/seaside