[SqueakDBX] Call for ideas for DBXTalk UI

[Lorenzo Schiavina]

Hi Mariano,

we have been using for years this product http://www.dbtools.com.br/EN/; all clients of us have been satisfied with it.

Ciao

Lorenzo
  ----- Original Message ----- 
  From: Mariano Martinez Peck 
  To: Pharo Development ; squeakdbx ; A friendly place where any question about pharo is welcome ; glorp-group at googlegroups.com 
  Sent: Wednesday, May 11, 2011 12:39 AM
  Subject: [SqueakDBX] Call for ideas for DBXTalk UI


  Hi guys. Thanks to the ESUG SummerTalk,  DBXTalk team has started to work with the new products of the DBXTalk suite. However, for one of the tools in special we would like to hear your opinion. Just a little introduction to the two other tools:

  1) A new Glorp port from VW to Pharo. In addition, we provide the DBX driver for Glorp, by the name of GlorpDBX. Guillermo Polito is mostly working on this.
  2) A new tool that uses Magritte and the database metadata to automatically generate the mappings between objects and tables. The idea is to do it two-way:
  a) read the metadata from an existing database -> create magritte descriptions -> generate Glorp mappings -> query with Glorp
  b) write magritte descriptions for the mappings -> generate database schema -> generate Glorp mappings -> query with Glorp
  or something like that....it is not completely decided but that's the idea. This way we can autogenerate the Glorp mappings and then use Glorp normally. Santiago Bragagnolo is working mostly on this.

  The third product, and here the question, is going to be a UI for the DBXTalk suite. This UI would do the core functionalities of tools like SQLDeveloper, MySQL Explorer, pgAdmin, etc. This is basically: 
  - visualize and get information of: tables, views, schemas, relations, indexes, etc. 
  - be able to modify the previous items and impact them in the database
  - write queries and get results

  So...why this tool if we can also use external tools like SQLDeveloper, MySQL Explorer, pgAdmin, etc ?  a couple of reasons:
  1) having the tool inside the image is easier (just the same way you sometimes install an Eclipse plugin instead of using such programs)
  2) the same tool works for all databases
  3) we can customize it with particular things of DBX
  Gisela Decuzzi is working mostly on this.

  Now....what use cases do you think are useful for such UI ? what kind of things would you like ?  what things we can do that are related to Glorp and to the magritte tool? 
  what things can we do to have even more advantages than just using external programs ?  I have the following things in mind:

  - Special console for DBX/Glorp logs.
  - Be able to edit Magritte description for mappings. 
  - Sync the tables and mapping while edditing.
  - A new inspector for inspecting restultsets, where you see one rows and columns. 

  Let us know.

  Once again, thanks ESUG for the sponsorship to the team.
     

  Mariano
  http://marianopeck.wordpress.com




------------------------------------------------------------------------------


  _______________________________________________
  SqueakDBX mailing list
  SqueakDBX at lists.squeakfoundation.org
  http://lists.squeakfoundation.org/mailman/listinfo/squeakdbx
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.squeakfoundation.org/pipermail/squeakdbx/attachments/20110511/65d0517c/attachment-0001.htm