Results 1 to 6 of 6

Thread: File Location and Lianja SQL

  1. #1
    Member
    Join Date
    May 2013
    Location
    Bergkamen, Germany
    Posts
    37

    Question File Location and Lianja SQL

    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

  2. #2
    Lianja MVP
    Join Date
    Feb 2012
    Location
    Berea, KY, USA
    Posts
    2,068
    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

  3. #3
    Member
    Join Date
    May 2013
    Location
    Bergkamen, Germany
    Posts
    37
    Thanks a lot, Hank!
    Thanks
    Stefan

  4. #4
    Member
    Join Date
    May 2013
    Location
    Bergkamen, Germany
    Posts
    37
    Quote Originally Posted by HankFay View Post
    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?
    Thanks
    Stefan

  5. #5
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    6,221
    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.
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

  6. #6
    Member
    Join Date
    May 2013
    Location
    Bergkamen, Germany
    Posts
    37
    Quote Originally Posted by barrymavin View Post
    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...
    Thanks
    Stefan

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Journey into the Cloud
Join us