Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - Richard Freggi

Pages: [1] 2 3 ... 26
General Board / Re: SQLite Can't add 1+1?
« on: May 05, 2022, 02:50:18 pm »
It's treating "1" as TEXT datatype, so it's concatenating 2 strings

General Board / Re: SQLite Can't add 1+1?
« on: May 05, 2022, 12:57:47 am »
Your query runs on my native SQLite (I don't have EA V16)

By ANSI SQL I meant

SELECT 1+1 AS "Two", typeof(1) AS "Type1", typeof(1+1) AS "Type2"

|Two|Type1  |Type2  |
|2   |integer |integer |

SQLite defaults to TEXT datatype whenever possible, so it may be the EA 16 SQLite driver that's playing games on you

General Board / Re: SQLite Can't add 1+1?
« on: May 04, 2022, 08:48:45 pm »
Read up on, your syntax is off (SQLite is ANSI SQL, your query is not)

General Board / Re: Is EA 16 noticeably faster than previous versions?
« on: April 28, 2022, 12:24:25 am »
Thanks all.  So I should not expecting performance improvements, that's OK.  I need to keep my work machine as lean as possible so *.feap is good enough, no motivation to go to Oracle or other.  I do have a thing for open source solutions though after being burned by proprietary license changes a couple of times, so Firefox and SQLite and all related ecosystem solutions are definitely my favorites.

General Board / Is EA 16 noticeably faster than previous versions?
« on: April 27, 2022, 03:28:43 pm »
I'm using v 1310 and my *.feap (Firebird) model is about 1GB.  The PC is Win10 Intel i7 16GB RAM,  500M SSD.
It takes me about 15 hours to import total 500K elements (classes, attributes) into my model using Geert's importer.
It takes about 20 seconds to delete a single element from the project explorer.
It's possible that EA is slowed down by some antivirus thingy from my work PC, but I don't think so.

One hope of V16 is that using the lighter footprint SQLite (and maybe Sparx can find a way of letting us use SQLite 'memory' mode, with database loaded fully in RAM?) , I can reduce these times significantly.  Can anyone comment on performance improvement with *.QEA files compared to *.eap or *.feap?

Thanks to all for their contributions.
I'm still amazed...but I guess I'll have to do it in script.
The tools my customer has been looking at to do Architecture-management have loads of built-in importers for all kinds of data - not as addins, but part of the core proposition. I'm just EA's shortcomings, and my lack of product knowledge.

As far as I remember Office MDG is included in the ultimate version, so you could argue that EA does provide it out-of-the-box.  And EA's cost is just a fraction of the leading tools, so does not seem too bad from my perspective

I've looked extensively into it a couple of years back and I have not found any out-of-the-box way to import connectors (nor attributes!) into EA.  You must use Geert's importer (it can be modified to import connectors) or a plugin (I use Sparx Office integration MDG although I'm not a fan).

The reason is that in EA implementation, connectors and object properties like attributes are NOT objects themselves, so they are treated as an after-thought.  This may well be the UML spec, don't know, but surely makes our life more difficult.

p.s. if you are reverse engineering a database, you can import attributes and relationships automatically.  But you must connect to the database instance (no DML import)

On EA 1310 I cannot reverse engineer PostgeSQL, I remember seeing posts that explained that there was a bug in EA.
Is anyone evaluating v 16 able to confirm if PostgreSQL reverse engineering works on this version?  Thanks!!!

No time to read in detail, but is this not a job for STRING_AGG?  Your could STRING_AGG(this, ' | ') || STRING_AGG(that, ', ')

General Board / Re: Importing Attributes using Microsoft Excel
« on: March 11, 2022, 03:59:50 pm »
Use Belleken's importer - it's free and 100 times better

Automation Interface, Add-Ins and Tools / Re: EA 16 DB Browser
« on: March 04, 2022, 01:11:35 pm »
SQLite Studio is free and very nice.  DBeaver is open source and has every feature you can think of!

Automation Interface, Add-Ins and Tools / Re: SQL Query Using Firebird
« on: March 04, 2022, 01:10:16 pm »
I use square brackets to escape Firebird reserved words, works for me

Bugs and Issues / Re: How do I Export Class Attributes in a .csv file?
« on: February 03, 2022, 11:13:48 pm »
I just use CTRL-A to select everything directly in the search results window, then paste special into Excel with comma as separator and double quote as text marker.  Seems to work OK even for 3-400K rows * 15 columns of results

Automation Interface, Add-Ins and Tools / Re: Office MDG Beta
« on: January 25, 2022, 02:15:24 pm »
The biggest 3 issues I have with the Beta MDG are:
  • The way it handles relationships. I do not understand why relationships cannot be exported to a different tab, like everything else. Thus allowing changing some of the properties of the relation.
  • They have 2 profile manager, one for import profiles and another for export profiles.
  • Only import profiles can be edited through the profile manager. The export profile manager does not allow editing export profiles.

My understanding is that the way it handles relationships is due to the fact that the MDG does not treat the relationship as a thing in itself, it really thinks about the objects (classes) and treats it as a property of the classes, therefore what the MDG can do about relationships is very limited.  This may be due to EA internal architecture, I don't know. (In software engineering object associations are not really important except generalization, while in data modeling they are hugely important - but EA is not natively a data modeling tool...)

Pages: [1] 2 3 ... 26