Include lsqlite3 in 0.9.0 or later

Questions about the LÖVE API, installing LÖVE and other support related questions go here.
Forum rules
Before you make a thread asking for help, read this.
User avatar
MarekkPie
Inner party member
Posts: 587
Joined: Wed Dec 28, 2011 4:48 pm
Contact:

Re: Include lsqlite3 in 0.9.0 or later

Post by MarekkPie »

I think that given the current LOVE community, the number of developers that would actually both have a game grand enough to benefit from a relational database and then also decide to use it would be extremely small. I like to think LOVE follows the same basic philosophy that Lua does, only adding features when it has an obvious and overwhelming benefit.
User avatar
Hexenhammer
Party member
Posts: 175
Joined: Sun Feb 17, 2013 8:19 am

Re: Include lsqlite3 in 0.9.0 or later

Post by Hexenhammer »

MarekkPie wrote:I think that given the current LOVE community, the number of developers that would actually both have a game grand enough to benefit from a relational database and then also decide to use it would be extremely small. I like to think LOVE follows the same basic philosophy that Lua does, only adding features when it has an obvious and overwhelming benefit.
This. Also who the hell puts game data in an SQL database!? I can't name a single example. It is highly unusual and overly complex. What's next, defining everything in some verbose yet unreadable XML format which is then stored in a SQL database and FactoryFactoryFactoryFactoryFactory methods i.e. going full Enterprise Java. Please don't.
User avatar
MarekkPie
Inner party member
Posts: 587
Joined: Wed Dec 28, 2011 4:48 pm
Contact:

Re: Include lsqlite3 in 0.9.0 or later

Post by MarekkPie »

Hexenhammer wrote:
MarekkPie wrote:I think that given the current LOVE community, the number of developers that would actually both have a game grand enough to benefit from a relational database and then also decide to use it would be extremely small. I like to think LOVE follows the same basic philosophy that Lua does, only adding features when it has an obvious and overwhelming benefit.
This. Also who the hell puts game data in an SQL database!? I can't name a single example. It is highly unusual and overly complex. What's next, defining everything in some verbose yet unreadable XML format which is then stored in a SQL database and FactoryFactoryFactoryFactoryFactory methods i.e. going full Enterprise Java. Please don't.
But DUDE! Just throw in an IoC Container! :)
User avatar
daviddoran
Prole
Posts: 30
Joined: Sun Mar 24, 2013 5:35 am

Re: Include lsqlite3 in 0.9.0 or later

Post by daviddoran »

Hexenhammer wrote:Also who the hell puts game data in an SQL database!?
Hex, even if you feel very strongly about the issue it's probably best not to deride anyone's choices. Doesn't create the right atmosphere.

Can the OP explain the specific use cases in more detail? I'm pretty interested in the issues you're facing.

PS: Sometimes Dependency Injection is just what you need.
User avatar
slime
Solid Snayke
Posts: 3166
Joined: Mon Aug 23, 2010 6:45 am
Location: Nova Scotia, Canada
Contact:

Re: Include lsqlite3 in 0.9.0 or later

Post by slime »

I think Hex's point is that there is not much (or any?) precedent in using an SQL database to store clientside game data in games created by professionals - and if there is, it's probably a pretty niche use case. I've personally found it very helpful to look at what professionals are and are not doing, and try to understand why they made those choices.

Currently, it's possible to use libraries such as lsqlite in LÖVE via require - albeit with some file location limitations for the shared library.
User avatar
daviddoran
Prole
Posts: 30
Joined: Sun Mar 24, 2013 5:35 am

Re: Include lsqlite3 in 0.9.0 or later

Post by daviddoran »

Learning from pro's is useful, I agree 100%. I was just suggesting that Hex could have delivered the message with less sarcasm and derision.
My worry is that threads like this go two ways (1) the original poster gets offended and stops contributing (2) it devolves into a flamewar. Other than that, I can't wait to hear how the pros are doing it.
User avatar
Hexenhammer
Party member
Posts: 175
Joined: Sun Feb 17, 2013 8:19 am

Re: Include lsqlite3 in 0.9.0 or later

Post by Hexenhammer »

daviddoran wrote:I was just suggesting that Hex could have delivered the message with less sarcasm and derision.
Certainly. I admit I was a little rude there but the idea was just.. well let's just say I really don't follow the logic. :cool:
MattRB
Prole
Posts: 11
Joined: Tue Sep 25, 2012 8:16 pm

Re: Include lsqlite3 in 0.9.0 or later

Post by MattRB »

SQLite and other relational databases are used by a TON of developers, you guys are dead wrong. From games like Garry's Mod to every single MMO on the planet.


SQLite is extremely useful, and widely used within not only the gaming industry but the tech industry overall. It's also light and fast (probably faster than whatever shitty serialization technique you're using right now).
User avatar
slime
Solid Snayke
Posts: 3166
Joined: Mon Aug 23, 2010 6:45 am
Location: Nova Scotia, Canada
Contact:

Re: Include lsqlite3 in 0.9.0 or later

Post by slime »

MattRB wrote:SQLite and other relational databases are used by a TON of developers, you guys are dead wrong. From games like Garry's Mod to every single MMO on the planet.


SQLite is extremely useful, and widely used within not only the gaming industry but the tech industry overall. It's also light and fast (probably faster than whatever shitty serialization technique you're using right now).
SQL is used a lot in server-side programs, but I think the discussion here is about adding it to LÖVE in general - it's already pretty trivial to use lsqlite together with Lua or LÖVE in a server, so I can't see why it should be included in LÖVE by default just for that.
User avatar
Robin
The Omniscient
Posts: 6506
Joined: Fri Feb 20, 2009 4:29 pm
Location: The Netherlands
Contact:

Re: Include lsqlite3 in 0.9.0 or later

Post by Robin »

One minor nitpick:
possibility to save game states, without worrying about file location and/or OS issues (like different paths)
In LÖVE, you shouldn't have that worry anyway. If you do, you're doing something terribly wrong.

Anyway, on this issue I wobble a bit back and forth between "LÖVE doesn't need an extra dependency that's going to be largely unused" and "Adding SQLite would give such POWA".
Help us help you: attach a .love.
Post Reply

Who is online

Users browsing this forum: Ahrefs [Bot], Bing [Bot] and 7 guests