# Database design advice needed

**URL:** <https://forum.adalo.com/t/database-design-advice-needed/2483>\
**Category:** Get Help\
**Created:** [July 12, 2020, 5:45am UTC](https://forum.adalo.com/t/database-design-advice-needed/2483 "2020-07-12T05:45:38Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![herbshirt](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/herbshirt/32/1247_2.png) [@herbshirt](https://forum.adalo.com/u/herbshirt)\
**Post date:** [July 12, 2020, 5:45am UTC](https://forum.adalo.com/t/database-design-advice-needed/2483/1 "2020-07-12T05:45:38Z")

</div>

This may sound like a very noob question but I can’t seem to find the answer so, here it is…

My app is a bit like a social networking app but the user (admin) is able to set up up their own closed Network of Users. Users are then invited to the Network.

As I’ve begun designing the app I’ve been thinking of it as the Network but I should be thinking of it to accommodate everyone single user that will be potentially using it right?

In which case can I/should I be creating a Unique ID for each Network somehow?

Also, should I be thinking about a web app as well to manage the entire database?

With thanks.

---

<div class="post-metadata">

**Author:** ![Shinnawy](https://avatars.discourse-cdn.com/v4/letter/s/edb3f5/32.png) [@Shinnawy](https://forum.adalo.com/u/Shinnawy)\
**Post date:** [July 12, 2020, 11:20am UTC](https://forum.adalo.com/t/database-design-advice-needed/2483/2 "2020-07-12T11:20:39Z")

</div>

If the user gets to decide the “network” name, then you can just create a new database, then filter by logged in user - network.

If not, then create a unique ID so you can filter it later if need be.

Only think about a web app if you think you’ll have a larger number of users, otherwise you can just have the photos hosted elsewhere so you don’t use up all your 5GB on Adalo database.

---

<div class="post-metadata">

**Author:** ![herbshirt](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/herbshirt/32/1247_2.png) [@herbshirt](https://forum.adalo.com/u/herbshirt)\
**Post date:** [July 12, 2020, 7:43pm UTC](https://forum.adalo.com/t/database-design-advice-needed/2483/3 "2020-07-12T19:43:24Z")

</div>

Thanks @Shinnawy.

I’d like to future-proof the app in case someday it _does_ have a large number of users. 😉  
Does Adalo have the ability to generate a unique ID?

Where do people typical store images externally these days? Is Amazon still the most viable option?

---

<div class="post-metadata">

**Author:** ![karimoo](https://avatars.discourse-cdn.com/v4/letter/k/ad7895/32.png) [@karimoo](https://forum.adalo.com/u/karimoo)\
**Post date:** [July 13, 2020, 4:26am UTC](https://forum.adalo.com/t/database-design-advice-needed/2483/4 "2020-07-13T04:26:09Z")

</div>

@herbshirt For external image storage have a look at [Cloudinary](https://cloudinary.com/). See: [Best way to avoid UI ICON Downloads on slow conections - #2 by karimoo](https://forum.adalo.com/t/best-way-to-avoid-ui-icon-downloads-on-slow-conections/2442/2)  
They also have a quite good free quota.  
Or [https://www.imgix.com/](https://www.imgix.com/) that is used by Adalo itself. See: [A very cool image tip!](https://forum.adalo.com/t/a-very-cool-image-tip/1569)

Auto numbering is as planned on the roadmap: [Additional Database Property Types | Voters | Adalo](https://ideas.adalo.com/feature-requests/p/additional-database-property-types)

---

<div class="post-metadata">

**Author:** ![herbshirt](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/herbshirt/32/1247_2.png) [@herbshirt](https://forum.adalo.com/u/herbshirt)\
**Post date:** [July 13, 2020, 6:07am UTC](https://forum.adalo.com/t/database-design-advice-needed/2483/5 "2020-07-13T06:07:39Z")

</div>

Very helpful. Thanks @karimoo.

So glad to hear about auto-numbering!

---

<div class="post-metadata">

**Author:** ![projectlinuxsupports](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/projectlinuxsupports/32/1023_2.png) [@projectlinuxsupports](https://forum.adalo.com/u/projectlinuxsupports)\
**Post date:** [July 13, 2020, 7:02am UTC](https://forum.adalo.com/t/database-design-advice-needed/2483/6 "2020-07-13T07:02:09Z")

</div>

Or you could just create a field called ID. Then every time you create a record for that Network, you can just specify magic text to Network \> Count.

It will count from 0,1,2,3,4 automatically.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/system/32/40401_2.png) [@system](https://forum.adalo.com/u/system)\
**Post date:** [July 23, 2020, 2:13pm UTC](https://forum.adalo.com/t/database-design-advice-needed/2483/8 "2020-07-23T14:13:55Z")

</div>

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.
