[help+]Does Construct access SQL Databases?

This forum is currently in read-only mode.
0 favourites
From the Asset Store
Casino? money? who knows? but the target is the same!
  • Hi

    Can Construct access SQL databases to gather informations or add/remove info in it?

    If so, what would be the right way? With Python or there is a object who can do that?

    ty

    edit: please see my last post, got some questions..

  • Um, I think you'd need to use Python SQL libraries or code a plugin for that. Should be possible though. Take a look at the python tutorials on this list: http://www.scirra.com/forum/viewtopic.php?f=8&t=8169

  • Try Construct 3

    Develop games in your browser. Powerful, performant & highly capable.

    Try Now Construct 3 users don't see these ads
  • maybe podsixnet?

  • I would go with Jayjays suggestion, either:

    1. Sqlite: which is built into Python http://docs.python.org/library/sqlite3.html

    2. Pymsmql: Python Library to access MS SQL databases http://code.google.com/p/pymssql/

  • But can I use podsixnet + this pymsmql at the same time?

  • But can I use podsixnet + this pymsmql at the same time?

    Should be able to, although I heard podsixnet can be pretty laggy sometimes.

  • > But can I use podsixnet + this pymsmql at the same time?

    Yes, you can definitely combine them at the same time.

    although I heard podsixnet can be pretty laggy sometimes.

    Lag isn't an issue when accessing SQL databases (at least in choice of library to use). Podsixnet will perform just as good as Raknet or any other fast UDP library when it comes to things like this.

    On a separate note, to reduce the appearance of lag w/ Podsixnet you can use client-side interpolation and also use ping times to adjust your positions. Client-side interpolation is really easy to implement in construct using lerp() and timedelta.

  • It's a turn-based game that access SQL Database, i think lag won't be a great problem..

  • What about this MySQLdb module from http://www.tutorialspoint.com/python/py ... ccess.htm??

    Should work?

  • Yes, I looked through the example the module real quick and I don't see why it shouldn't work. The module supports Python 2.6 so that is good.

  • Yes, I looked through the example the module real quick and I don't see why it shouldn't work. The module supports Python 2.6 so that is good.

    can u help me use it in construct?

    I'm trying to follow your tutorial but i got some questions..

    do i need to first install the module then use py2exe and then add the libraries into the construct folder?

    if so, how do i install the module? tryed but can't..

  • How do I install this module plz some1 help me..

    http://sourceforge.net/projects/mysql-python

    I downloaded already and i think i need to run this setup.py but i can't.. i extracted the folder mysql-python-1.2.3 into c:\python26\ ..this is what i tryed:

    1-open cmd

    2-cd MySQL-python-1.2.3

    3-python setup.py build

    but i get an error..''python is not recognized a command...etc"

    and if i just type setup.py build

    i get:

    importerror: no module named setuptools

    can any1 help plz?

  • Normally you can just do a "python setup.py install".

    If you type python at the command line and it is not recognized then you don't have Python installed correctly. Install this version of Python:

    http://www.python.org/download/releases/2.6.6/

    After you install Python and test with a "python" at the command line then try the "python setup.py install"

    If that doesn't work you could try setuptools:

    http://pypi.python.org/pypi/setuptools

    Let me know how it goes.

    p.s. Even if we get a networking plugin, it wont interface with SQL databases; so you would still need a Python solution for this or somebody would have to write an SQL access plugin.

    Edit... also try "setup.py install". ... you might not need the python in front...but you do need Python installed.

    Edit2: You may also want to try an executable build.

    http://www.codegood.com/archives/4

  • Normally you can just do a "python setup.py install".

    If you type python at the command line and it is not recognized then you don't have Python installed correctly. Install this version of Python:

    http://www.python.org/download/releases/2.6.6/

    After you install Python and test with a "python" at the command line then try the "python setup.py install"

    If that doesn't work you could try setuptools:

    http://pypi.python.org/pypi/setuptools

    Let me know how it goes.

    p.s. Even if we get a networking plugin, it wont interface with SQL databases; so you would still need a Python solution for this or somebody would have to write an SQL access plugin.

    Edit... also try "setup.py install". ... you might not need the python in front...but you do need Python installed.

    Edit2: You may also want to try an executable build.

    http://www.codegood.com/archives/4

    but as I said i tryed to just 'setup.py build' and 'setup.py install' but none worked too..

    the command python to work, do I need to be in the in the python directory or the command works at any folder in CMD?

    like i'm im C:\Program Files\ and type python, it should recognize the command?

    edit: Downloaded setuptools and tryed to build and install, now i'm getting a different problem, something about my windows registration key

Jump to:
Active Users
There are 1 visitors browsing this topic (0 users and 1 guests)