mvanrijnen

have you tried to login as the same user twice ? with the same applicationid ? Of course in pure REST you would not have to logon, but everyone uses sessions, you can't get a second sessionid for a user with RADServer at the moment. So I (we) have implemented our own sessions and authorisation within appserver, skipping the provided ones. That said, it's a good start of to get started with web/micro services and the rest idea. We are no a month in production with the first application and it runs ok., in januari we launch our 2nd (inhouse) application for this. We run it on a IIS Server, for outside world we put a nginx server in between wich does the client/server certificate authentication and the routing to (possible) different in house servers. (we could do this also on IIS, but felt saver with this solution)

This discussion is every time a new delphi version is released it seems. And there are people with no problems at all, and there are people with mediocre problems, and there are (as am i and my collegue) people who get frustrated with every update/ugrade 🙂 Maybe EMB would do good to investegate why some (i don't know how many) people have still such big problems with Delphi, is it some specific component, but i do not see any efford from EMB to fix some problems for once and for all (LSP anyone) We did upgrade every 6months/year, but we are waiting with upgrading to D11 now, to few bugfixes for us to go over. keep noted, that this is just my opinion and i do not speak for the whole world.

I do know that yes, why the question, are you speaking for everyone ?

nah, it's not too expensive, upgrading just does not solve enough problems for existing customer, nor give it enough bugfree new feautures. The price is right for good tooling, it just does not live up to the price 🙂

It's a webserver with a "framework" around it to make it a little easier to develop and deploy your webservices. It's not too bad, but has some shortcomings, most pain is the fact that there is almost no documentation. What did you thought it was?

RADServer is a lot of promises, once using the product you find out you'd better choose another solution as a base for rest services. (we are still using it, but from week to week, less and less is used from the radserver itself), it's about the same as Delphi lot of commercial shit and shouting, but not really a usable product.

Yes i know, we do that every month here. But somehow the query which ran yesterday in 1.21 (on testdatabase), ran this morning in 0.37, so have to figure out what that is. The test DB is a database which get restored everynight from a backup from the productiondb. So it could be that some process is messing up the index stats or so, have some more testing todo before finding out.

I remember reading somewhere (not sure where 🙂 ) the opposite, some documentatin about this? Have to look this up, your variant with the original "AND (sp.deleted_for_me=FALSE)" is faster then my solution. man man, some work to do now 🙂 [edit] Seems we have some other problems here, the old query now performs faster also. (not as fast as it should)

We use het purely internally, you simply have to setup an internal MQTT server and point your clients to that, (i even have tooling to use the internal DNS as configuration for this, but we don't use this at this point yet).

We use this one (paid but not expensive): TMS MQTT Cross-platform messaging client library implementing the full MQTT specification. (tmssoftware.com) Works very good, we use it for signaling between apps and servicec etc.

reminds me to ask my boss for some speakers 🙂 no sound now 😞

If you specifing absolute paths, they would be loaded from the absolute location, can you try to monitor the service with procmon (sysinternals), and see what files en especially where the service tries to open them ?

nice stuff to execise on creating unittests 🙂

What is your actual question now? Maybe you can explain some more on your actual problem ? It seems you have to fill in your external ip address somewhere, and because this can change you email it to yourself/somebody? Can't you solve things with DDNS ?

It probably is against the licensing to use MSWord like that, it can not be used on a server as for as i know. There are solution in azure to expose central installed apps to remote users desktop.

Where did you run your query ? Did you have any output ? There has to be an error/exception somewhere.

Nice, i have my own helpers class, but with a lib like this it would be nice if you get set defaults, like global or on classlevel. So you would not have to decorate each TDateTime, or TStrings. just a tip!

Original query, does gives an error in DBWorkbench and FireDac (TFDQuery).

I did not try it out myself 🙂 I give it a try tomorrow, but i if there is no T2 table there should be an error/exception somewhere. (i'l try it out in DBWorkbench, and delphi with firedac)

You can change them, i have here at work not the availabitity over Win11 (real or VM).

Did youcheck at Advanced System Settings ? See screen shots, sorry dutch and win10, but same settings exists on Win11,

Little tip, always try constructions as this, with a simple select statement first. eg (not corrected, just as example!): SELECT * FROM TABLE1 T1 WHERE EXISTS (SELECT 1 FROM TABLE1 T1 WHERE T1.ID= T2.ID); so you have an idea what records are gonna be hit.

Why? I use it (@home), and it works just great. TS has to make sure that he has a dedicated main folder to put his dcu's in, which then has to be in the Exceptions list for Kaspersky.

Aks if they can make a few directory/folder exceptions for you, should not be that big a problem.

There are some policies what you can set gpedit.msc Computer Configuration>Administrative Templates>Windows Components>Windows Update But i believe microsoft can always push updates with nondomain member computers. (have to look that up).