New Posts  All Forums:Forum Nav:

SQL and android?

post #1 of 7
Thread Starter 
so a friend and i are working on some apps and he has most of the idea/basic coding done and left me with the SQL part of it. I've never worked with sql before, but from the sound of it, it's not to hard to pick up. Was wondering how long it would take to be able to program an SQL leaderboard in to a game and get a site up and working to send and receive scores.
Precious 2.0
(15 items)
 
My precious
(16 items)
 
 
CPUMotherboardGraphicsRAM
R7 1700 @ 3.9 | 1.35v Asus VI Crosshair Hero EVGA Titan X Hybrid 1514/2000 32GB Gskill DDR4 3200 TridentZ 
Hard DriveOptical DriveCoolingOS
Samsung 840PRO 256GB LG 10x Blu-ray Burner Swiftech H220-X Window 8.1 Professional 64Bit 
MonitorMonitorKeyboardPower
Crossover 27inch Acer XB270HU 144Hz G-Sync Deck Legend tactile frost EVGA G2 750W 
CaseMouseAudio
Coolmaster Haf 932 DeathAddder 3.5 Black edition Titanium HD | O2 DAC + AMP 
CPUMotherboardGraphicsRAM
Intel i7-970 @ 4.2 Asus Rampage Formula III Asus DC2 R9 290X @ 1110 24GB of Samsung DDR3 @ 1866 
Hard DriveOptical DriveCoolingOS
Samsung 840PRO 256GB | 2x Samsung F4 2TB | WD 6... LG 10x Blu-ray Burner H70 with 2x GT2150 Window 8.1 Professional 64Bit 
MonitorKeyboardPowerCase
Dell 2407WHFP-HC and Crossover 27Q LED-P Deck Legend tactile frost Seasonic 700watt M12 Coolmaster Haf 932 
MouseMouse PadAudioAudio
DeathAddder 3.5 Black edition TeamLiquid Goliathus Titanium HD AudioEngine A2 and ATH-700D 
CPUGraphicsRAMHard Drive
Intel - 3630QM Nvidia GTX 680M 8 GB DDR3 1600 500GB 7200 | 128 GB Samsung 840 Pro 
Optical DriveOS
DVD RW  Windows 8 Pro 
  hide details  
Reply
Precious 2.0
(15 items)
 
My precious
(16 items)
 
 
CPUMotherboardGraphicsRAM
R7 1700 @ 3.9 | 1.35v Asus VI Crosshair Hero EVGA Titan X Hybrid 1514/2000 32GB Gskill DDR4 3200 TridentZ 
Hard DriveOptical DriveCoolingOS
Samsung 840PRO 256GB LG 10x Blu-ray Burner Swiftech H220-X Window 8.1 Professional 64Bit 
MonitorMonitorKeyboardPower
Crossover 27inch Acer XB270HU 144Hz G-Sync Deck Legend tactile frost EVGA G2 750W 
CaseMouseAudio
Coolmaster Haf 932 DeathAddder 3.5 Black edition Titanium HD | O2 DAC + AMP 
CPUMotherboardGraphicsRAM
Intel i7-970 @ 4.2 Asus Rampage Formula III Asus DC2 R9 290X @ 1110 24GB of Samsung DDR3 @ 1866 
Hard DriveOptical DriveCoolingOS
Samsung 840PRO 256GB | 2x Samsung F4 2TB | WD 6... LG 10x Blu-ray Burner H70 with 2x GT2150 Window 8.1 Professional 64Bit 
MonitorKeyboardPowerCase
Dell 2407WHFP-HC and Crossover 27Q LED-P Deck Legend tactile frost Seasonic 700watt M12 Coolmaster Haf 932 
MouseMouse PadAudioAudio
DeathAddder 3.5 Black edition TeamLiquid Goliathus Titanium HD AudioEngine A2 and ATH-700D 
CPUGraphicsRAMHard Drive
Intel - 3630QM Nvidia GTX 680M 8 GB DDR3 1600 500GB 7200 | 128 GB Samsung 840 Pro 
Optical DriveOS
DVD RW  Windows 8 Pro 
  hide details  
Reply
post #2 of 7
SQL is just a query structure for connecting to a database. You need some kind of front-end that is going to run the queries to push/pull from a database, be it PHP or HTML/JS or some combination of the above (for a web-face); or, you could use JDBC connectivity with Java (while likely using a JDBC-ODBC bridge for compatibility).
Edited by Plex - 1/24/11 at 6:09am
Intellect v2
(9 items)
 
  
CPUMotherboardGraphicsRAM
Intel Core i7-6700K Processor ASUS ROG MAXIMUS VIII HERO LGA1151 DDR4 M.2 SAT... EVGA GTX 1080 SC ACX 3.0 Crucial Ballistix Sport 32GB DDR4 2400 MT/s (PC... 
CoolingKeyboardPowerCase
Noctua NH-D15 Das Keyboard 4 Professional (Brown) Corsair AX860 Fractal Design Define R5 
Mouse
MIONIX NAOS 7000 
  hide details  
Reply
Intellect v2
(9 items)
 
  
CPUMotherboardGraphicsRAM
Intel Core i7-6700K Processor ASUS ROG MAXIMUS VIII HERO LGA1151 DDR4 M.2 SAT... EVGA GTX 1080 SC ACX 3.0 Crucial Ballistix Sport 32GB DDR4 2400 MT/s (PC... 
CoolingKeyboardPowerCase
Noctua NH-D15 Das Keyboard 4 Professional (Brown) Corsair AX860 Fractal Design Define R5 
Mouse
MIONIX NAOS 7000 
  hide details  
Reply
post #3 of 7
Java allows for SQL querying through ODBC. You could do it natively in the android app. As for setting it up it all depends on you knowledge of the controlling programming language such as JAVA and how quick you are to pick up the Structured Query Language (SQL). You can run a free mySQL server on any desktop computer and I would suggest getting familiar with the language before trying to start in on a larger project. www.W3Schools.com has great tutorials on what you would need.

I personally develop using PHP in conjuction with mySQL as I find it easier than JAVA or ASP, but thats just personal preference.
 
Home Server
(13 items)
 
 
CPUMotherboardGraphicsRAM
intel i5 2410m Lenovo Y570 GeForce 555m 4GB DDR3 1333 
Hard DriveOptical DriveCoolingOS
750GB 5400 HDD Blu Ray Stock Win 7 64 Home Premium 
CPUMotherboardGraphicsRAM
Core2Duo e6320 @2.3GHZ Gigabyte DS3 MSI 8600GTS 4x512MB G.Skill DDR2 
Hard DriveOSMonitorKeyboard
2x120 GB WD cavair SATA Ubuntu 10.1 VM Win 7 Acer 22" and AOC 19" Logitec wireless keyboard 
PowerCaseMouse
Ultra X-2 550w X-Dreamer logitech mx1000 cordless 
  hide details  
Reply
 
Home Server
(13 items)
 
 
CPUMotherboardGraphicsRAM
intel i5 2410m Lenovo Y570 GeForce 555m 4GB DDR3 1333 
Hard DriveOptical DriveCoolingOS
750GB 5400 HDD Blu Ray Stock Win 7 64 Home Premium 
CPUMotherboardGraphicsRAM
Core2Duo e6320 @2.3GHZ Gigabyte DS3 MSI 8600GTS 4x512MB G.Skill DDR2 
Hard DriveOSMonitorKeyboard
2x120 GB WD cavair SATA Ubuntu 10.1 VM Win 7 Acer 22" and AOC 19" Logitec wireless keyboard 
PowerCaseMouse
Ultra X-2 550w X-Dreamer logitech mx1000 cordless 
  hide details  
Reply
post #4 of 7
Thread Starter 
alright, thanks.
Precious 2.0
(15 items)
 
My precious
(16 items)
 
 
CPUMotherboardGraphicsRAM
R7 1700 @ 3.9 | 1.35v Asus VI Crosshair Hero EVGA Titan X Hybrid 1514/2000 32GB Gskill DDR4 3200 TridentZ 
Hard DriveOptical DriveCoolingOS
Samsung 840PRO 256GB LG 10x Blu-ray Burner Swiftech H220-X Window 8.1 Professional 64Bit 
MonitorMonitorKeyboardPower
Crossover 27inch Acer XB270HU 144Hz G-Sync Deck Legend tactile frost EVGA G2 750W 
CaseMouseAudio
Coolmaster Haf 932 DeathAddder 3.5 Black edition Titanium HD | O2 DAC + AMP 
CPUMotherboardGraphicsRAM
Intel i7-970 @ 4.2 Asus Rampage Formula III Asus DC2 R9 290X @ 1110 24GB of Samsung DDR3 @ 1866 
Hard DriveOptical DriveCoolingOS
Samsung 840PRO 256GB | 2x Samsung F4 2TB | WD 6... LG 10x Blu-ray Burner H70 with 2x GT2150 Window 8.1 Professional 64Bit 
MonitorKeyboardPowerCase
Dell 2407WHFP-HC and Crossover 27Q LED-P Deck Legend tactile frost Seasonic 700watt M12 Coolmaster Haf 932 
MouseMouse PadAudioAudio
DeathAddder 3.5 Black edition TeamLiquid Goliathus Titanium HD AudioEngine A2 and ATH-700D 
CPUGraphicsRAMHard Drive
Intel - 3630QM Nvidia GTX 680M 8 GB DDR3 1600 500GB 7200 | 128 GB Samsung 840 Pro 
Optical DriveOS
DVD RW  Windows 8 Pro 
  hide details  
Reply
Precious 2.0
(15 items)
 
My precious
(16 items)
 
 
CPUMotherboardGraphicsRAM
R7 1700 @ 3.9 | 1.35v Asus VI Crosshair Hero EVGA Titan X Hybrid 1514/2000 32GB Gskill DDR4 3200 TridentZ 
Hard DriveOptical DriveCoolingOS
Samsung 840PRO 256GB LG 10x Blu-ray Burner Swiftech H220-X Window 8.1 Professional 64Bit 
MonitorMonitorKeyboardPower
Crossover 27inch Acer XB270HU 144Hz G-Sync Deck Legend tactile frost EVGA G2 750W 
CaseMouseAudio
Coolmaster Haf 932 DeathAddder 3.5 Black edition Titanium HD | O2 DAC + AMP 
CPUMotherboardGraphicsRAM
Intel i7-970 @ 4.2 Asus Rampage Formula III Asus DC2 R9 290X @ 1110 24GB of Samsung DDR3 @ 1866 
Hard DriveOptical DriveCoolingOS
Samsung 840PRO 256GB | 2x Samsung F4 2TB | WD 6... LG 10x Blu-ray Burner H70 with 2x GT2150 Window 8.1 Professional 64Bit 
MonitorKeyboardPowerCase
Dell 2407WHFP-HC and Crossover 27Q LED-P Deck Legend tactile frost Seasonic 700watt M12 Coolmaster Haf 932 
MouseMouse PadAudioAudio
DeathAddder 3.5 Black edition TeamLiquid Goliathus Titanium HD AudioEngine A2 and ATH-700D 
CPUGraphicsRAMHard Drive
Intel - 3630QM Nvidia GTX 680M 8 GB DDR3 1600 500GB 7200 | 128 GB Samsung 840 Pro 
Optical DriveOS
DVD RW  Windows 8 Pro 
  hide details  
Reply
post #5 of 7
Quote:
Originally Posted by Leprachuan View Post
Java allows for SQL querying through ODBC. You could do it natively in the android app. As for setting it up it all depends on you knowledge of the controlling programming language such as JAVA and how quick you are to pick up the Structured Query Language (SQL). You can run a free mySQL server on any desktop computer and I would suggest getting familiar with the language before trying to start in on a larger project. www.W3Schools.com has great tutorials on what you would need.

I personally develop using PHP in conjuction with mySQL as I find it easier than JAVA or ASP, but thats just personal preference.
This. SQL is fairly easy to pick up, all of the commands you'll need are on the w3schools tutorial. I also use PHP and SQL together (they play oh so nicely together) but for your app I'd be using Java.
Orange != Red
(20 items)
 
  
Reply
Orange != Red
(20 items)
 
  
Reply
post #6 of 7
Android is Java, so unless you're using the Android NDK it should be dead simple.

I know from experience that getting Java to connect to a PostgreSQL database takes about 5 lines of code.


What you need is JDBC: http://www.oracle.com/technetwork/ja...dbc/index.html

Get the appropriate driver for whatever DB you're using and pray it works with the Dalvik VM.
    
CPUMotherboardGraphicsRAM
Core i5 4670k ASUS Maximus VI Gene Gigabyte GTX 460 1GB Kingston Hyper-X 
Hard DriveHard DriveHard DriveHard Drive
Samsung 830 OCZ Vertex 3 WD6401AALS WD5000AAKS 
CoolingOSMonitorMonitor
Noctua NH-D14 elementary OS Dell Ultrasharp U2312HM LG W2442PA-BF 
KeyboardPowerCaseMouse
Microsoft Sidewinder X4 Corsair HX750W Corsair Graphite 600T Logitech G700 
Audio
ASUS Xonar DG 
  hide details  
Reply
    
CPUMotherboardGraphicsRAM
Core i5 4670k ASUS Maximus VI Gene Gigabyte GTX 460 1GB Kingston Hyper-X 
Hard DriveHard DriveHard DriveHard Drive
Samsung 830 OCZ Vertex 3 WD6401AALS WD5000AAKS 
CoolingOSMonitorMonitor
Noctua NH-D14 elementary OS Dell Ultrasharp U2312HM LG W2442PA-BF 
KeyboardPowerCaseMouse
Microsoft Sidewinder X4 Corsair HX750W Corsair Graphite 600T Logitech G700 
Audio
ASUS Xonar DG 
  hide details  
Reply
post #7 of 7
i code sql for a living, although i'm not amazing, if you have a question please feel free to ask.

if you really want to learn i suggest that when working a project you do as much with sql as you can. as stated above sql is usually paired with a frontend written in a different language, so try writing stored procedures/functions in sql and calling them instead of passing one liners back and forth through api calls. better for security as well.
    
CPUMotherboardGraphicsRAM
i7-2600k asrock z68 extreme4 gen3 9800 gtx+ 2x4 vegeance (8-8-8-24) 
Hard DriveCoolingOSMonitor
samsung 830 256gb+ 1tb wd green + 3tb hitachi corsair h60 windows 7/slackware/arch linux/gentoo dual 28" i-inc 
KeyboardPowerCaseMouse
filco majestouch 2 ninja cm silent pro 600w cm 690 II razer deathadder 
Mouse Pad
razer exactmatXspeed 
  hide details  
Reply
    
CPUMotherboardGraphicsRAM
i7-2600k asrock z68 extreme4 gen3 9800 gtx+ 2x4 vegeance (8-8-8-24) 
Hard DriveCoolingOSMonitor
samsung 830 256gb+ 1tb wd green + 3tb hitachi corsair h60 windows 7/slackware/arch linux/gentoo dual 28" i-inc 
KeyboardPowerCaseMouse
filco majestouch 2 ninja cm silent pro 600w cm 690 II razer deathadder 
Mouse Pad
razer exactmatXspeed 
  hide details  
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Coding and Programming