Scratch

I only know what other people have told me - I'm not so knowledgeable in servers and databases at the moment, but I'm sure that the php thing is not the direct way to access the database.  After all, the php page doesn't call a php page to access the database!  I'm not trying to bypass using a url - I want to skip the extra php part and go straight to the database.  Get it?

A python or C# server thing exists, I'm sure, that accesses a database directly - why can't squeak do the same?

Last edited by LiquidMetal (2012-04-15 11:52:43)

LiquidMetal wrote:

I only know what other people have told me - I'm not so knowledgeable in servers and databases at the moment, but I'm sure that the php thing is not the direct way to access the database.  After all, the php page doesn't call a php page to access the database!  I'm not trying to bypass using a url - I want to skip the extra php part and go straight to the database.  Get it?

A python or C# server thing exists, I'm sure, that accesses a database directly - why can't squeak do the same?

You want to execute a SQL query directly from Squeak. Try Googling for it, or using the Squeak forums.

Greenatic wrote:

Sparks, one more thing about the uploader:  is it going to be possible to give it a Internet URL and copy/upload the image directly, or are we going to have to download the pictures onto our computers, then upload?   

You can input a URL into the name chooser input, and it will download it into a temporary files folder somewhere in APPDATA.

Hi everyone!

So.

Yes, I'm working on an uploader that will just take URLs, the one currently up is a slightly modified one I was using on another site but we really do need an URL based one.

A list of uploaded images can quite simply be seen by going to http://blocks.scratchr.org/images/blocks/ because there's no index file 

@liquidMetal, I've seen people get Panther or Scratch to access web data using POST rather than GET, but its still connecting to a web page. This is how all programs have to do it as far as I know, and it isn't TOO slow 

@Sparks:  Is it up?  I go to blocks.scratchr.org and it still tells me:

Welcome to your local block library. This site is currently under construction but you can still use the library from our forum thread. Thanks, Sparks

sparks wrote:

I posted a link, wotdr? Sorry    http://blocks.scratchr.org/uploadBlockImage.php

I'll add a link to the home page too...

What does it mean by "block name"?  The blockspec?

LiquidMetal wrote:

I only know what other people have told me - I'm not so knowledgeable in servers and databases at the moment, but I'm sure that the php thing is not the direct way to access the database.  After all, the php page doesn't call a php page to access the database!  I'm not trying to bypass using a url - I want to skip the extra php part and go straight to the database.  Get it?

A python or C# server thing exists, I'm sure, that accesses a database directly - why can't squeak do the same?

well I'm not sure but i think PHP and ASP are the only programming languages that can directly access a database.

Hmm I was thinking about this. Will putting them in category folders be a good idea? For example, we can categorise them by type, but what if we wanted to list booleans only?

I shall work on the uploader a bit more now with your suggestions. I will have to do a lot of research though, it's all new to me, FTPing 

What folders? Are we dividing them by mod as well as category?

bg tile.png is the background image for the upload page. I was trying it out for looks.

tinypic is a whitelisted host? Do you reckon we should still move them so they're all in one place?

So... shall we move tinypics anyway? I do think putting them all with sensible names on the blocks host is a good idea...

turns out there's a neat PHP function for reading images from other sites, an uploader to do that shouldn't be a problem!

Greenatic wrote:

sparks wrote:

So... shall we move tinypics anyway? I do think putting them all with sensible names on the blocks host is a good idea...

turns out there's a neat PHP function for reading images from other sites, an uploader to do that shouldn't be a problem!

Sweet!  Let's transfer them too, but before we start mass-tranferring, we need to decide what (if any) directory system we are going to use.

How about:
- /
- - motion/
- - control/
- - looks/
- - sensing/
- - sound/
- - operators/
- - pen/
- - variables/
- - other/

rookwood101 wrote:

Greenatic wrote:

sparks wrote:

So... shall we move tinypics anyway? I do think putting them all with sensible names on the blocks host is a good idea...

turns out there's a neat PHP function for reading images from other sites, an uploader to do that shouldn't be a problem!

Sweet!  Let's transfer them too, but before we start mass-tranferring, we need to decide what (if any) directory system we are going to use.

How about:
- /
- - motion/
- - control/
- - looks/
- - sensing/
- - sound/
- - operators/
- - pen/
- - variables/
- - other/

I was thinking:

blocks/Mod/category

sparks wrote:

Okay. I'm armed with a fresh cup of coffee and ready to go!

One thing that's been niggling at me through this is that we should be using an API to generate block images... I think nXIII's one could handle it and I really think this might br a plan to do now to replace the existing images since we want to render them in the end...

Do you have a link to nXIII's?  I don't know where to find it...

Last edited by Greenatic (2012-04-15 16:45:24)

sparks wrote:

sparks wrote:

Okay. I'm armed with a fresh cup of coffee and ready to go!

One thing that's been niggling at me through this is that we should be using an API to generate block images... I think nXIII's one could handle it and I really think this might br a plan to do now to replace the existing images since we want to render them in the end...

Was I making it up that nXIII did one? I can't find it... The main Scratch one won't do, cos it doesn't accept blocks that aren't in the main Scratch... I suppose it could be modified...

Or TheSuccessor's...   

joletole wrote:

I have a suggestion for your website.

How about, when you go onto the website, there will be an introduction, the exact same one as the one on here. Then, at the top, you have 5 options, scratch blocks, panther, byob, the statistics, and the glossary.

Then, when you click on either scratch blocks, byob, or panther, it will bring you to a page that has the corosponding page.

We had that, but databases weren't working. Thanks for the suggestion though, joletole 

@greenatic, yes, I was just thinking about that one, but it is very unfinished...