Search - Ez Database

I ran into an issue with EZ Database. A couple days ago I started a new database with two rows of data. Yesterday I added 2 more rows of data. I backed up the database. Then I closed the file and database. When I opened the file today the file had only 2 rows of data with the additional 2 rows missing. I messed around opening and closing the file and database. Every now and then the file when opened had.the 4 rows of data. Most of the time when I opened the file there were only 2 rows of data.
3y ago
I have all of these except transcendent academy. It's been 1 real life week since my IQ stopped at 110 but a large chunk of my population is student in the high end buildings who has lots of teachers, but there is no progress and not a SINGLE colonist seem interested in some jobs.

All students and all teachers under view have no age, no happyness, no money number, all NaN style, so I suspect the game sorta simulate what it can't calculate individually --- but for some chunk of education that's done wrong.

And of course my population is terminally unhappy from being uneducated for the duration, except logically the teachers (I have max teachers in each school) but even calculating how many teachers I have in my small community college, the number of people unhappy from lack of education doesn't make sense since the requirements of that teacher job. It's same in all my education building types.

So where does the database help???

NONE of the buildings have a education/IQ gained by tick math on it. I can't know if one is 1000 times less efficient than the other, and how much 1 teacher is different from 0, and so on. GUESSWORK hasn't worked and having some of each never broke the 110 IQ limit.

There are currently 250 people in the small community college, whose IQ limit is 130, the teachers are maxxed and teachers require 130 IQ...

...yet since ALL students and ALL teachers in ALL education buildings have NaN stats, and are probably estimated from the non-simulated truly calculated individuals (of which there is none) then that means no education progress. IS THAT THE PROBLEM? Fire drills doesn't fix it. Killing simulated colonists doesn't fix it. 1 week of real life time doesn't fix it.

I looked at the entire database, there is no info in the database about education that isn't in the ingame information. The database does not have an "IQ" entry either. There is simply no way to know for sure ANYTHING about why my colony is stuck.

And oh, it's probably stuck at several undocumented levels simultaneously, but education is an obvious one.
3y ago
Upgraded to new iPhone no database so I purchased it still no database. Is there anywhere to look for old database .. I have backup of iPhone prior to upgrade.. Or is it lost forever
2y ago
Is there a way of doing that to create a media database through EZ database?

1y ago
I'm really enjoying this app, but I'm finding that even though cloudsync is on, if I access the database again, from either this computer or another or even the app, an old version of the database is displayed. To see the latest, I am having to export the database after each update and then open the EZD file. Even then, it sometimes reverts to an old version, and I have to close the file & re-open the exported file. Can anyone help?
11mo ago
I have been making some changes to the forum over the last couple of days and I wanted to discuss some of the new and upcoming changes.

First of all, you can now finally leave a Conversation. The 'Leave Conversation' button is now functional. You might have to hard-reload to refresh the appropriate scripts, but it works now.

There is also a new nightly task that runs on the server every night that automatically does several database operations, but also will automatically delete any conversation over a month old that has 0 messages or replies. So if you have a bunch of those 'Let's Talk' conversations with nothing in them, they will automatically be purged after one month.

Next up is forum notifications/alerts, which are currently (as of yesterday) being populated in an internal database, and will soon be going live. Notification events include when you are mentioned in a post, or quoted, or when somebody posts on your wall or comments on one of your pictures. I will also be adding the ability to subscribe to topics and be notified that way. The notification area will be at the top of the forum next to your username. Once I have enough notifications in the database, I will start implementing the UI for it, so if you want to speed it along, just quote some of my posts or give me some @ mentions, lol.

Also, I am adding the ability to create a 'Podcast' section of the forum, which is a new page type. I will be using this feature to migrate the old My Colony Podcast over to this site, that way I can stop paying for the separate Podcast server without actually having to delete the My Colony Podcast. Who knows, having it on here might inspire me to actually make a new episode.

Finally this week, I will be adding two new global sections, Timeline and Subscriptions. Timeline will show the latest threads across the forum, and subscriptions should be obvious, which is based on the upcoming thread subscription feature.

Anyway, that is all for this week. Let me know what issues/comments you have. Enjoy!
4y ago
Ansom said:The game is almost full documented.

In this site, you can read everything (building cost, tech, Requirements, build by, ecc), storage value, Resource transformed and produced every tick or minute.

Yes, this is where I spent an average of 1.5 real life days until I figure out what should have been in a tooltip all along --- so that I KNOW WHICH INFORMATION I WANT BECAUSE THE CAUSE OF THE PROBLEM IS OBVIOUS.

But without the tooltips, I can't know what information I need since the problem can be a large number of not-documented-ingame things so I have to check them all --- and once I check them all I am usually wrong on all guesses, and the ENTIRE database has to be scummed one by one to finally stumble on an UNGUESSABLE rule somewhere that requires something.

...For the love of God --- let us know why we're stuck, and let us eyeball the full building stats ingame each time we look at the building tooltip or from the menu or something so we're not forced to do a 3-minutes database dive for EACH AND EVERY SINGLE NEW BUILDING.

P.S.: the database is viewable at a rate of one entry per 3 minutes at best, since last year, for some reason. Usually worse when searching for building whose name starts with something really common. It was BAD when it was FAST, now it's making the game unplayable.
3y ago
I like EZ Database! Thanks for making it.

Can you add many-to-one support in the relationship field type so that a record with a foreign key to another table can multi-select values from the foreign table and have those multiple values displayed separated by semicolons?

This would make lookup tables more functional.

For example, I’d like to use EZ Database to make a migraine headache log. One table is for the log, and another table is to hold medicines taken, and yet another table is for triggers. One Log entry can have multiple values from medicines and from Triggers. But to do that in the current version, I’d have to add multiple lookup fields to support something like “medicine taken 1”, “medicine taken 2”, etc. it would be much better to have a single “Medicines Taken” field that referenced multiple records in the Medicines table, with each medicine listed in the log separated by semicolons.
3y ago
Hi - is there a userguide or help info for EZ Database? Just downloaded the app and starting to build a database but I've got some basic questions and could self serve if there's a help guide? Thanks!
3y ago
Hi - is there a userguide or help info for EZ Database? Just downloaded the app and starting to build a database but I've got some basic questions and could self serve if there's a help guide? Thanks!
3y ago
Ez database. Updated my iphone. Now it wanted login. So I purchased it but can’t find my database... any idea where I could look to find it?
2y ago
I upgrade my iPhone and when restored from backup EZ Database made me sign on .. so I purchased it. But still can’t find my database. Where is it stored? Is there anyway to find it. I have an old backup of my phone
2y ago
Just continuing the discussion from the in-game chat - files are currently saved on MyColony (and assuming other games via encoded JSON). This takes up a lot of space because the object schema is included every payload, and causes corruption issues as there is no transaction-based record management.

Switching to a database would help this. It'd require exposing an API end-point and putting a RDBMS (like MariaDB) behind it:

The API call could wrap the command in a transaction to ensure no data gets lost, and the database will be more effective at saving disk space as it does not save the schema with each save. The DB could be optimized further since it's a write-heavy service:
2y ago
I am new to EZ Database. I created a table and am trying to import a csv file I created in Excel. Every time I try to import EZ Database closes. What am I doing wrong?
1y ago
So there are not any other colonies on the My Colony server right now with that same charter code (HWPx9Xrt). I am guessing that charter was used by a prior colony which was deleted for inactivity, but is still listed in the coloniae database. Depending on how you guys want to handle it @Sobeirannovaocc and @dfv123 , I can just delete the record for DGUE in the My Colony database and it should get another charter code at next sign-in, or Sobe can remove the original colony from his database, as it does not appear to be on the MC server anymore, although possibly we want to retain the Coloniae data for historical purposes? I assume either way should correct it, just let me know what you guys think is best.
1mo ago
That charter is not in the database. Did you take your colony offline at some point and then go back online? If you do, it changes your charter.

I didn't see a "mega-world-asteroid-prime" in the database either. Is that how your colony name appears in the game? And are you sure you are playing in online mode?
4y ago
Do you have a new charter code for the colony? When you go offline and then back on it should get a new charter. The current charter ( NamKALo7 ) is no longer in the database. I was going to search for New Earth but there are several hundred colonies in the database called New Earth, so idk which is which.

There is also a New Earth II on your account with charter: Hq4dcHUB but I am guessing that is a different colony.
3y ago
Hi, just posted that my colony stopped loading - it's named Lunacy, chater code is: m5mWj4AH. Tried upgrading to premium membership but it still is not loading.. says Restore Data... and just sits on that message

I'm hoping someone know what to do or can run a database repair ont it or something.. I'df really like not to lose that colony I spent hours on it..

thanks in advance for any support
3y ago
Also, just add more info, being new to the game i didnt realize you can save colony files, so I have no real workable restore file, when I try the restore file i made, the screen just freezes on Restoring database.. hopefully theres a cure. Any suggestions would be appreciated
3y ago
@Jroth1234 and @TobyHosterman I will be working on the next EZ Database update within the next week or so, I will see what I can come up with for these requests!
3y ago
I have updated EZ Database to v1.4.0. This version adds "many-to-one support" for relationship fields, and the ability to import a .csv into a new table.

It will take a bit more work @Jroth1234 to implement the query feature you requested, but I will come up with something.
3y ago
Please tell me how to save the data in EZ Database
3y ago
Downloaded EX Database to iPhone iOS 12.1. EZ kept loading and never stopped for over 20 minutes SO I’ve deleted this program and expanded to other databases especially if it doesn’t work the first time
3y ago
3. I am not sure how you are getting such a low production number (i.e. 20-40 regolith / min from a Regolith Extraction Inc.). Are you sure it isn't maybe staffed on-duty by 1-2 person only at the time of observation?

In any case, I monitored all my production buildings from time to time and compared them with the values in the Reference Table, and so far my various production buildings are always higher by the same constant (about 30-40%) when compared to the values in the Table which assumes 20 ticks/second. This is as expected, meaning that my ticks/second on the computer I play on is also faster by the same ratio. In any case, sorry I am not sure what is causing the resource yield in your game to be much lower than theoretical 20 ticks/second if fully staffed.

Discussing specific buildings you mentioned :

- Vertical Warehouse Farm is not bugged. Mine shows 8000 Food/min when staffed by 24 people on-duty out of total 35 slots, so that is as expected (again, my computer tick is higher than the assumed 20 ticks/second used in the table).

- Ore Zapper vs Regolith Extraction Inc gives the correct number. Remember Ore Zapper is only 1x1 in size and doesn't require workers, wile REI takes 9x the space while only having a bit higher yield, so Ore Zapper has much higher yield/tile. In endgame when all resources are produced in humongous quantity per second, yield/tile is the most important parameter for a production building as space is of paramount commodity. So what is the use for REI? It provides a midgame way to automate regolith production for colonies in asteroid/abandoned/lunar base instead of having to build Regolith mines over and over manually. In those worlds, you can't get Ore directly unlike in Red planets. You have to convert it from Regolith instead.

- As I mentioned before, there are at least 3 mid- and end-game buildings which has discrepancy between Reference data and in-game actual production, them being : Alien Plastic which you noticed as well, Tech Office, and Obsidian Furnace. The actual in-game production of these 3 buildings are multiplied by the worker quantity just like any other buildings requiring workers. This makes Alien Plastic being much better than Advanced Plastic Factory as it should be, Tech Office being second best money production building after endgame Star Port, and Obsidian Furnace being higher than listed. This has been discussed by the awesome owner of the Coloniae Reference (and Coloniae itself) Sobe and the developer Bast, and so far there is no clear solution why the database the Table pulls from is different from the actual in-game stat. In the grand scheme of things, this is very minor and there are much much more pressing bugs and issues to fix by the developer though. Unfortunately I have barely any knowledge about database and coding to try to analyze the issue, and Sobe has done a lot to make a new Reference which can automatically updates itself, after the old Reference had been abandoned by the previous contributor.

4. Just a tip, I personally don't think Arcology is a useful building to have, as 7000 of the colonists are tied in useless job slot which doesn't yield anything much. Fantasy Land Arcology is a different story though. If you have an abundance of resources to be used for testing and such, please feel free to proceed however, but not if you are still strapped on midgame resources.

5. In short yes, a colonist will have fixed workplace and residential place once it arrives and gets assigned a job. In reality, there are more complex dynamics involved which I don't fully understand especially when residential buildings are sold or destroyed, or the current workplace is sold or destroyed.

We are all thankful for Relic Studies, especially it is chilling to know that for the first year and more of the game, there was no Relic Studies and every endgame player was stuck on spamming UDDs and Alum generators till the end of the map.

About your balance concerns :
- Yes, Food Processing Sweatshop pretty much produces that much and will blow all other Food production buildings out of the water, because planets other than Sugar World have ways to produce Sugar as well.
- Maybe you have not seen the Research Converter, but it pretty much is the endgame production building you need to spam for 20 or so different resources.
- As for the Alien Enrichment Facility, it was a pretty decent upgrade when considering what players had for Alien Artifacts and Aluminum back then before the introduction of Relic Studies. It made Uranium much easier to get than the other 2. We wish all Alien Tech is such a big upgrade like it is for Steel, Gold, and Microchip, but alas it is not so. Now with powercreep, you have Research Converter which blows Alien Enrichment out of the water for Uranium and many other resources.

2y ago
How do I get decimal points to appear in a “Real” designated column. auto clicker word unscrambler jumble solver

So I purchased it but can’t find my database
2y ago
Ctl said:Downloaded EX Database to iPhone iOS 12.1. EZ kept loading and usps tracking never stopped for over 20 minutes SO I’ve deleted this program and expanded to other databases especially if it doesn’t work the first time

Same here.

2y ago
Unfortunately, due to consuming an amount of 'valuable rum', a certain detail in this discussion is unclear.

Would adopting a database necessitate using the cloud?

I very much appreciate being able to play offline and by that, I mean, completely and totally without internet. I have a partial IT background so I understand how useful the structure you propose can be. However, how compact could such an implementation be and could a modern RDBMS be used on a tablet?

I understand that my needs might be very different to most other people's needs, but on a recent holiday the internet was patchy at best (I'm in Australia) and playing offline was a lifesaver.
2y ago
Hello commanders.

Today I would like to introduce my ideas for expanding the base, and some ideas for buildings!

For faction identifications, I’ll use colour of the text as follows:
United Earth,
League of Independent States,
Alpha Draconians,
Zolarg Empire.

Let’s begin with base expansion.
Currently the way expanding the base in v0.4.0 relies on building buildings in a dense pack (exclude the larger construction area provided by lander and naval yard).
So if we want to expand the base in a better way, we probably need something else.

Here are my ideas.
  • United Earth can still increase construction ranges by buildings, but I would like to have the range provided by buildings are larger.
  • League of Independent States requires Pioneer Rover deploy into a Pioneer Outpost to expand into other areas.
  • Alpha Draconians requires Command Node built within available areas, increasing the construction areas around the base.
  • Zolarg Empire has no restrictions of construction area. Buildings are deployed freely by various Worker Drones. For example, Aerohive Drone is deployed into a Aerohive (the Zolarg facility that produces airforce).

Next up, the buildings.
  • War Research Bureau (Tech II)
    The War Research Bureau brings blueprints and accesses to the high class weapons of UE armory.

    This UE tech building can unlock T3 contents. Model based on the Advanced Medical Research Centre.
  • Rocket Bunker (T2)
    The Rocket Bunker is equipped with rocket launchers. It’s capable responding threats from both land and air.

    It’s good against air units and decent against vehicles. However it can only target one unit at a time.
  • Land Fort (T3)
    Land Forts are heavy defense structure of United Earth. Equipped with 4 long range proton cannons it can bombard enemies in a long range.

    A very strong yet expensive land defense structure.
  • Drone Centre (T2)
    Drone Centre is a facility for building battle drones for air warfare and also the place for at most 4 drones to stand by.

    Air battle facility of UE.
  • Disruption Array (Superweapon)
    The Disruption Array is able to create a strange quantum phenomenon which will release a massive amount of energy, called the Disruption Burst.

    The primary superweapon of UE.
  • Warp Node (Superweapon)
    One of the secret dimensional weapon develoepd by United Earth, capable to teleport a small group of troops from a place to another without the need of portals.

    The support superweapon of UE.
  • Torpedo Platform (T2)
    The torpedo platform is a naval defense structure specialised for responding naval threats.

    The good news is, it can attack submerged units! Meanwhile the bad news is it’s neither anti-land nor anti-air.
  • Sensor Array (T3)
    The frequent stealth attacks launched by LIS makes anti-stealth devices a neccessity on frontlines combating LIS. Besides giving extra sight, it also detects hidden units.

    Special support structure of UE.
  • LIS Lander (Lander)
    “Time to give this piece of land a new meaning!” - LIS Lander deploying

    Resembles the UE Lander.
  • Infantry Camp (T1)
    The Infantry Camp manages both the militias and the mercenaries of LIS forces.

    Infantry training facility of LIS. Will looks like a pack of tents. Upgrading it will unlock T2 infantries.
  • Burner Generator (T1)
    The burner generator powers LIS bases by burning diesel.

    Basic power supply facility of LIS.
  • Watchtower (T1)
    These watchtowers are manned by LIS gunners. Although it’s not a very sturdy defense at all, but it has a good firing range and sight.

    Basic anti-infantry defense.
  • Garage (T1)
    The Garage produces LIS combat vehicles.

    Vehicle factory of LIS. Upgrading it will unlock T2 vehicles.
  • Hangar (T1)
    The Hanger produces LIS aircrafts needed for supporting attacks.

    Aircraft factory of LIS. Upgrading it will unlock T2 aircrafts.
  • Airfield (T1)
    An airfield can hold one LIS fighter or bomber plane.

    This is required in order to produce aircrafts other than Jetcopters if playing as LIS.
  • Drydocks (T1)
    The drydocks is needed for constructing LIS naval warfare vessels.

    Ship factory of LIS. Upgrading it unlocks T2 naval vessels.
  • Proxy Database (Tech II)
    The Proxy Database carries all protected military information of LIS. This facility is needed for producing T3 units.

    The only tech centre of LIS. Requires at least one upgraded Garage in order to build one. Unlocks T3 units like the Hacker and Solar Artillery.
  • Flak Turret (T1)
    Flak Turrets are used by LIS to combat against airforces.

    Anti-air turret of LIS.
  • Beam Tower (T3)
    The Beam Tower utilizes strong beams to destroy enemy forces effectively.

    Advanced defense of LIS.
  • Uplink Station (Superweapon)
    The uplink station calls the devasting Solar Cannon Bombardments, which a rain a rain of solar beams from the space.

    Primary superweapon of LIS.
  • Beam Projector (Superweapon)
    The Beam Projector creates a Beam Cage which will isolate the units inside the Cage from everything.

    Support superweapon of LIS.
  • Floating Bunker (T2)
    The Floating Bunker is equipped with pounder guns and anti-air flak cannon, an all-round naval defense.

    Can target an naval or land unit and an aircraft at the same time.
  • Pioneer Outpost
    This Outpost allows LIS forces to expand into further areas.

    Deployed by Pioneer Rovers. Adds a construction range around it.
  • Engineer Bay
    The engineer bay supports extra constructions of LIS bases and also provides repairs to damaged troops.

    Special support building of LIS.
  • Mother Command Module (Lander)
    MCM in short. This is the centre of a Alpha Draconian base.

    Resembles the Landers, deployed by construction probes. Upgrading this allows access to higher tier unit productions for factories within the range and new buildings.
  • Microreactor (T1)
    A tiny reactor that is powerful enough to power up common Alpha Draconian facilities.

    Basic power generator of Alpha Draconians.
  • Antanium Impactor (T1)
    Even on battlefields, this thing is still an imoortant economy building of Alpha Draconains.

    Act as a refinery.
  • Drone Pad (T1)
    Alpha Draconians warps drones to the battlefield like how they teleport drones to their colonies for resource collection.

    Infantry (drone) training centre.
  • Mecha Lab (T1)
    The place where Alpha Draconian mechas are produced for combats.

    Vehicle factory for Alpha Draconians. Also produces Draconian Orbiters (aircraft).
  • Sentry Module (T1)
    The Sentry Module deploys and resupplies guard drones which can take down enemy infantries.

    Anti-infantry and anti-air structure of Alpha Draconians. One Sentry dispatches 4 guard drones that fires rapid-fire blasters.
  • Ether Reactor (T2)
    The Ether Reactor is powered by Ether, which provides a even massie amount of energy needed by power-intensive units and buildings.

    Advanced power supply building. Strong explosion upon destruction.
  • Tesla Node (T2)
    A very power intensive defensive weapon which is lethal to almost everything.

    Advanced defense of Alpha Draconians.
  • Command Node (T1)
    The Command Node is required to expand a Draconian base.

    Provides extra construction range. Like Mother Command Module, buildings covered by the Command Node requires the Node’s upgrade to produce better units.
  • Draconian War Insitute (Tech II)
    The Draconian War Insitute provide access for Draconain commanders to the better ways of combats.

    Tech building of Alpha Draconians.
  • Electrosphere (Superweapon)
    The Electrosphere can fire a electron ball to release deadly discharges, while can also paralyse those survived and buildings.

    Primary superweapon of Alpha Draconians.
  • Nanocube (Superweapon)
    The Nanocube contains nanites which allows to put a tempoary invincible armour onto any steel (actually also works with concretes) claded objects. Anything biological will be killed as the armour coating is biologically harmful.

    Support superweapon of Alpha Draconians.
  • Shield Projector (T2)
    The shield projector provides a extra layer of defense to any Alpha Draconian base. If the shield is destroyed it’ll regenerate over time.

    Special support building of Alpha Draconians.
  • Command Post (Lander)
    The Command Post is the core in a Zolarg warfare.

    Deployed by the Queen drone, it’s same concept as the lander. However it won’t do constructions, instead it’ll create various kind of worker drones which deploys into buildings.
  • Sugar Burner
    Very ordinary power generator in any Zolarg colony and military base.

    Basic power generator of Zolarg.
  • Antanium Furnance
    Basically an ore refinery.

    Yes, an ore refinery. What else I can tell?
  • Barrack Mound (T1)
    There’s not much difference between a Barrack Mound and any ordinary mound in Zolarg Empire, except that there’s no Queen but officiers in Barrack Mounds.

    Infantry training facility of Zolarg Empire.
  • Watchtower (T1)
    Where soldier insectoids stays on duty to keep enemies away. One of them is a Rifle-bug and another being Grenadier.

    Land defense structure of Zolarg Empire.
  • Flak Bunker (T1)
    Flak bunker fires explosives mixed with ant pastes into the sky. Those aircrafts hit by these explosives not just have their hull damaged but also move slower.
  • Armourcrafts (T1)
    The craftsbugs in Armourcrafts builds crude combat vehicles for Insectoid soldiers.

    Vehicle factory of Zolarg Empire.
  • Aerohive (T1)
    The air swarms are breeded and trained here, which they are used for bombarding enemies.

    Aerohive is the airbase of Zolarg Empire, producing flying units.
  • Brood Training Centre (Tech I)
    In order to get the insectoid broods ready for field service earlier and the need for better tachics and weapons, the Brood Training Centre is needed.

    T2 Tech centre of Zolarg.
  • War College (Tech II)
    The War College provides full support to any Zolarg Commander who needs stronger powers.

    T3 Tech centre of Zolarg.
  • Boat Yard (T1)
    If you think Insectoids are afraid of the seas, then you’re wrong. They are ready to conquer the seas.

    Ship factory of Zolarg Empire.
  • Altar of Doom (Superweapon)
    The Altar of Doom is powered by the Zolarg Empire’s forbidden power - Antaura. Everyone who see it would feel like it’ll summon something that will cause a doomsday.

    Primary superweapon of Zolarg Empire.
  • The Tower of Mind (Superweapon)
    Anything that has a mind will never able to escape control from this Tower of Mind.

    Support superweapon of Zolarg Empire.
  • Shrine of Destiny (T2)
    The faith will keep your brothers going.

    Special support building of Zolarg Empire. It can boost up the training speed of units.

Hopefully you’ll like my ideas!
My Colony v1.10.0 has started going out recently and is hitting various platforms at different times and in different iterations. This is a bit of a different update, as there is nothing new to My Colony itself.

Over the last few weeks, I have been busy doing a total rewrite of Web App Core, the cross-platform app wrapper that hosts most of my apps and games, including My Colony. This rewrite cleans out years of outdated/unused code, is more efficient, and should bring more consistency between all of the various platforms. The problem though, is that this project is massive and is taking me longer than I anticipated.

Since the rewrite is quite massive and touches every single function available to Web App Core, I went ahead and published it on my two biggest cross-platform applications, My Colony and PDF Document Scanner, so I could collect crash reports and see what is and isn't working. I know that this isn't something a "professional" company would necessarily do, but I did (mostly) test everything beforehand 🤐

Anyway, you may see several iterations and releases of the 1.10.x branch on each platform over the coming weeks as I work everything out, so you can report all issues you find in this thread.

While I am talking about Web App Core, I might as well give an overview of what I am changing on that product, since it is a large part of My Colony as well. My Colony is currently running on v3.7.6, and after I have all of the bugs worked out on all platforms, Web App Core will be bumping up to v4.0.0 and getting a ton of cool new features that will help My Colony and other products as well.

If you are not aware, Web App Core is basically an abstraction wrapper I wrote starting in 2013 or so that allows my apps and games to use device-specific native functions while sharing the same code base. It's basically what allows me to release updates to all platforms in a fairly short amount of time. It's not a third party library or anything, so I have total control over it's features and capabilities.

One of the new features coming to Web App Core v4 is the ability to fully customize the theme/look of the wrapper. For example, on all of my current apps, the default left-hand slide-out menu looks the same for every app on a specific platform. So all of my Android apps have the exact same looking slide-out menu, same looking title screen, same looking dialog popups, etc. They are all very generic and the same across the board. A productivity app like PDF Document Scanner uses the exact same looking menus and dialogs as a game like My Colony. With Web App Core v4, My Colony (and other games) will be able to have their own customized UI and look more "game" like.

Web App Core v4 will also bring full local filesystem access to My Colony on the Web. This means that on the My Colony web app, you will be able to choose a local folder on your PC or Android device that you want My Colony to use, and all game data will be saved there, instead of on the cloud or in the browser's internal database. Since saves will no longer be limited to using the database, game compression should be unnecessary, and this change should virtually eliminate file save corruption on the web edition of the game. This will also make backing up your data trivial, as you can just copy/paste your save files any time you want.

Web App Core v4 will also start making way for upcoming web technologies that are not yet available in stable channel browsers, but will be coming in the months ahead. For example, installed Progressive Web Apps (PWA's) will soon be gaining the ability to become the default application for certain file types. For example, if you had the My Colony PWA installed on your device, you will eventually be able to simply double click on a game file on your desktop, and it would automatically launch the game (and your colony). Same thing with apps like Voxel Paint, simply double clicking on a .vpp file would launch the app and the voxel model.

Anyway, there are a lot more capabilities coming soon that have nothing to do with My Colony, so I wont bother polluting these release notes any further. If you've been following my work for any length of time, you may know that I really dislike the various App Stores, their draconian content rules and restrictions, their 30%+ cuts on all transactions, etc. My ultimate goal is to have the web editions of all of my products just as capable (or more) than their native counterparts. I am a big fan of Progressive Web Apps, and as time goes on I believe they are going to become more and more indistinguishable from native applications. I am going to continue to be on the bleeding edge of the PWA side of things!
1y ago
Is there a tutorial for EZ Database. Help! Apologies. Just realised I need to go on specific forum.
4mo ago
The server just generates a random charter code when a user first registers a colony, and then checks the My Colony database to see if it's in use, and if so, generates another until it has a unique one. I used to not check the My Colony database but there were several occasions where it assigned the same charter twice :-/

I should probably come up with a better way at some point.
1mo ago
Doubtful. The issue was not related to inserting data into the database, but with javascript parsing the result into a JSON object.
4y ago
Also change job doesn't work.

Despite having a robot factory and both tech the reference site says I need, I can't build "Construction Drone".

The fact the game doesn't warn I need to make construction drones to make buildings (since I'd have to manually look up tech I already have to look what can construct buildings I could make if I had a construction drone) is compounded by the fact making construction drones isn't fully documented by the reference material.

3 days stuck. Chat didn't help. This is a decent case of lack of documentation making players stuck.

OF COURSE you could tell me the anwser, but why is it not inside the game itself in an OBVIOUS place? It would have saved me several hours of reference database diving to know why I am not progressing, and which buildings I can't make for unclear reasons.

If you expect players to manually write down buildings each tech unlocks just in case it's an "unlock but not really" and the building isn't available in construction menus, just to make sure they don't miss anything, you REALLY are the enemy of game documentation.

PLZ document the game better. It would certainly double the time people spend playing average, and thus double premium sales.
3y ago
@Invincible I found out why your website was not updating. Your "Commonwealth Message" that shows to new players is longer than 100 characters.

I don't know why the game was letting you pick a message longer than 100, but that is the database max length, and your long message was stopping the query.
3y ago
Starting with v0.75.0, a massive realignment of colonial GDP will be taking place, and some of you with massive GDP figures numbering in the quadrillions or more may not like it (or may not care), but on the whole, it will be a lot better.

Before v0.75.0, GDP has been just a lazy calculation, adding up the market value of all resources in a colony, along with all of the money that colonists had in their wallets. This was an easy way to set it up at the beginning, and it sort of worked, and not too many people cares, so I left it as is.

The problem, is that anybody who knows about economics will know that this calculation has nothing to do with GDP, making the number totally meaningless as a measure of economic output. The result was that a colony could have a massive GDP just by getting gifts, making an epic trade, or simply existing for a long time and building up massive resource stockpiles. Again, all of this is fine, but it really gives no valuable information about the health of your colony's economy.

With this update, I decided to just totally scrap the old GDP figures, and implement a real GDP calculation, in the economic sense. Going forward, GDP is now a rolling calculation of the gross industrial output of your colony over the span of one "year." This makes it a far more accurate and meaningful measure of the industrial strength of your colony.

So, in order to be able to make the calculation, I first had to definitively determine what one "year" is in My Colony. After reviewing some of the existing game mechanics, I came out with one year being 120,000 "tick" cycles in the game, or roughly one hour of play time. So going forward, the GDP of your colony will be the sum of all industrial output over the last hour of play time.

The part that will sting at first, is that since it is a rolling calculation, that means the GDP figure will be incomplete in your colony until you have played for an hour. I could probably just check the current output and extrapolate it out to fill in the gaps, and I might at some point, but since the issue is irrelevant after an hour of play, I haven't bothered to do it yet.

Now the other part that might sting, it that this represent a complete and total realignment of the various GDP's across the galaxy, especially among older more established colonies that are hoarding epic amounts of resources. Just now that the intention is not to punish those colonies in any way, but to create a more accurate measure of the industrial output of the colony. And really the fact that you just have millions and millions of resources stockpiled, doesn't really say much about the health of your colony's economy.

Because of the change, most people (probably everyone) will be seeing a massive reduction in their GDP. I mean massive. On the flip side, it is happening to everybody across the board, and you will now now for sure what the economic strength is of your colony.

Honestly, the old way of computing it was dumb. A brand new colony with 2 people could get an epic gift from their commonwealth and suddenly have a GDP rivaling colonies that have build up millions of population over the years.

And speaking of gifts, they are not computed in the new GDP calculation. It is solely based on the industrial output of the colony. Although taxes you collect from your charter colonies DO factor in.

Anyway, this actually gives way to new game mechanics that will be able to take advantage of a new GDP calculation. The GDP now gives you a real measure of the strength of your economy, and you will be able to monitor and respond to the boom/bust cycles of the colony. It's not in there as of this writing, but I will be soon adding the GDP Growth % statistic so you can monitor if your colony is growing or in a recession. A growing economy will boost your approval, while a recession will harm it. If your colony enters a great depression, you will get protesting.

Finally the GDP growth rate stat will also be added to the online database, so there will be a ranking coming soon of which economies are growing the fastest. Sort of like in real life!

Anyway, that is the change that is coming. I hope not too many people are upset about their massive GDP numbers being cut down to size, but I think in order to move things forward, it had to happen eventually.
3y ago
Ape Apps, LLC is an independent software development company founded in 2010 by Brandon Stecklein. Over the years, Ape Apps has published over 400 apps and games across various platforms. You can get in touch with Brandon on Twitter or by leaving a post on his wall @bastecklein
App of the Day