Scratch Cloud SQL Databases.

sam2016___

Is there a way a unmodded Scratch 1.4 or 2.0 can connect to a SQL webserver and store cloud vars on it? And the project be converted to a .jar with no player header?

Last edited by sam2016___ (Feb. 20, 2016 21:17:19)

I DON'T WANT YOUR * LEMONS, WHAT AM I SUPPOSED TO DO WITH THESE? - Cave Johnson, Somewhere in the 1960s

set [Portal] to [When life gives you lemons, don't make lemonade.
and
set [Dota 2] to [AWESOME]

Hey, do you like personal assistants? Try out mine [url=https://scratch.mit.edu/projects/92877801/]here (His name is Dave)[/url]

bobbybee

RSC or cloud API + bouncer or DNS hijacking + bouncer.

Last edited by bobbybee (Feb. 20, 2016 21:48:29)

“Ooo, can I call you Señorita Bee?” ~Chibi-Matoran

Jonathan50

bobbybee wrote:
RSC or cloud API + bouncer or DNS hijacking + bouncer.

1. what's bouncer? why is it needed?
2. why DNS hijacking?

Not yet a Knight of the Mu Calculus.

herohamp

Is there like a modded scratch 2.0 that somebody has made because it would be amazing to link it to a SQL database

My website hamptonmoore.com
UMass Amherst All Campus Makerspace
Supporting the wife's SEO
Click for a Scratch based programming language I made

bobbybee

Jonathan50 wrote:
bobbybee wrote:
RSC or cloud API + bouncer or DNS hijacking + bouncer.
1. what's bouncer? why is it needed?
2. why DNS hijacking?

1. To redirect cloud API requests to the SQL DB

2. To interrupt connections to cloud.scratch.mit.edu, so requests for the SQL DB never touch MIT servers.

Either way, @OP, why?

“Ooo, can I call you Señorita Bee?” ~Chibi-Matoran

herohamp

Orr just have someone setup a scratch mod that can load SB2 files from network and that file can have the game file in it and have the info for the SQL DB

My website hamptonmoore.com
UMass Amherst All Campus Makerspace
Supporting the wife's SEO
Click for a Scratch based programming language I made

Jonathan50

bobbybee wrote:
Jonathan50 wrote:
bobbybee wrote:
RSC or cloud API + bouncer or DNS hijacking + bouncer.
1. what's bouncer? why is it needed?
2. why DNS hijacking?

1. To redirect cloud API requests to the SQL DB
2. To interrupt connections to cloud.scratch.mit.edu, so requests for the SQL DB never touch MIT servers.

Either way, @OP, why?

can't you just have a program that checks cloud variables and sends queries to the SQL server and puts the response in a cloud variable?

Not yet a Knight of the Mu Calculus.

BookOwl

Jonathan50 wrote:
bobbybee wrote:
Jonathan50 wrote:
bobbybee wrote:
RSC or cloud API + bouncer or DNS hijacking + bouncer.
1. what's bouncer? why is it needed?
2. why DNS hijacking?

1. To redirect cloud API requests to the SQL DB
2. To interrupt connections to cloud.scratch.mit.edu, so requests for the SQL DB never touch MIT servers.

Either way, @OP, why?
can't you just have a program that checks cloud variables and sends queries to the SQL server and puts the response in a cloud variable?

I think she's talking about using cloud variables themselves to access the SQL database, so that loading the variable “foo” would get the thing in the database called “foo”.

Last edited by BookOwl (Feb. 21, 2016 22:20:21)

who needs signatures

Jonathan50

BookOwl wrote:
Jonathan50 wrote:
bobbybee wrote:
Jonathan50 wrote:
bobbybee wrote:
RSC or cloud API + bouncer or DNS hijacking + bouncer.
1. what's bouncer? why is it needed?
2. why DNS hijacking?

1. To redirect cloud API requests to the SQL DB
2. To interrupt connections to cloud.scratch.mit.edu, so requests for the SQL DB never touch MIT servers.

Either way, @OP, why?
can't you just have a program that checks cloud variables and sends queries to the SQL server and puts the response in a cloud variable?
I think she's talking about using cloud variables themselves to access the SQL database, so that loading the variable “foo” would get the thing in the database called “foo”.

but you can do that too!! what

Not yet a Knight of the Mu Calculus.

bobbybee

Jonathan50 wrote:
bobbybee wrote:
Jonathan50 wrote:
bobbybee wrote:
RSC or cloud API + bouncer or DNS hijacking + bouncer.
1. what's bouncer? why is it needed?
2. why DNS hijacking?

1. To redirect cloud API requests to the SQL DB
2. To interrupt connections to cloud.scratch.mit.edu, so requests for the SQL DB never touch MIT servers.

Either way, @OP, why?
can't you just have a program that checks cloud variables and sends queries to the SQL server and puts the response in a cloud variable?

That would be the case of cloud API + bouncer, yes :-)

“Ooo, can I call you Señorita Bee?” ~Chibi-Matoran

Dylan5797

bobbybee wrote:
Jonathan50 wrote:
bobbybee wrote:
RSC or cloud API + bouncer or DNS hijacking + bouncer.
1. what's bouncer? why is it needed?
2. why DNS hijacking?

1. To redirect cloud API requests to the SQL DB
2. To interrupt connections to cloud.scratch.mit.edu, so requests for the SQL DB never touch MIT servers.

Either way, @OP, why?

Use hosts.ics on windows.

sam2016___

bump

I DON'T WANT YOUR * LEMONS, WHAT AM I SUPPOSED TO DO WITH THESE? - Cave Johnson, Somewhere in the 1960s

set [Portal] to [When life gives you lemons, don't make lemonade.
and
set [Dota 2] to [AWESOME]

Hey, do you like personal assistants? Try out mine [url=https://scratch.mit.edu/projects/92877801/]here (His name is Dave)[/url]

Jonathan50

Dylan5797 wrote:
bobbybee wrote:
Jonathan50 wrote:
bobbybee wrote:
RSC or cloud API + bouncer or DNS hijacking + bouncer.
1. what's bouncer? why is it needed?
2. why DNS hijacking?

1. To redirect cloud API requests to the SQL DB
2. To interrupt connections to cloud.scratch.mit.edu, so requests for the SQL DB never touch MIT servers.

Either way, @OP, why?
Use hosts.ics on windows.

Then all project users need to modify their hosts file.

It's /etc/hosts on GNU/Linux, OS X, FreeBSD, NetBSD, OpenBSD, Solaris, AIX, HP-UX, etc.
Did you know that MS actually based Window's TCP/IP stack on 4.4BSD-lite's? That's why the hosts[.ics] file is in an etc folder.
On *nix then /etc is a folder for global configuration files.

I think using a node script with scratch-api (or Python + your ScratchAPI) would be easier.

Not yet a Knight of the Mu Calculus.

Dylan5797

Jonathan50 wrote:
Dylan5797 wrote:
bobbybee wrote:
Jonathan50 wrote:
bobbybee wrote:
RSC or cloud API + bouncer or DNS hijacking + bouncer.
1. what's bouncer? why is it needed?
2. why DNS hijacking?

1. To redirect cloud API requests to the SQL DB
2. To interrupt connections to cloud.scratch.mit.edu, so requests for the SQL DB never touch MIT servers.

Either way, @OP, why?
Use hosts.ics on windows.
Then all project users need to modify their hosts file.

It's /etc/hosts on GNU/Linux, OS X, FreeBSD, NetBSD, OpenBSD, Solaris, AIX, HP-UX, etc.
Did you know that MS actually based Window's TCP/IP stack on 4.4BSD-lite's? That's why the hosts[.ics] file is in an etc folder.
On *nix then /etc is a folder for global configuration files.

I think using a node script with scratch-api (or Python + your ScratchAPI) would be easier.

But that doesn't explain why it's in the drivers folder in

C:/Windows/System32

[sorry, without the code tag the smiley parser would change the :/ to a smiley :P]

Last edited by Dylan5797 (Feb. 24, 2016 14:03:54)

sam2016___

How about we just focus on getting a block,a lot simpler.

I DON'T WANT YOUR * LEMONS, WHAT AM I SUPPOSED TO DO WITH THESE? - Cave Johnson, Somewhere in the 1960s

set [Portal] to [When life gives you lemons, don't make lemonade.
and
set [Dota 2] to [AWESOME]

Hey, do you like personal assistants? Try out mine [url=https://scratch.mit.edu/projects/92877801/]here (His name is Dave)[/url]

liam48D

sam2016___ wrote:
How about we just focus on getting a block,a lot simpler.

Because - how do you actually expect to use the networking free Scratch blocks to access an SQL server?

202e-202e-202e-202e-202e UNI-CODE~~~~~

herohamp

Ya block or project setting FTW

My website hamptonmoore.com
UMass Amherst All Campus Makerspace
Supporting the wife's SEO
Click for a Scratch based programming language I made

Discuss Scratch