Description

Version 3.2 is out, be sure to read the changes section

** GMS 1.4 and GMS2 compatible **

GMSDB is a database system written entirely in GML that can be used in any kind of project requiring a simple solution to store and retrieve organized data.

With GMSDB you can easily perform basic CRUD (create,read,update,delete) operations on a database table while applying custom filters, sorting, limits, offsets, calculations and joins on the result set.

FEATURES

  • All in GML, doesn't require any external DLLs etc.
  • Comprehensive and flexible query system
  • Ability to sort, filter, limit, offset and join your query result
  • Load and save the whole database or specific table to file
  • Import and export table data from and to CSV file to be used with excel
  • Well commented code and extensive documentation
  • Get started with the included examples showing how to build a simple highscore and inventory system
  • Includes some useful generic CSV parsing scripts

LINKS

Documentation and install guide

Download demo

Forum topic

My assets: FormLESS (UI framework), GMGL (autoupdater & launcher), Autotiles Helper (auto tiling system), Jade UI (UI sprites)

End User Licence Agreement (EULA).

Changes in 3.2.0

Version 3.2 changes a lot of functions related to the database saving system, and a few functions have been renamed or removed.

Be sure to read the section about upgrading from 3.1 to 3.2 in the documentation. You will also find a list of every other change introduced in version 3.2

Version 3.2.0. Published March 10, 2017

Created with GameMaker: Studio v1.4.1763

Age Rating: 4+

Average Rating

Your review

You can only review assets you've bought.


Gravatar

Santiago F 18 October 2017

Awesome!


Gravatar

Trung L 20 September 2017

Exactly what I was looking for!

Played around with the library few days ago and I am very satisfied with my experience so far! I managed to integrate it with my current RPG and it worked great althought I couldn't make it work with HTML5 local storage. Does it work with HTML5 local storage and if so could you please make a document about it?

Logo

Homunculus (Publisher) 21 September 2017

Hi! It has been tested with the HTML5 module, and should work as expected unless something changed in the recent updates. If you could be more specific about the problem you are facing I can take a look. Feel free to contact me by email about this.


Gravatar

Joshua D 09 September 2017


Gravatar

Indie L 19 August 2017


Gravatar

Anas a 04 June 2017

Very good

can you please send me a video of how to create high scores list in my game?

Logo

Homunculus (Publisher) 05 June 2017

The provided example already has a working example of high score for multiple levels, did you try to base yours on that? If you already tried, feel free to write me an email so I can give you support, it should be quite easy to implement


Gravatar

Anonymous 22 May 2017

Very Powerful

This is invaluable for handling massive amounts of data and the creator was very patient with me when I misunderstood something. I had no trouble getting JSON data imported with JSOnion.


Gravatar

Christian B 19 May 2017

A must for any database need

This is amazing and gives you a great database system. If you have ever used any type of sql it will be easy to get the ball rolling, if you have not, the creator has written a really awesome guide to help you get started. Worth every penny!


Gravatar

craig s 29 March 2017


Gravatar

Johan L 11 March 2017

Truly the best database system for your game!


Gravatar

David H 10 March 2017


Gravatar

Austen L 25 May 2016

Fantastic and powerful

This covers one of Game Maker's major weaknesses. Like Glen H says below, the sheer number of things you can do can be overwhelming (if you're not terribly experienced with databases, like I am, it takes a lot of getting used to), but the documentation is thorough and high quality. If you have a large amount of information to manage in your game, you're handicapping yourself by not using this package.

Its biggest weakness may well be that you need a GM:S pro license to buy it. Unless YoYo adds a native database system, this will be in my back pocket for a long time.

This review was left for a previous version of this asset.


Gravatar

Glen H 05 May 2016

I really like this, but it can be overhwelming.

It's very smooth. Although, I find it a bit difficult to go through all the scripts and make edits where I need to make it fit my requirements. I did not expect there to be so many scripts to make this engine run. You put a lot of work into it. I'm going to need help getting what I want out of it though. I sent you an email with more details on what I would like to accomplish with these scripts.

This review was left for a previous version of this asset.

Logo

Homunculus (Publisher) 06 May 2016

Hi Glen, I'm aware that the system is heavy in scripts and overall code, and that's why I dedicated a lot of time writing the documentation.
The idea though is that you shouldn't need to change nor understand the scripts at all, but just use them, since it's a multipurpose database. Feel free to contact me for more info.


Gravatar

M G 28 April 2016

Great Asset

I would like a little more documentation in importing from a CSV file, like how working path operates, and a few "natural language" explanations on the db_table_load_csv script (specifically, what is expected from the working path and separator arguments

This review was left for a previous version of this asset.

Logo

Homunculus (Publisher) 29 April 2016

Hi! It's a good remark, CSV file import seems to be one of the most used features and it's probably not documented enough in the docs. I'll briefly explain here about work path and separator, but I'll update the docs soon.
The csv file path operates like any other path in GM. Internally it uses file_text_open_read(path), so you should consider the same constraints (sandboxing etc...). About the separator, usually it is expected of a CSV file to use comma ',' as separator, but that's not always the case, especially in localized versions of excel (mine, which is in italian, uses semicolon by default for example).


Gravatar

Kelvin K 15 April 2016

Amazing!

The database is amazingly powerful! It is easily able to fulfill a variety of roles, not just your standard inventory system. The documentation is well-done, covering pretty much all you need to know. And if you still have problems, the developer is really good at explaining things and guiding you through the process.

All in all, a great buy.

This review was left for a previous version of this asset.


Gravatar

Roelf M 09 June 2016

This is Truly The Best DB Solution

This is a really good DB solution for game maker studio.I have been searching google for DB tutorials for GMS and only found 1 which didnt really work.But this worked perfectly for my rpg login,inventory,shops,Claimed lands etc etc.Thank you very much

This review was left for a previous version of this asset.


Gravatar

Andrea V 16 March 2016

5 stars!

Perfect database for all my game! Great!

This review was left for a previous version of this asset.


Gravatar

Andreas M 14 April 2016

A must have. (7 stars)

Great database functions. With this it's simple to organize inventory, shops ...
Suggestion:
Ability to have multiple databases open

This review was left for a previous version of this asset.


Gravatar

mostefai b 22 July 2015

very convenient

it worked perfectly for all my windows games.

This review was left for a previous version of this asset.


Gravatar

Bradley C 08 July 2015

Very Useful!

I actually used this for a simple non-game app and it worked beautifully! The developer was also very patient with my boneheaded questions. The examples and the documentation are great!

This review was left for a previous version of this asset.


Gravatar

davide m 30 March 2015

Awesome!

This asset is very well programmed and can be used in many different situations, saving you lot of time. Super happy with the documentation, too, and the publisher is very gentle and willing to help. Great!

This review was left for a previous version of this asset.

Package contents

Total size 827 KB

GMSDB - GM Simple Database.extension.gmx 6.85 KB GMSDB - GM Simple Database
Assets
Backgrounds datafiles Fonts Objects Rooms Scripts
csv_compose_line.gml 640 Bytes csv_parse_line.gml 1.14 KB db_autosave.gml 446 Bytes db_close.gml 437 Bytes db_cl_join.gml 484 Bytes db_cl_limit.gml 338 Bytes db_cl_only.gml 603 Bytes db_cl_sort.gml 752 Bytes db_cl_where.gml 590 Bytes db_exists.gml 142 Bytes db_export.gml 1010 Bytes db_free.gml 231 Bytes db_import.gml 3.53 KB db_init.gml 323 Bytes db_list_tables.gml 199 Bytes db_open.gml 1.22 KB db_op_between.gml 354 Bytes db_op_eq.gml 291 Bytes db_op_gt.gml 337 Bytes db_op_gte.gml 347 Bytes db_op_lt.gml 334 Bytes db_op_lte.gml 344 Bytes db_op_neq.gml 291 Bytes db_query_calc.gml 1.41 KB db_query_delete.gml 240 Bytes db_query_exec.gml 2.98 KB db_query_free.gml 264 Bytes db_query_select.gml 1.38 KB db_query_update.gml 998 Bytes db_record_build.gml 1.73 KB db_record_create.gml 1.65 KB db_record_delete.gml 1.03 KB db_record_destroy.gml 326 Bytes db_record_exists.gml 264 Bytes db_record_fetch.gml 1.18 KB db_record_fetch_all.gml 1.42 KB db_record_first.gml 579 Bytes db_record_get.gml 578 Bytes db_record_rnd.gml 756 Bytes db_record_save.gml 1.77 KB db_record_update.gml 1.46 KB db_save.gml 1.09 KB db_table_clear.gml 451 Bytes db_table_column_add.gml 925 Bytes db_table_column_names.gml 638 Bytes db_table_column_remove.gml 1.01 KB db_table_create.gml 1.78 KB db_table_delete.gml 710 Bytes db_table_exists.gml 130 Bytes db_table_export.gml 580 Bytes db_table_export_csv.gml 949 Bytes db_table_import.gml 874 Bytes db_table_import_csv.gml 921 Bytes db_table_size.gml 240 Bytes ds_grid_multisort.gml 1.7 KB pair_get.gml 392 Bytes string_parse.gml 975 Bytes _db_qf_calc.gml 1.16 KB _db_qf_delete.gml 991 Bytes _db_qf_fetch.gml 2.56 KB _db_qf_select.gml 2.07 KB _db_qf_sort.gml 2.28 KB _db_qf_update.gml 971 Bytes _db_query_init.gml 629 Bytes _db_table_column_indexes.gml 571 Bytes _db_table_get_path.gml 170 Bytes _db_table_load.gml 797 Bytes _db_table_merge.gml 2.38 KB _db_table_reindex.gml 343 Bytes _db_table_save.gml 139 Bytes
Sprites

What is the issue?

Back to Top