[Mats Olsson]

This content has been hidden from site admin.

[Mats Olsson]

This content has been hidden from site admin.

[Mats Olsson]

“And I would not really consider using Omnis to build a web SITE – there are better tools for that, and Omnis is better in other aspects of creating web apps.“

A web site is close to a web app. So why not do like Rust. Their site is made using Rust. A web site is the soul of the company. The better maintained site, the more trustworthy IMO.

Omnis.net does not even pass the basics of pagespeed.web.dev. So do they use “better tools” today?

• This reply was modified 3 months ago by  Mats Olsson.
• This reply was modified 3 months ago by  Mats Olsson.

[Mats Olsson]

team does not take this serious…

I have always wondered why not Omnis Inc not show how Omnis can be used “in production” for web development and forum development. That should both be an evidence that it work in real life, rather than small examples at almost “hello world” level.

Omnis web site is IMO another example of they do not care. According to pagespeed.web.dev

Showing results for URL: https://www.omnis.net/ Core Web Vitals Assessment: Failed

And it lacks of many other navigation issues IMO. Show me what Omnis can do!

• This reply was modified 3 months ago by  Mats Olsson.

omnis.net

Omnis Studio - flexible + fast cross platform app development

Omnis Studio 10 is a productive app development environment for Windows, macOS, Android and iOS.Develop once, deploy anywhere ➡ on web, mobile and desktops.

[Mats Olsson]

But when my Omnis app is installed locally, and Postgres on the VPS, each operation takes seconds… i.e. very slow!

If I understand your question correct: When you use Postgresql via 127.0.0.1 it is on the same computer (same network) (localhost). It is normally very fast (milliseconds).

When app and data are on different networks (locally connected via internet to the VPS) the latency increases as the data is transferred through the internet. The speed depends on your connection delay, connection speed etc. And using a DNS lookup (uwe.com) it may take some extra time compared to ip:port.

Hence localhost (127.0.0.1) and internal IPs (10.x.x.x or 192.x.x.x) are faster than external IPs (123.4.5.6)

• This reply was modified 6 months, 2 weeks ago by  Mats Olsson.

[Mats Olsson]

I use Omnis iv_XMLObj for the PEPPOL standard.

1. Create a iv_XMLObj

2. Define a list

3. Populate the list

…

Do pv_LIST.$add(‘3004′;’5′;’cbc:Name’)

Do pv_LIST.$add(‘3008′;’6’;pv_OWN_DATA.CO_NAME)

…

4. And then load the list into this XML object

Do iv_XMLObj.$loadlist(lv_LIST;errorText)

• This reply was modified 6 months, 2 weeks ago by  Mats Olsson.

[Mats Olsson]

Happy New Year to you!

Same to you!

it seems more in the way that my Ubuntu 24.04 installation is lacking some dependencies…

Ubuntu is no “server OS” AFAIK. Which means that you get a lot of extra stuff you do not need (read dependencies)

listen_addresses = '*'	

If you only work inside a VPS you do not have to listen to outside call…

And you pg_hba.conf seems to be OK for “internal use”.

libnsl.so.2: cannot open shared object

To me, it seems that the problem is inside Omnis. Check read/write rights for the mentioned files to start with…

• This reply was modified 6 months, 4 weeks ago by  Mats Olsson.

[Mats Olsson]

Any ideas on how to get my connection from OHS to Postgres running?

Is there anything in the Postgresql log that can give a hint?

What is the settings in Postgresql.conf and hba.conf? (Postgresql)

If you the app and pg server is on the same server ( using 127.0.0.1 ), it may be some access problem.

• This reply was modified 6 months, 4 weeks ago by  Mats Olsson.
• This reply was modified 6 months, 4 weeks ago by  Mats Olsson.

[Mats Olsson]

This free 3 day trial is so limited…

Why did not try my referral offer $25?

[Mats Olsson]

“It’s a curious mix, isn’t it? The phrase “community edition” typically signals openness, accessibility, and often free access—a version meant to empower users, developers, or smaller organizations. When you tack on “Pro” and introduce a fee, it feels like a semantic tightrope: you’re elevating the offering while potentially muddying the original spirit of “community.” 🙂

It all comes down to transparency and trust. Alternative names that hit a similar note but sound less contradictory?

• This reply was modified 1 month, 1 week ago by  Mats Olsson.
• This reply was modified 1 month, 1 week ago by  Mats Olsson.

[Mats Olsson]

This content has been hidden from site admin.

[Mats Olsson]

IMO, there are no big differences.

Though many subqueries might be harder to read. And using CTE it is simpler to reuse the value in many places instead of multiple extra sub queries.

At the end of the day, it boils down to a matter of preference.

I prefer CTE, but I also use sub queries for simpler queries.

• This reply was modified 6 months, 1 week ago by  Mats Olsson.

[Mats Olsson]

Another way to only send one single query is to use CTE. Seldom used, but very powerful.

Basically you create a list or result from different tables using WITH and then gather them afterwards

Sometimes UNION (ALL) work best, sometimes you need WITH statement.

WITH 
query1 AS (SELECT count(1) as count1 FROM table1),
query2 AS (SELECT count(1) as count2 FROM table2)
SELECT count1, count2 FROM query1, query2;

• This reply was modified 6 months, 1 week ago by  Mats Olsson.
• This reply was modified 6 months, 1 week ago by  Mats Olsson.

[Mats Olsson]

How (or when) can I access icPrefValue on the server?

I have struggled with communication between “browser” and “app” and found few ways to “send” data to the server. One is to use a cookie. Or use fetch() to send a value to an endpoint on the server. But probably will Andreas have a better solution 🙂

[Mats Olsson]

So there does not seem to be a common framework to be used, as I understand only the XML Object.

All e-invoice formats should be “standard”, but many companies does not accept any standards and add some extra stuff or change it to fit their needs. A framework is harder to alter to fit the non-standard world. XML object is AFAIK 100 percent flexible IMO.

• This reply was modified 6 months, 2 weeks ago by  Mats Olsson.