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
Answering my own question.  No problem with PostgreSQL and EA 16, I used the 64 bit driver in my computer (incompatible with EA 32 bit) and it worked fine.

General Board / Re: SQLite is way faster than SQL Server
« on: June 17, 2022, 12:32:16 am »
Hey Geert,
I'd be be curious to know if you have found a way to make the SQLite repository work in-memory ("file::memory:" parameter).
I don't know if EA supports this repository mode, and it would not be ACID until the database is saved to disk.  But potentially it could be a real ripper!

p.s. also PRAGMA journal_mode = off and PRAGMA synchronous = off may speed even further if EA can tolerate them.

You should be able to access the EA QEA file with an SQLite frontend (DBeaver, SQLite studio... even the CLI) and run common table expressions which should support recursive queries

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

Pages: [1] 2 3 ... 26