It is currently Fri Mar 05, 2021 3:16 pm

All times are UTC + 1 hour




Post new topic Reply to topic  [ 16 posts ]  Go to page 1, 2  Next
Author Message
 Post subject: SpiderBasic
PostPosted: Mon Oct 21, 2019 4:48 pm 
Offline
PureBasic Expert
PureBasic Expert
User avatar

Joined: Sat May 17, 2003 11:31 am
Posts: 6074
Not sure where to put this (if in the wrong place, then mods, feel free to move it!) but I wonder: how many people do use PureBasic AND SpiderBasic?

(I am actually considering dabbling a bit in SpiderBasic, so I'd like find out the experience of other PureBasic / SpiderBasic combo users...)

_________________
( PB5.xx Win10 x64 Asrock AB350 Pro4 Ryzen 1600X 32GB RAM Evo 840 GTX1060 )
( The path to enlightenment and the PureBasic Survival Guide right here... )


Top
 Profile  
Reply with quote  
 Post subject: Re: SpiderBasic
PostPosted: Mon Oct 21, 2019 5:18 pm 
Offline
Enthusiast
Enthusiast

Joined: Mon Apr 10, 2017 6:17 pm
Posts: 417
Location: Germany
I licensed both and started to develop my first spiderbasic app, but still struggle to get it to run on one of my smartphones. google developer console is giving me enough trouble so i started to look for other ways now.

_________________
webpage


Top
 Profile  
Reply with quote  
 Post subject: Re: SpiderBasic
PostPosted: Tue Oct 22, 2019 6:39 am 
Offline
Addict
Addict
User avatar

Joined: Wed Apr 30, 2003 8:15 am
Posts: 1080
Location: Germany
I use it a lot for Server - Client Apps..

_________________
"Daddy, I'll run faster, then it is not so far..."


Top
 Profile  
Reply with quote  
 Post subject: Re: SpiderBasic
PostPosted: Tue Oct 22, 2019 8:41 am 
Offline
Enthusiast
Enthusiast

Joined: Tue Jul 26, 2005 12:02 pm
Posts: 225
Location: Lieusaint (77), France
100% Purebasic, 0% Spiderbasic.

Until now, Purebasic has belonged to my professional needs.
I will now probably have to develop client-server schemes, so will study SpiderBasic side... I don't feel comfortable at all with Spider, but let's try however...

_________________
Purebasic 5.72 64 bits - Windows 10 Pro 64 bits 2004


Top
 Profile  
Reply with quote  
 Post subject: Re: SpiderBasic
PostPosted: Tue Oct 22, 2019 8:58 am 
Offline
Addict
Addict

Joined: Thu Apr 18, 2019 8:17 am
Posts: 1327
Is SpiderBasic secure? I thought anyone could view the source of your SpiderBasic apps in their browser? Yes or no?


Top
 Profile  
Reply with quote  
 Post subject: Re: SpiderBasic
PostPosted: Tue Oct 22, 2019 9:07 am 
Offline
Addict
Addict
User avatar

Joined: Tue Mar 02, 2004 1:20 pm
Posts: 1173
Location: Amphibios 9
BarryG wrote:
Is SpiderBasic secure? [...] Yes or no?

No.

The secure things should be executed on the server side.

_________________
Hygge


Top
 Profile  
Reply with quote  
 Post subject: Re: SpiderBasic
PostPosted: Tue Oct 22, 2019 1:40 pm 
Offline
PureBasic Expert
PureBasic Expert
User avatar

Joined: Sat May 17, 2003 11:31 am
Posts: 6074
Is there a kind of 'dummy' set of instructions?

I have NO clue whatsoever when it comes to web development, however I have an idea I'd like to try, which requires a server somewhere :-) and something to run on the mobile device. (Sorry I cannot give details, that's commercial. If you want to compare it with anything, assume it's a Dungeons and Dragons spellbook that is managed online, but can be viewed offline, it's as close as it gets...)

Options

I have two options / see two stages:

a. either web only (all intelligence on the server side) which limits the deployment to online only, but that might be acceptable, or...

b. (partially) operational even when offline, which requires some code on the user's device, but this is for later worrying

I'd probably start with a, but want to move to b in the long run.

I've been browsing the SpiderBasic website a bit, but some things aren't very clear to me. (I might have just missed the 'survival guide' equivalent :oops: :wink: )

Questions

1. Is there a 'SpiderBasic for Dummies'?

2. What do I need to run things 'at home'? I assume I need to set up some webserver in a VM or similar to simulate real world behavior (though I could simply opt to run a second 'instance' on the actual server) and SpiderBasic. Anything else I need?

3. I suppose the hosting party must offer me some things... For example, I need to store that database somewhere on the server side, so the hosting party must support a database, I suppose? (The hoster I am considering is supporting MariaDB, kind of MySQL.)

4. Now here's the kicker. Everything above is on the SpiderBasic / web side. But I plan to run some 'raw' PureBasic code, at first on a test machine from home, but I'll probably switch to a dedicated server if things work and are commercially viable. So can I access that (remote) MariaDB with PureBasic?

Here's an example of the setup:

mypc + PureBasic <-- internet --> MariaDB on hoster <-- internet --> browser on mobile

Then, one day, I'd like to also support this:

mypc + PureBasic <-- internet --> MariaDB on hoster <-- internet --> limited data + app on on mobile

Why and why now?

Well, I just lost my regular job, and will do some consultancy over the next year. Getting a regular job as a 50+ guy is hard, so why not start to pursue some old ideas I never finished developing...

Part of the issue is that data in that database is processed 'in batches' which will allow quite a bit of off-line processing, compute, and me :-( tweaking the algorithms until it all works properly and is ready for prime time.

I know there must be better ways to make some money, but at least this way there's a bit of fun still in there 8) I think I'll be able to make a second income with the concept, but it isn't big enough to start hiring people, set up a big company etcetera.

So, assume I'm out of my mind, and assume I'm not (yet) about to hire a web expert... how would I start?

SpiderBasic

... though I am a bit worried about the viability of SpiderBasic, it's what I am most familar with...

Does anyone use that forum? I tried to register, but never receive the registration confirmation, so cannot even ask questions over there...

_________________
( PB5.xx Win10 x64 Asrock AB350 Pro4 Ryzen 1600X 32GB RAM Evo 840 GTX1060 )
( The path to enlightenment and the PureBasic Survival Guide right here... )


Top
 Profile  
Reply with quote  
 Post subject: Re: SpiderBasic
PostPosted: Wed Oct 23, 2019 12:53 pm 
Offline
Enthusiast
Enthusiast

Joined: Wed Mar 11, 2009 4:06 pm
Posts: 341
Location: NL
In case the concept isn't fully clear: SpiderBasic is purely a 'compiler' to client-side HTML/JavaScript/CSS. It doesn't handle the server side. To store something in a server side DB you still need to POST to a server script like PHP. The build-in database functionality provides access to browsers local SQLITE support. SpiderBasic seems to be all about showing a desktop-like GUI dialogs on a web page, although a powerful grid control (buildin sorting, reordering, interactive find) is missing (just like native with PureBasic sadly).

ps. I just created an account successfully. The confirmation e-mail ended up in spam (sent from an @gmail.com address), so check that too. I used a Hotmail address.

You could use PB as CGI application instead of PHP. See https://forums.spiderbasic.com/viewtopic.php?f=9&t=1703 for a combo PB/SB example.


Top
 Profile  
Reply with quote  
 Post subject: Re: SpiderBasic
PostPosted: Wed Oct 23, 2019 1:44 pm 
Offline
PureBasic Expert
PureBasic Expert
User avatar

Joined: Sat May 17, 2003 11:31 am
Posts: 6074
Thanks Rinzwind, that clarifies a bit.

Leaves me two things to check out:

1. An example / step by step instructions of how to store / retrieve data from a remote database? Suitable for idiots like me :-)

2. An example / step by step instructions of how to turn a SpiderBasic program into an 'app'? Again for idiots like me :lol:

_________________
( PB5.xx Win10 x64 Asrock AB350 Pro4 Ryzen 1600X 32GB RAM Evo 840 GTX1060 )
( The path to enlightenment and the PureBasic Survival Guide right here... )


Top
 Profile  
Reply with quote  
 Post subject: Re: SpiderBasic
PostPosted: Wed Oct 23, 2019 4:21 pm 
Offline
Addict
Addict
User avatar

Joined: Tue Mar 02, 2004 1:20 pm
Posts: 1173
Location: Amphibios 9
blueznl wrote:
1. An example / step by step instructions of how to store / retrieve data from a remote database? Suitable for idiots like me :-)


If you use (SpiderBite), an example code would look like this:

Code:
#SpiderBite_Profile = "SimpleDatabaseTest"

EnablePbCgi
 
  UseSQLiteDatabase() 
 
  Procedure InitDatabase()
   
    Protected DB
   
    Protected DatabaseFilename.s = GetPathPart(ProgramFilename()) + "db.db"
   
    If FileSize(DatabaseFilename) = -1
     
      CreateFile(0, DatabaseFilename)
      CloseFile(0)
     
      DB = OpenDatabase(#PB_Any, DatabaseFilename, "", "", #PB_Database_SQLite)
     
      DatabaseUpdate(DB, "Create Table TestTable (Counter INTEGER)")
     
      DatabaseUpdate(DB, "Insert Into TestTable (Counter) Values (0)")
     
    Else
     
      DB = OpenDatabase(#PB_Any, DatabaseFilename, "", "", #PB_Database_SQLite)
     
    EndIf
   
    ProcedureReturn DB
   
  EndProcedure
 
  ProcedureDLL.s myPbCgiProcedure()
   
    Protected DB
   
    Protected ReturnValue.s = "Ups!"
   
    DB = InitDatabase()
   
    If DB
     
      If DatabaseUpdate(DB, "Update TestTable Set Counter = Counter + 1")
       
        If DatabaseQuery(DB, "Select Counter From TestTable")
         
          NextDatabaseRow(DB)
         
          ReturnValue = "Hello from myPbCgiProcedure (called " + Str(GetDatabaseLong(DB, 0)) + " times)"
         
          FinishDatabaseQuery(DB)
         
          CloseDatabase(DB)
         
        EndIf
       
      EndIf
     
    EndIf
   
    ProcedureReturn ReturnValue
   
  EndProcedure
 
DisablePbCgi

Debug myPbCgiProcedure()

(Yes, I know that SQLite databases are not suitable for web applications, but I was too lazy to write an example for real database server.)

This example runs locally on my computer with the IIS.

It depends on whether your web hoster allows you to execute CGIs. Most hosters, for example, only allow the execution of PHP scripts (which my SpiderBite also supports).

Greetings ... Peter

_________________
Hygge


Top
 Profile  
Reply with quote  
 Post subject: Re: SpiderBasic
PostPosted: Wed Oct 23, 2019 6:17 pm 
Offline
PureBasic Expert
PureBasic Expert
User avatar

Joined: Sat May 17, 2003 11:31 am
Posts: 6074
Thanks. Another one to look at, but it's slowly beginning to make sense...

> Can't decide if i need a hug, an XXL coffee, 6 shots of vodka or 2 weeks of sleep.

All, and probably in that order :-)

_________________
( PB5.xx Win10 x64 Asrock AB350 Pro4 Ryzen 1600X 32GB RAM Evo 840 GTX1060 )
( The path to enlightenment and the PureBasic Survival Guide right here... )


Top
 Profile  
Reply with quote  
 Post subject: Re: SpiderBasic
PostPosted: Wed Oct 23, 2019 7:06 pm 
Offline
Addict
Addict
User avatar

Joined: Wed Dec 23, 2009 10:14 pm
Posts: 3413
Location: Boston, MA
Hi Kiffi,
Do you have any experience using nginx(FCGI only?) or mongoose(Fred uses this for SpiderBasic) servers on Windows PC's?

_________________
The nice thing about standards is there are so many to choose from. ~ Andrew Tanenbaum


Top
 Profile  
Reply with quote  
 Post subject: Re: SpiderBasic
PostPosted: Thu Oct 24, 2019 7:32 am 
Offline
Enthusiast
Enthusiast
User avatar

Joined: Fri Jun 30, 2006 4:30 pm
Posts: 579
Location: Middle East
blueznl wrote:
Not sure where to put this (if in the wrong place, then mods, feel free to move it!) but I wonder: how many people do use PureBasic AND SpiderBasic?

(I am actually considering dabbling a bit in SpiderBasic, so I'd like find out the experience of other PureBasic / SpiderBasic combo users...)



Hi blueznl,

I'm still using both PB and SB. I ported my PB software desktop frontend to SB and it was easier than expected.
Our users have an alternative to access our online system via browser instead of using desktop.
I use combination of (PB or SB) + MYSQL + PHP.

_________________

[Registered PB User since 2006]
[PureBasic 5.7][SpiderBasic 2.2] [Win 10 64bit]
[Intel i7 990x 4.20 Ghz] [18GB DDR3]


Top
 Profile  
Reply with quote  
 Post subject: Re: SpiderBasic
PostPosted: Thu Oct 24, 2019 7:52 am 
Offline
Addict
Addict
User avatar

Joined: Tue Mar 02, 2004 1:20 pm
Posts: 1173
Location: Amphibios 9
Hello skywalk,

skywalk wrote:
Do you have any experience using nginx(FCGI only?) or mongoose(Fred uses this for SpiderBasic) servers on Windows PC's?

Unfortunately I don't have enough experience with these servers. On my local PC as well as on my vServer I use the IIS, which is completely sufficient for me.

Do you have a specific question regarding this?

Greetings ... Peter

_________________
Hygge


Top
 Profile  
Reply with quote  
 Post subject: Re: SpiderBasic
PostPosted: Thu Oct 24, 2019 12:52 pm 
Offline
Addict
Addict
User avatar

Joined: Wed Dec 23, 2009 10:14 pm
Posts: 3413
Location: Boston, MA
I just thought iis would be more complicated to deal with on desktop PC's? I will try it out and see.

_________________
The nice thing about standards is there are so many to choose from. ~ Andrew Tanenbaum


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 16 posts ]  Go to page 1, 2  Next

All times are UTC + 1 hour


Who is online

Users browsing this forum: No registered users and 9 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  

 


Powered by phpBB © 2008 phpBB Group
subSilver+ theme by Canver Software, sponsor Sanal Modifiye