Habbox Competitions!
Fancy winning credits and other prizes? Check out what competitions we have open on our forum!
Join the Habbox family!
There's an ENORMOUS array of fun and engaging roles here at Habbox - click to see where you might fit, we'd love to have you!
Rare values!
Wanna find out what you're worth? Our dedicated team of furni buffs are on the job to keep rare values updated as they change!


Results 1 to 7 of 7
  1. #1
    Meanies's Avatar
    Meanies is offline Former Assistant General Manager
    Join Date
    Jun 2005
    Location
    Bournemouth
    Posts
    5,347
    Tokens
    2,166
    Habbo
    Meanies
    View Awards

    Default Mobile App Database

    Not something I've ever played with before but basically I'm looking to make a mobile app which is set around a database. It's nothing fancy I just have no idea where to start and googling has just made it seem way more complicated. Basically I want to have a database of postcodes linked to relevant delivery charges, then on the app side of it you just enter the postcode and it returns the delivery charge. Anyone got any ideas or suggestions?? Needs to be done at no cost too but a lot of these 'app builders' have charges in there somewhere

    cake


  2. #2
    Join Date
    Apr 2013
    Location
    Nottingham
    Posts
    1,612
    Tokens
    5,925
    Habbo
    LiquefiedFilth
    View Awards

    Default

    @Meanies; when I did a mobile app for Uni I just used firebase. Really easy to implement and free.

  3. #3
    Join Date
    Oct 2006
    Posts
    9,825
    Tokens
    25,239
    Habbo
    Zak
    View Awards

    Default

    Quote Originally Posted by Meanies View Post
    Not something I've ever played with before but basically I'm looking to make a mobile app which is set around a database. It's nothing fancy I just have no idea where to start and googling has just made it seem way more complicated. Basically I want to have a database of postcodes linked to relevant delivery charges, then on the app side of it you just enter the postcode and it returns the delivery charge. Anyone got any ideas or suggestions?? Needs to be done at no cost too but a lot of these 'app builders' have charges in there somewhere
    Is the relationship between the postcode and delivery charge 1:1? i.e. a postcode will have only one delivery charge associated to it? What database are you looking to use?

  4. #4
    Meanies's Avatar
    Meanies is offline Former Assistant General Manager
    Join Date
    Jun 2005
    Location
    Bournemouth
    Posts
    5,347
    Tokens
    2,166
    Habbo
    Meanies
    View Awards

    Default

    Quote Originally Posted by Joe View Post
    @Meanies; when I did a mobile app for Uni I just used firebase. Really easy to implement and free.
    I will definitely have a look into that one, thanks for the suggestion!!

    Quote Originally Posted by Zak View Post
    Is the relationship between the postcode and delivery charge 1:1? i.e. a postcode will have only one delivery charge associated to it? What database are you looking to use?
    Yes, each postcode will have a single delivery charge. I'm thinking along the lines of having it so you just enter a partial postcode (such as XX11 1) to cover a small area, rather than every single full postcode. I'm not looking to use any database in particular, anything that is easy and free really!! Once it's set up it will require little to no maintenance.

    cake


  5. #5
    Join Date
    Oct 2006
    Posts
    9,825
    Tokens
    25,239
    Habbo
    Zak
    View Awards

    Default

    Quote Originally Posted by Meanies View Post
    I will definitely have a look into that one, thanks for the suggestion!!



    Yes, each postcode will have a single delivery charge. I'm thinking along the lines of having it so you just enter a partial postcode (such as XX11 1) to cover a small area, rather than every single full postcode. I'm not looking to use any database in particular, anything that is easy and free really!! Once it's set up it will require little to no maintenance.
    I've never built a mobile application but I think SQLite is quite popular (it's also free). There should be lots of tutorials online showing you how to set on of these up. As for the database.. One table containing the postcode and delivery charge value, two procedures.. GetPostcode (for your search) and GetDeliveryChargeByPostcode (using postcode as the parameter to get the delivery charge).

    Is this helpful? I realise I may be oversimplifying things.

  6. #6
    Join Date
    Oct 2006
    Location
    West Midlands
    Posts
    462
    Tokens
    604
    View Awards

    Default

    You can get Post Code data from Office National Statistics which will provide it in CSV format - along with some other data such as political ward codes and any relevant Local Authority data which is quite useful.

    Iím slightly confused about the charges though, how will the charges be calculated if the charges are being stored in a DB?


    Sent from my iPhone using Tapatalk
    Always lurking around, never really post.

  7. #7
    Join Date
    Oct 2006
    Posts
    9,825
    Tokens
    25,239
    Habbo
    Zak
    View Awards

    Default

    Quote Originally Posted by Nli. View Post
    You can get Post Code data from Office National Statistics which will provide it in CSV format - along with some other data such as political ward codes and any relevant Local Authority data which is quite useful.

    I’m slightly confused about the charges though, how will the charges be calculated if the charges are being stored in a DB?


    Sent from my iPhone using Tapatalk
    Each postcode only has a single delivery charge

    So in the database you'd have like..?

    Postcode Ward Latitude Longitude DeliveryCharge
    E1 7AE Portsoken 1.3423 12.2231 2.50
    E1 7AF Portsoken 1.3244 12.2341 3.50

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •