[help+]Does Construct access SQL Databases?

For questions about using Classic.

Post » Tue May 10, 2011 5:13 pm

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..
B
30
S
6
G
5
Posts: 433
Reputation: 6,061

Post » Tue May 10, 2011 5:34 pm

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: [url:n4ask2rt]http://www.scirra.com/forum/viewtopic.php?f=8&t=8169[/url:n4ask2rt]
"Construct 4 lets YOU make advanced games! (maybe)" Construct Classic - Examples Kit
B
86
S
28
G
13
Posts: 2,092
Reputation: 15,009

Post » Wed May 11, 2011 12:05 am

maybe podsixnet?
B
30
S
6
G
5
Posts: 433
Reputation: 6,061

Post » Wed May 11, 2011 2:05 am

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/
B
8
S
3
G
7
Posts: 835
Reputation: 5,313

Post » Wed May 11, 2011 3:25 am

But can I use podsixnet + this pymsmql at the same time?
B
30
S
6
G
5
Posts: 433
Reputation: 6,061

Post » Wed May 11, 2011 8:32 am

[quote="Guif0DA":24nwnq92]But can I use podsixnet + this pymsmql at the same time?[/quote:24nwnq92]

Should be able to, although I heard podsixnet can be pretty laggy sometimes.
"Construct 4 lets YOU make advanced games! (maybe)" Construct Classic - Examples Kit
B
86
S
28
G
13
Posts: 2,092
Reputation: 15,009

Post » Wed May 11, 2011 9:55 am

>> 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.
B
8
S
3
G
7
Posts: 835
Reputation: 5,313

Post » Wed May 11, 2011 2:48 pm

Might check this thread out.
[url:hg72jo0r]http://www.scirra.com/forum/viewtopic.php?f=8&t=1389&hilit=high+score[/url:hg72jo0r]
Image Image
B
161
S
48
G
90
Posts: 7,356
Reputation: 66,767

Post » Wed May 11, 2011 2:57 pm

It's a turn-based game that access SQL Database, i think lag won't be a great problem..
B
30
S
6
G
5
Posts: 433
Reputation: 6,061

Post » Thu May 12, 2011 6:42 am

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

Should work?
B
30
S
6
G
5
Posts: 433
Reputation: 6,061

Next

Return to Help & Support using Construct Classic

Who is online

Users browsing this forum: No registered users and 3 guests