Gecoh - A Windows Mobile repository/package installer

[N1c0_ds]

GECKO

Current status:
Working on Core 3.2


Gecko, the Windows Mobile "Appstore"

Fast, small, free and open source. Click the link for more information (and to generate some ad revenue).

[N1c0_ds]

I figured out the best place to get help and support would be from Basic4PPC users. You indubitably know Basic4PPC better than me

So that's what I'm working on. I found a huge support from XDA Developers and people are eager to see this project gain momentum.

However I heard SQL would be the best thing for the database but I don't know anything about this. Could anyone tell me about this and how it works? I'm looking at the samples, the Wiki, the SQL website but I don't get much of it...

Meanwhile I'll be working on a kickass UI ^_^

[Cableguy]

I like the Idea...
Abou a name, how about AppRollerDex?
I will be registring soon...

[Mr_Gee]

Originally Posted by N1c0_ds

I figured out the best place to get help and support would be from Basic4PPC users. You indubitably know Basic4PPC better than me

So that's what I'm working on. I found a huge support from XDA Developers and people are eager to see this project gain momentum.

However I heard SQL would be the best thing for the database but I don't know anything about this. Could anyone tell me about this and how it works? I'm looking at the samples, the Wiki, the SQL website but I don't get much of it...

Meanwhile I'll be working on a kickass UI ^_^

Glad to see you liked my idea
I'll be willing to help with SQLite if you need any

BTW. this is the proof of concept I mentioned
http://www.basic4ppc.com/forum/share...-versions.html
It is is using xml files to describe the dll files

maybe we come up with a combination of xml and sql... would be a nice project :-)

or complete sql, using the http lib...
that way the user would only see what they want/ need, there wouldn't be any need to download anything... well obviously there would be data .. but you know what i mean

[N1c0_ds]

Originally Posted by Mr_Gee

Glad to see you liked my idea
I'll be willing to help with SQLite if you need any

BTW. this is the proof of concept I mentioned
http://www.basic4ppc.com/forum/share...-versions.html
It is is using xml files to describe the dll files

maybe we come up with a combination of xml and sql... would be a nice project :-)

or complete sql, using the http lib...
that way the user would only see what they want/ need, there wouldn't be any need to download anything... well obviously there would be data .. but you know what i mean

That's what I was suggested, complete SQL, but I don't know how to set this up at all, especially on the server side. I might have a server for this however.

Also the codename is Gecoh (Get Every Cab Only Here), it's from a XDA Developer. We might switch to "Gecko" for the release version.

The icon, along with the most recent changes and updates are found here:
The Gecoh project - Submit your apps NOW! - xda-developers

[Mr_Gee]

I have some knowledge on PHP & MySQL and I have my own server
which I/we can use for testing

The only thing I could use some help with is security, that is not one of my strong points


The reason why I mentioned xml is that some people (myself included) are using apptodate, an I can imagine it is annoying to update the information more than once.

[N1c0_ds]

The problem is that I don't understand what SQL is. I don't know how it works, what files it uses, what it does...

Could someone sort this out for me? I tried Wikipedia, the SQL example and the SQLite page to no avail. Can it work with XML?

[Mr_Gee]

SQL is a language, and an application

SQL Structured Query Language is used to "talk" to a SQL database
you could see a SQL DB as a Excel workbook
each worksheet is a table and the different tabels can be related to each other...

[N1c0_ds]

Originally Posted by Mr_Gee

SQL is a language, and an application

SQL Structured Query Language is used to "talk" to a SQL database
you could see a SQL DB as a Excel workbook
each worksheet is a table and the different tabels can be related to each other...

So SQL is both Excel and the Excel workbook?

I found a really complete tutorial for SQL on W3Schools and it answered a lot of my questions. It explained the syntax and how it worked (pretty simple if you ask) but there's still a few things I don't know:

-Do I need to have a designated server for this? I have a generous friend that donated some of his server space to me since it's very impractical for me to maintain one. However I doubt he will allow me to reconfigure the whole thing!

-I still don't understand where and how the databases are stored! :P

[Mr_Gee]

Originally Posted by N1c0_ds

So SQL is both Excel and the Excel workbook?

I found a really complete tutorial for SQL on W3Schools and it answered a lot of my questions. It explained the syntax and how it worked (pretty simple if you ask) but there's still a few things I don't know:

-Do I need to have a designated server for this? I have a generous friend that donated some of his server space to me since it's very impractical for me to maintain one. However I doubt he will allow me to reconfigure the whole thing!

-I still don't understand where and how the databases are stored! :P

Sorry I typed the above quicly...
Let me give it another try...

Check out this site for a answer to "what is SQL"
SQLCourse - Lesson 1: What is SQL?

SQL is not Excel, I used the parable excel because it's easier to understand, so forget I mentioned it.

This is the structure of an SQLDB (relational DB)

SQL DataBase
    - Database1
        -UserID
        -FirstName
        -Birtday 
        -AddressID
    - Database2
        -AddressID 
        -Street
        -City
        -Country

In this I could ask the database questions, show me all the users with the name "adam", in SQL that would be
SELECT * FROM Database1 WHERE FirstName = 'adam'
this would show me a list of people who's first name is Adam...

I mentioned a "relational DB" because Database1 & 2 are related to each other, the AddressID is in both DB's this means
1. I can link them together
2. people can have the same address, but each address will only be in there once, this reduces the amount of data in the DB

There is more to SQL, if you want to learn more i suggest the internet, that is how I started...
to answer the other questions,
-You need a server for this, it doesn't need to be a dedicated server, unless you will have a lot of trafic/data
If your friend has build his own server it is very likely that he has a SQL DB or knows how to install it (its just as easy as installing Apache)
If he got the domain in a package with a hosting provider, chances are that an SQL server is already included...

-Sorry I cannot help you with this, all I know is SQL needs to be installed as a package on a server, I'm assuming there are a lot of files..
For B4PPC you can use SQLite this is a local file which works as a SQLserver...

Let me know if you have any more questions