B4J Question jRDC2 - "Include"

LucaMs · Mar 13, 2024

I must confess that I haven't looked on the site, as currently I'm just curious, I don't have a VPS or similar.

In the tutorial about jRDC2 it is said that it is an excellent alternative to PHP and I agree; but is it mandatory to write all queries in the config.properties file? A feature similar to PHP's Include would be very useful. Being a middle-server developed by Erel and being he brilliant (genius!), he could also invent something equally effective, such as being able to embed libraries instead of text (I don't know, right now I need at least two more coffees to wake up ?).

Magma · Mar 13, 2024

LucaMs said:
I must confess that I haven't looked on the site, as currently I'm just curious, I don't have a VPS or similar.

In the tutorial about jRDC2 it is said that it is an excellent alternative to PHP and I agree; but is it mandatory to write all queries in the config.properties file? A feature similar to PHP's Include would be very useful. Being a middle-server developed by Erel and being he brilliant (genius!), he could also invent something equally effective, such as being able to embed libraries instead of text (I don't know, right now I need at least two more coffees to wake up ?).

Well... I really can't understand... what exactly do you mean ?

I think that writting all queries needed in config.properties for security reasons... and for pemissions to clients...
It is easy to pass a string a string request (even with httpjob and then response json or text)... but with this way you can have more security and set limits at clients...

otherwise: what stops a client connected successfully to delete the whole database...

if you ask me what I preferer... I prefer to have custom - request -string every time...

---

LucaMs · Mar 13, 2024

Magma said:
Well... I really can't understand... what exactly do you mean ?

https://www.php.net/manual/en/function.include.php

Magma · Mar 13, 2024

LucaMs said:
https://www.php.net/manual/en/function.include.php

This i ve got it...
but...

Return File.ReadMap(File.DirAssets, "config.properties")

or you mean having source code into include...
Yeah, that will be great... but from the other hand... that would probably need at stand-alone carry a compiler too ......and from the other hand.. PHP is a scripting language

LucaMs · Mar 13, 2024

Magma said:
that would probably need at stand-alone carry a compiler too ......and from the other hand.. PHP is a scripting language

jRDC runs/executes a script, the one written in the config.properties file.
Erel could make the server include other text files in that file, containing sql queries; I think it's not difficult but I don't know if it's already possible, I haven't looked.

Magma · Mar 13, 2024

I see..

You mean at config.properties (text file)

having for example:
INCLUDE01=c:\test1\config2.inc
...
INCLUDE02=c:\test1\config3.inc
....
and in config2.inc, config3.inc:

having some extra sql queries

right ?

If that you want... after readmap... you can check map keys for containing INCLUDE and run some extra readmap - then append those keys/values in one map

LucaMs · Mar 13, 2024

Magma said:
right ?

Yes.

Magma said:
If that you want... after readmap... you can check map keys for containing INCLUDE and run some extra readmap - then append those keys/values in one map

The purpose of external files is to be able to have reusable queries and data. Also break down the "problem".

LucaMs · Mar 13, 2024

Erel did not intervene; maybe he hasn't read it or this isn't currently possible but I think he will do it. On the surface (!) it doesn't seem like a complicated thing and it is certainly useful.

aeric · Mar 13, 2024

If you want to use a separate file to store the SQL queries, the answer is YES.

This is how I made Web API Server (version 1).

I use queries-mysql.ini to stores the queries.

Just put it inside Objects folder.

You can stop the server, edit this file and run the server again.

The queries are loaded when the server restarted.

You don't need to compile the jar again.

LucaMs · Mar 13, 2024

aeric said:
If you want to use a separate file to store the SQL queries, the answer is YES.

This is how I made Web API Server (version 1).

I use queries-mysql.ini to stores the queries.

Just put it inside Objects folder.

You can stop the server, edit this file and run the server again.

The queries are loaded when the server restarted.

You don't need to compile the jar again.

But jRDC2 only reads config.properties (and only executes queries in it).

aeric · Mar 13, 2024

LucaMs said:
But jRDC2 only reads config.properties (and only executes queries in it).

config.properties is just a text file. jRDC2 is just a server app.
You can do whatever you want.

LucaMs · Mar 13, 2024

aeric said:
config.properties is just a text file. jRDC2 is just a server app.
You can do whatever you want.

I have never used it but I assume that it is a jar, which only reads and executes the queries written in the config.properties text file.

OliverA · Mar 13, 2024

LucaMs said:
But jRDC2 only reads config.properties (and only executes queries in it).

There are several mods out on the forum that may point you in the right direction. Config.properties can by dynamic. I thought I also seen one where the SQL statements are themselves in a table of an SQL DB. Now and then I pitch in when I see some sort of demand for a feature.

LucaMs · Mar 13, 2024

OliverA said:
I thought I also seen one where the SQL statements are themselves in a table of an SQL DB

Why jump through hoops since Erel will most likely simply be able to make the server (jRDC2) include the text files, perhaps with a particular extension, .rdc for example, and run it all?!

OliverA · Mar 13, 2024

LucaMs said:
Why jump through hoops since Erel will most likely simply be able to make the server (jRDC2) include the text files, perhaps with a particular extension, .rdc for example, and run it all?!

I might take a swing at this over the weekend (if you have enough patience for that timeframe). Of course, anyone else is welcome to beat me to it if they want. You could also try a Wish and see what happens...

LucaMs · Mar 13, 2024

Without trying too hard and watching TV ?

Magma · Mar 13, 2024

...@LucaMs Multitasking (watching tv & programming the same time... Mama Mia... i thought only woman can do that) ?

Erel · Mar 14, 2024

config.properties is just a text file. jRDC2 is just a server app.
You can do whatever you want.

That's the correct answer. It is trivial to read the queries from wherever you like. It is also simple to change the queries at runtime.

LucaMs · Mar 14, 2024

Erel said:
That's the correct answer. It is trivial to read the queries from wherever you like. It is also simple to change the queries at runtime.

I didn't understand that answer for the simple reason that... I thought that jRDC was a jar, that the source code was not available! (Downloaded right now).

aeric · Mar 14, 2024

LucaMs said:
I didn't understand that answer for the simple reason that... I thought that jRDC was a jar, that the source code was not available! (Downloaded right now).

jRDC2 like many other projects shared in this forum is written in B4X so you can modify it. Simple as that. If you put any files in Files tab then it become asset files inside the jar which is readonly. If you put any files to Objects folder then it will not be readonly.

B4J Question jRDC2 - "Include"

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Attachments

Expert

B4X founder

Expert

Expert

Similar Threads

Privacy & Transparency

Privacy & Transparency