Analyzing database

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
12 messages Options
Reply | Threaded
Open this post in threaded view
|

Analyzing database

abergel
Hi!

I am wondering if any of you is using Roassal and/or Moose to analyze data bases?

Cheers,
Alexandre
-- 
_,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:
Alexandre Bergel  http://www.bergel.eu
^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;.




_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev
Reply | Threaded
Open this post in threaded view
|

Re: Analyzing database

Anne Etien
Hi,

Yes we will. We are, Olivier Auverlot and me, currently rewriting a parser and everything that goes with for Postgres. We rewrite it from the beginning having a look on SQLLite, because PetitParser is really hard to debug and we wanted to understand what we are doing. Olivier is also database administrator of the lab and he has some issues that we want to solve with these analyses. We already defined a Famix Model for Database and we are currently generating model with tables taking into account lot of different types and constraints (that’s the beginning). The project goes slowly since we are working maximum 6h per week. 
We will then certainly use Roassal for the visu.

Why are you asking the question?
Cheers,
Anne

Le 8 oct. 2014 à 15:10, Alexandre Bergel <[hidden email]> a écrit :

Hi!

I am wondering if any of you is using Roassal and/or Moose to analyze data bases?

Cheers,
Alexandre
-- 
_,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:
Alexandre Bergel  http://www.bergel.eu
^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;.



_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev


_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev
Reply | Threaded
Open this post in threaded view
|

Re: Analyzing database

abergel
I am just asking to understand where effort are put on in the Moose ecosystem.
Visualizing databases may also be a nice chapter for agile visualization.

Alexandre
-- 
_,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:
Alexandre Bergel  http://www.bergel.eu
^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;.



On Oct 8, 2014, at 10:42 AM, Anne Etien <[hidden email]> wrote:

Hi,

Yes we will. We are, Olivier Auverlot and me, currently rewriting a parser and everything that goes with for Postgres. We rewrite it from the beginning having a look on SQLLite, because PetitParser is really hard to debug and we wanted to understand what we are doing. Olivier is also database administrator of the lab and he has some issues that we want to solve with these analyses. We already defined a Famix Model for Database and we are currently generating model with tables taking into account lot of different types and constraints (that’s the beginning). The project goes slowly since we are working maximum 6h per week. 
We will then certainly use Roassal for the visu.

Why are you asking the question?
Cheers,
Anne

Le 8 oct. 2014 à 15:10, Alexandre Bergel <[hidden email]> a écrit :

Hi!

I am wondering if any of you is using Roassal and/or Moose to analyze data bases?

Cheers,
Alexandre
-- 
_,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:
Alexandre Bergel  http://www.bergel.eu
^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;.



_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev

_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev


_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev
Reply | Threaded
Open this post in threaded view
|

Re: Analyzing database

Thierry Goubier
In reply to this post by Anne Etien
Hi Anne,

I'd be interested if you can share your parser effort, especially if I can push it to the SmaCC repository.

What do you find hard to debug with PetitParser? How are you doing it then?

Thierry

2014-10-08 15:42 GMT+02:00 Anne Etien <[hidden email]>:
Hi,

Yes we will. We are, Olivier Auverlot and me, currently rewriting a parser and everything that goes with for Postgres. We rewrite it from the beginning having a look on SQLLite, because PetitParser is really hard to debug and we wanted to understand what we are doing. Olivier is also database administrator of the lab and he has some issues that we want to solve with these analyses. We already defined a Famix Model for Database and we are currently generating model with tables taking into account lot of different types and constraints (that’s the beginning). The project goes slowly since we are working maximum 6h per week. 
We will then certainly use Roassal for the visu.

Why are you asking the question?
Cheers,
Anne

Le 8 oct. 2014 à 15:10, Alexandre Bergel <[hidden email]> a écrit :

Hi!

I am wondering if any of you is using Roassal and/or Moose to analyze data bases?

Cheers,
Alexandre
-- 
_,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:
Alexandre Bergel  http://www.bergel.eu
^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;.



_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev


_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev



_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev
Reply | Threaded
Open this post in threaded view
|

Re: Analyzing database

Tudor Girba-2
In reply to this post by abergel
I have used it to visualize data in the database. I used DBXTalk for Oracle and the PostgresV2 for Postgres. Of course, these come with GTInspector extensions.

You can see a basic example for Postgres here:

On Wed, Oct 8, 2014 at 4:28 PM, Alexandre Bergel <[hidden email]> wrote:
I am just asking to understand where effort are put on in the Moose ecosystem.
Visualizing databases may also be a nice chapter for agile visualization.

Alexandre
-- 
_,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:
Alexandre Bergel  http://www.bergel.eu
^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;.



On Oct 8, 2014, at 10:42 AM, Anne Etien <[hidden email]> wrote:

Hi,

Yes we will. We are, Olivier Auverlot and me, currently rewriting a parser and everything that goes with for Postgres. We rewrite it from the beginning having a look on SQLLite, because PetitParser is really hard to debug and we wanted to understand what we are doing. Olivier is also database administrator of the lab and he has some issues that we want to solve with these analyses. We already defined a Famix Model for Database and we are currently generating model with tables taking into account lot of different types and constraints (that’s the beginning). The project goes slowly since we are working maximum 6h per week. 
We will then certainly use Roassal for the visu.

Why are you asking the question?
Cheers,
Anne

Le 8 oct. 2014 à 15:10, Alexandre Bergel <[hidden email]> a écrit :

Hi!

I am wondering if any of you is using Roassal and/or Moose to analyze data bases?

Cheers,
Alexandre
-- 
_,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:
Alexandre Bergel  http://www.bergel.eu
^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;.



_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev

_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev


_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev




--

"Every thing has its own flow"

_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev
Reply | Threaded
Open this post in threaded view
|

Re: Analyzing database

Anne Etien
Very interesting.
We will have a look.

Cheers,
Anne
Le 8 oct. 2014 à 17:00, Tudor Girba <[hidden email]> a écrit :

I have used it to visualize data in the database. I used DBXTalk for Oracle and the PostgresV2 for Postgres. Of course, these come with GTInspector extensions.

You can see a basic example for Postgres here:

On Wed, Oct 8, 2014 at 4:28 PM, Alexandre Bergel <[hidden email]> wrote:
I am just asking to understand where effort are put on in the Moose ecosystem.
Visualizing databases may also be a nice chapter for agile visualization.

Alexandre
-- 
_,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:
Alexandre Bergel  http://www.bergel.eu
^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;.



On Oct 8, 2014, at 10:42 AM, Anne Etien <[hidden email]> wrote:

Hi,

Yes we will. We are, Olivier Auverlot and me, currently rewriting a parser and everything that goes with for Postgres. We rewrite it from the beginning having a look on SQLLite, because PetitParser is really hard to debug and we wanted to understand what we are doing. Olivier is also database administrator of the lab and he has some issues that we want to solve with these analyses. We already defined a Famix Model for Database and we are currently generating model with tables taking into account lot of different types and constraints (that’s the beginning). The project goes slowly since we are working maximum 6h per week. 
We will then certainly use Roassal for the visu.

Why are you asking the question?
Cheers,
Anne

Le 8 oct. 2014 à 15:10, Alexandre Bergel <[hidden email]> a écrit :

Hi!

I am wondering if any of you is using Roassal and/or Moose to analyze data bases?

Cheers,
Alexandre
-- 
_,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:
Alexandre Bergel  http://www.bergel.eu
^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;.



_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev

_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev


_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev




--

"Every thing has its own flow"
_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev


_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev
Reply | Threaded
Open this post in threaded view
|

Re: Transmit data from a custom presentation

Anne Etien
In reply to this post by Thierry Goubier
Hi Thierry,

Our project is called PetitSQLIsland and is available on SmalltalkHub.

We got some problems on:
- the end of the string to parse that is not recognized when writing a string in the playground
- encoding errors
- the priority between the / and the ,
- the infinite loops due to optional
- we wanted to consider as a SQL string everything between quote ' '. But it is not possible to say it. And using #any may be dangerous because the reminder of the file may be considered as the string. The problem is worst when between these two quotes we may have another quote.
- we are using the petitParserBrowser. Sometimes, we ask to generate an example, we copy it on the adequate box, but there is an error. Some other times, the test is working, but not the same example with the browser. Sometimes, we don't understand why it does not recognize the rule when using the debugger.

There should be others, but I don't remember.
I am not sure that I understood well your question. i hope I answered it correctly.

Cheers,
Anne


Hi Anne,

I'd be interested if you can share your parser effort, especially if I can push it to the SmaCC repository.

What do you find hard to debug with PetitParser? How are you doing it then?

Thierry

2014-10-08 15:42 GMT+02:00 Anne Etien <[hidden email]>:
Hi,

Yes we will. We are, Olivier Auverlot and me, currently rewriting a parser and everything that goes with for Postgres. We rewrite it from the beginning having a look on SQLLite, because PetitParser is really hard to debug and we wanted to understand what we are doing. Olivier is also database administrator of the lab and he has some issues that we want to solve with these analyses. We already defined a Famix Model for Database and we are currently generating model with tables taking into account lot of different types and constraints (that’s the beginning). The project goes slowly since we are working maximum 6h per week. 
We will then certainly use Roassal for the visu.

Why are you asking the question?
Cheers,
Anne

Le 8 oct. 2014 à 15:10, Alexandre Bergel <[hidden email]> a écrit :

Hi!

I am wondering if any of you is using Roassal and/or Moose to analyze data bases?

Cheers,
Alexandre
-- 
_,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:
Alexandre Bergel  http://www.bergel.eu
^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;.



_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev


_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev


_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev


_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev
Reply | Threaded
Open this post in threaded view
|

Re: Analyzing database

abergel
In reply to this post by Tudor Girba-2
Thanks!

Alexandre
-- 
_,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:
Alexandre Bergel  http://www.bergel.eu
^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;.



On Oct 8, 2014, at 12:00 PM, Tudor Girba <[hidden email]> wrote:

I have used it to visualize data in the database. I used DBXTalk for Oracle and the PostgresV2 for Postgres. Of course, these come with GTInspector extensions.

You can see a basic example for Postgres here:

On Wed, Oct 8, 2014 at 4:28 PM, Alexandre Bergel <[hidden email]> wrote:
I am just asking to understand where effort are put on in the Moose ecosystem.
Visualizing databases may also be a nice chapter for agile visualization.

Alexandre
-- 
_,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:
Alexandre Bergel  http://www.bergel.eu
^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;.



On Oct 8, 2014, at 10:42 AM, Anne Etien <[hidden email]> wrote:

Hi,

Yes we will. We are, Olivier Auverlot and me, currently rewriting a parser and everything that goes with for Postgres. We rewrite it from the beginning having a look on SQLLite, because PetitParser is really hard to debug and we wanted to understand what we are doing. Olivier is also database administrator of the lab and he has some issues that we want to solve with these analyses. We already defined a Famix Model for Database and we are currently generating model with tables taking into account lot of different types and constraints (that’s the beginning). The project goes slowly since we are working maximum 6h per week. 
We will then certainly use Roassal for the visu.

Why are you asking the question?
Cheers,
Anne

Le 8 oct. 2014 à 15:10, Alexandre Bergel <[hidden email]> a écrit :

Hi!

I am wondering if any of you is using Roassal and/or Moose to analyze data bases?

Cheers,
Alexandre
-- 
_,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:
Alexandre Bergel  http://www.bergel.eu
^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;.



_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev

_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev


_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev




--

"Every thing has its own flow"
_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev


_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev
Reply | Threaded
Open this post in threaded view
|

Re: Analyzing database

abergel
In reply to this post by Tudor Girba-2
Thanks! Exactly what I was looking for

Alexandre
-- 
_,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:
Alexandre Bergel  http://www.bergel.eu
^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;.



On Oct 8, 2014, at 12:00 PM, Tudor Girba <[hidden email]> wrote:

I have used it to visualize data in the database. I used DBXTalk for Oracle and the PostgresV2 for Postgres. Of course, these come with GTInspector extensions.

You can see a basic example for Postgres here:

On Wed, Oct 8, 2014 at 4:28 PM, Alexandre Bergel <[hidden email]> wrote:
I am just asking to understand where effort are put on in the Moose ecosystem.
Visualizing databases may also be a nice chapter for agile visualization.

Alexandre
-- 
_,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:
Alexandre Bergel  http://www.bergel.eu
^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;.



On Oct 8, 2014, at 10:42 AM, Anne Etien <[hidden email]> wrote:

Hi,

Yes we will. We are, Olivier Auverlot and me, currently rewriting a parser and everything that goes with for Postgres. We rewrite it from the beginning having a look on SQLLite, because PetitParser is really hard to debug and we wanted to understand what we are doing. Olivier is also database administrator of the lab and he has some issues that we want to solve with these analyses. We already defined a Famix Model for Database and we are currently generating model with tables taking into account lot of different types and constraints (that’s the beginning). The project goes slowly since we are working maximum 6h per week. 
We will then certainly use Roassal for the visu.

Why are you asking the question?
Cheers,
Anne

Le 8 oct. 2014 à 15:10, Alexandre Bergel <[hidden email]> a écrit :

Hi!

I am wondering if any of you is using Roassal and/or Moose to analyze data bases?

Cheers,
Alexandre
-- 
_,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:
Alexandre Bergel  http://www.bergel.eu
^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;.



_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev

_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev


_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev




--

"Every thing has its own flow"
_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev


_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev
Reply | Threaded
Open this post in threaded view
|

Re: Analyzing database

Nicolas Anquetil
In reply to this post by abergel

I remember Yuriy showing some Roassal visaulizations of his analysis of the dump of SmalltalkHub (mongo DB)

nicolas


On 08/10/2014 15:10, Alexandre Bergel wrote:
Hi!

I am wondering if any of you is using Roassal and/or Moose to analyze data bases?

Cheers,
Alexandre
-- 
_,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:
Alexandre Bergel  http://www.bergel.eu
^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;.





_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev


_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev
Reply | Threaded
Open this post in threaded view
|

Re: Analyzing database

Uko2
Oh, right. I’ve never thought that I was analysing DB :). On the other hand db is just a way to persist data.

Uko

On 10 Oct 2014, at 09:46, Nicolas Anquetil <[hidden email]> wrote:


I remember Yuriy showing some Roassal visaulizations of his analysis of the dump of SmalltalkHub (mongo DB)

nicolas


On 08/10/2014 15:10, Alexandre Bergel wrote:
Hi!

I am wondering if any of you is using Roassal and/or Moose to analyze data bases?

Cheers,
Alexandre
-- 
_,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:
Alexandre Bergel  http://www.bergel.eu
^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;.





_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev

_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev


_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev
Reply | Threaded
Open this post in threaded view
|

Re: Analyzing database

abergel
Ok!!

Alexandre
-- 
_,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:
Alexandre Bergel  http://www.bergel.eu
^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;.



On Oct 10, 2014, at 5:12 AM, Yuriy Tymchuk <[hidden email]> wrote:

Oh, right. I’ve never thought that I was analysing DB :). On the other hand db is just a way to persist data.

Uko

On 10 Oct 2014, at 09:46, Nicolas Anquetil <[hidden email]> wrote:


I remember Yuriy showing some Roassal visaulizations of his analysis of the dump of SmalltalkHub (mongo DB)

nicolas


On 08/10/2014 15:10, Alexandre Bergel wrote:
Hi!

I am wondering if any of you is using Roassal and/or Moose to analyze data bases?

Cheers,
Alexandre
-- 
_,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:
Alexandre Bergel  http://www.bergel.eu
^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;._,.;:~^~:;.





_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev

_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev

_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev


_______________________________________________
Moose-dev mailing list
[hidden email]
https://www.iam.unibe.ch/mailman/listinfo/moose-dev