open a database

[plouf]

the point is that is sound like apps used from a specific group of people, and probably all inside a specific house/office

so does it really need for the GUI to be web based? a "classic" windows based win32 app should be enought imho

[nad]

Most of my systems are in multiple sites.
The last winery system was all over, with sites in europe, south america, most states.
Had about 4 wineries where they crushed, blended. The bottling plant had 14 lines. One line did about 20K bottles per hour.
The glass plant was the largest in the us and made all the bottles. The aluminum plant made all the metal caps, and process raw cork for bottles.
Also downtime was not allowed. So I used mySQL with replication and 2 backup sites in different locations. When they entered anything, the db recognized a change and replicated it into backup1. backup 1 noticed a change and replicated it into backup 2. If the main db file became corrupt or crashed, it would fail over to backup1, and if that failed it failed over to backup2. When the main db was fixed it was told to sink the db's. Basically no one even knew the db crashed.

So it's all over the place.

It shouldn't make any difference if it is working on the web. I guess pure and spider can handle it?? right??
Thanks for the help..
Dan

[plouf]

Based on info you provide.
My personal opinion is to transfer it completelly in purebasic
(Client side app) no need for a server out of db.

After you transfer it fully. If there are specific need for a web based front end. It should be easy with spider

[nad]

Thanks for the help. I'm going to study pure and spider some more.

Is there a book somewhere I can get. I'm about as smart as a rock when it comed to pure and spider.

I always like basic. people knock it. But I can pick up a basic program and understand it. Other languages not so much, especially OO. Why OO I'll never understand.

Thanks again for all your help..
Dan

[plouf]

There are at least rwo books (google its free) but its too old

Best is to experience with manual and examples
Imho pure/spider has the most structured manual around

[skywalk]

If your clients are across the globe, you will need a server of some sort.
SQLite is not great for networked access.
Postgresql manages concurrency with a bit more startup complexity.

You can't go wrong prototyping with [PureBasic + SQLite] <--> SpiderBasic.
Once you have the business logic worked out, you can determine scale with servers and Postgres or Maria,MySQL.

[nad]

My first SpiderBasic program.
I get errors in SpiderBasic whan I try to open this SQLite database. What am I doing wrong?
The error: "Bas parameter type, number expected instead of string"

The code:

If OpenDatabase(0, "C:\rbp101\projects\foodbank_project\data\foodbank.db")
Debug "Database connected successfully"
Else
MessageRequester("Error", "Failed to open database!")
End
EndIf

Thanks for the help...

[Caronte3D]

If you put the cursor over the "OpenDatabase" word, and press F1 you can see in the help that the second parameter is a pointer, no a string.
If you go to the DataBase Index in the help, you can find two examples.
Also... in case you missed this post:
viewtopic.php?p=9722#p9722

[plouf]

In spiderbaaic you can NOT, open a local sql db
Databases are stored locally by browser
So you ONLY set number identifer not a string

As said in manual

[nad]

Is there an example of opening a SQLite db and acessing it? This is my first try at using SpiderBasic. To accomplish access to the DB, I wrote a program in PHP to access the SQLite DB. In SpiderBasic I send a request request = HTTPRequest(#PB_HTTP_Get, "http://localhost/person_api.php?personNum=" + Str(personNum)). I hope this is the wrong way to do? Is there an example somewhere where it uses spiderBasic instead of this work around?