NEW videos about how to install Valentina Studio, Server, ADK

Databases
1

Hi Guys,

as I have promised, here are two new videos on yuotube.

Let’s consider them as draft yet. I think we will add yet voice commenting what is going on.

Any comments are welcome.

2

Thanks Ruslan. I’ll take a look at them.

3

These videos made with idea to show the shortest in time path from clean computer to something working.

I did choose between copy paste of big parts of code in the ADK video, and typing of code.
I have decide to type, to show also my personal favorite style of coding. May be somebody will find it useful also.
Style is in short:

  • you type comments
  • you type something starting
  • then immediately you type something ending

Examples:
Init - ShutDown,
Open - Close,
Init Var - Its usage (in example was MsgBox it)

4

Joseph, btw, examples are fixed (that deprecated Profile() method) in
http://www.valentina-db.com/download/beta/5.5b25

5

Thanks Ruslan for doing the videos. I’ve been able to get the server installed and connect with Xojo. That’s about as far as I got because of “just not enough time” issues. I’ll check out the videos to see what else I might learn.

6

Well done Ruslan. These video are very nice. Installing and using local and server DB seem to be very easy to Valentina beginners now.
If I must think about some improvement, I should say perhaps : end the videos showing where to find the documentation to go further.

7

[quote=38216:@FranoisVanLerberghe]Well done Ruslan. These video are very nice. Installing and using local and server DB seem to be very easy to Valentina beginners now.
If I must think about some improvement, I should say perhaps : end the videos showing where to find the documentation to go further.[/quote]

Thank you.

copied from other thread:

I have idea about more videos yet for Xojo developers:

  • Where to find docs/info about Valentina
  • Creation of a report on vserver and usage in WebApp
  • Local only app.
  • usage of RBDB API with local app and with vserver.
  • Tips about Vserver start/stop/restart, Review of vserver folder.
  • Register/Unregister dbs/projects under VServer
  • Compare Valentina API vs RBDB, Where you start to get advantages…
8

There is a voice missing in the videos. Yeah, I know it’s the nasty part of doing videos.

9

i got stuck on 2.58 minute. After enter the password, instead of showing stop on the button with running… mine is just start button with red stopped.

10

this is what i got…

Fri Oct 4 2013 10:33:34.087099 (TID 140735227478400): Database engine inited
Fri Oct 4 2013 10:33:34.089250 (TID 140735227478400): ERROR: Address already in use
Fri Oct 4 2013 10:33:34.089275 (TID 140735227478400): Shutting down server…
Fri Oct 4 2013 10:33:34.094993 (TID 140735227478400): Database kernel terminated
Fri Oct 4 2013 10:33:34.095032 (TID 140735227478400): Server terminated

11

Richard, this means that on your computer was not clean as in video,
On your computer already works some Valentina Server, so port is in use.

Open prefs panel “Valentina Servers” and click button STOP.
Then you should be able install/run new vserver

  • point: if you have fresh vserver, then may be you do not need install it again.

  • if you go in movie little forward to see how to open folder /Library/VServer_x64
    you can open it and see there your installed VServer.
    You can try open its LOG file to see on top version of your vserver.

12

thanks got it started now. how do i import a sqlite database to valentina?

13

[quote=38248:@Richard Duke]thanks got it started now. how do i import a sqlite database to valentina?
[/quote]

Richard, I very ask to keep thread clean :slight_smile:
This thread should be about videos.

How do you import SQLite into mySQL ?
Main advice I can give is: Valentina tend to follow SQL standards and regular techniques.
I very wonder when somebody says Valentina is not so easy as other dbs.
95% of what you can do in SQLite or mySQL you can do in same way with Valentina DB.
And usually, Valentina allows to do a task easier.

Usually, to move one db into another, DB ADMINS use
a) export/import into textile
b) into XML file
c) into SQL dump file

And still I have not answer your question. I believe next your question will be

  • how move Schema?
  • how create db schema from code

Then I need to know:

  • this is really so important db to be converted? with data?
  • if you just develop Xojo app, than may be you can just create new Valentina DB with corresponded tables?
    How? Simple. Use the same SQL commands
    CREATE TABLE T1( … )
    CREATE TABLE T2( … )
    …
    INSERT …
14

Hi Guys!

One more new video
How to Generate Valentina Reports from a Xojo Web Application

This video is made following to textual tutorial from Valentina WIKI