File Location and Lianja SQL

[zehnernet]

Hi folks,

I'm a german newbee and evaluate the 5.4 version of Lianja.
As a VFP developer I can say: It makes fun already :-).

I think I will have tons of questions the next days and weeks. Of course I try to find answers here at the forum and in the documentation. May be I can't find all things I search for, so sorry, if I'll ask things, already asked. Please drop a link then, OK?

Now, what I want to know first are two things:

1. Can I affect the folders for all files of an App or a project? I'm used to have all my projects on a defined hard disk and in defined project-folders. BTW I can't affect drive and folder during installation of the App builder. Why not?

2. I imported a VFP DBC. Works fantastic, accept for one table. May be to large? It has over 3.1 Million records... But that is not the question right now. Questions are,are the tables now importet into the native Lianja Database? I think so. ANd how can I get them into the Lianja SQL-Server?

May be I have a 3. question for the future:

When I develop a page (made one already just to fool around), How can I link this to the SQL-Server AND how can I implement something like a Key-Input (Name or something) so that the SQL-Server only delivere these records an not all? But thats realy for the future...

Thanks in advance and sorry for my english!

Stefan

[HankFay]

Hi Stefan,

1. data location: https://www.lianja.com/doc/index.php/SET_DATADIR That said, "remote" tables (even on the test LCS/LSQL built into the Lianja App Builder) by default go to <drive>:\lianja\cloudserver\tenants\public\data\<d atabase name> And yes, Lianja has tenanted databases based on user "domain" set in Lianja Security.

2. Lianja SQL Server: push the tables to the "test" LCS/LSQL using the Deploy operation from the UI. That's all it takes. In an App you can access the tables directly (it's very quick) or can use Virtual Tables (think: VFP remote view), and also sqlexec() or a cursoradapter.

3. Lianja filters are very fast working against tables, Or you can create a Virtual Table as the datasource and use parameter-based selection, just like VFP.

hth,

Hank

[zehnernet]

Thanks a lot, Hank!

[zehnernet]

Hi Stefan,

3. ... Or you can create a Virtual Table as the datasource and use parameter-based selection, just like VFP.
hth,
Hank

Hi Hank and all others!

Is this the right way?:

I want to develop a Desktop App for LAN use. The Data I want to store in the Lianja SQL-Server - or maybe MySQL - depending on data connection. To Lianja SQL Server is native?

So what is the best way to handle my development? Directly with an SQL-Database or first with the native Database and deploying that later?
In VFP I uses the local DBC, but develop with cursor adapters. With this I could only switch the connection later.
Is there a "How To" somewhere to start of from for my needs?

[barrymavin]

Hi Stefan,

Rather than try and do too much at once while you are gaining familiarity with Lianja I'd recommend you build against native tables on the LAN. The SQL engine is fast and has a decent optimizer.

Once you have your app completed to your satisfaction you can switch databases and adjust whatever is needed to optimize performance.

[zehnernet]

Hi Stefan,

Rather than try and do too much at once...

That's the point. I don't want do too much at a time. In fact, at this moment I do nothing else as brwosing around in the IDE and the help.
But before I start, I wanted to know how I start the right way if I want a desktop App in a LAN with SQL-Server.
When I know the right way, I can do a propper research...