[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
32
S
6
G
5
Posts: 437
Reputation: 6,119

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! (but not play them)" Construct Classic - Examples Kit Dropbox is a pile of trash and if you need my old files PM me! :)
B
119
S
41
G
17
Posts: 2,211
Reputation: 19,634

Post » Wed May 11, 2011 12:05 am

maybe podsixnet?
B
32
S
6
G
5
Posts: 437
Reputation: 6,119

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
32
S
6
G
5
Posts: 437
Reputation: 6,119

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! (but not play them)" Construct Classic - Examples Kit Dropbox is a pile of trash and if you need my old files PM me! :)
B
119
S
41
G
17
Posts: 2,211
Reputation: 19,634

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 ImageImage
B
169
S
50
G
173
Posts: 8,313
Reputation: 110,270

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
32
S
6
G
5
Posts: 437
Reputation: 6,119

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
32
S
6
G
5
Posts: 437
Reputation: 6,119

Next

Return to Help & Support using Construct Classic

Who is online

Users browsing this forum: No registered users and 5 guests