Jump to content

Invision Community Blog


Managing successful online communities

bfarber
Sign in to follow this  
 

IP.Content 2.0 Dev Update: Improvements to Databases

Database "Tweaks"
The database functionality in IP.Content is quite powerful at its core. You can do a lot of things with the database feature that would normally be laborious coding yourself. A lot of addon applications add common features: rating, comments, sorting options, etc. IP.Content takes all of this legwork out of the picture by providing it for you with just a few clicks in your admin control panel. But there's always room to improve! We have focused on some small but useful tweaks and improvements to the core database features that we think will benefit everyone.



Specify The Text

IP.Content databases refer to stored entries as "records". This is a generic term that can be used for just about any database, which is why we chose to use this originally. It is understandable, however, that some of you want to personalize the interface a bit more. "Records" isn't exactly the clearest term in all cases to all users, so it makes sense that you might want to refer to the entries as "articles," "pets," or "recipes", for instance.

With IP.Content 2.0 you will be able to define the text bit to use to represent "records" in a database right from the database configuration form in the ACP. Four fields will be presented to allow you to define the singular and plural versions of the words in both lower-cased, and first-letter-capitalized versions. I know this probably reads a little confusing, but basically it allows you to define "record", "records", "Record" and "Records" independently. While PHP has many useful functions that can handle this just fine for the English language, in an effort to better-support our international customers we felt it prudent to allow you to define all of these versions of the word yourself.



Specify The Content

In IP.Content 1.x we provided an option on the database configuration page to allow you to indicate which field represents the "title" of a record. Because databases are so configurable, we needed to give you a way to specify this field so it can be re-used properly throughout IP.Content. In IP.Content 2.0, you will now also specify which field represents the "body" or "content" of a record. Some databases may have no use for this, but if you are setting up a database of articles, you will surely want to specify which field represents the "content". This designation is then used to determine which field to show as the "body" in a database feed, and in our next new feature we'll talk about...



RSS Feeds

Yes, you can now allow automatically generated RSS feeds in your IP.Content databases. Even better, RSS feeds are supported at both the database and the category level, automatically. You can also disable RSS feeds individually on a per-category level, should you wish to. This is useful if you have a private staff-only category of articles, for instance, which you do not want to publish via RSS with the rest of the articles in the database.




Settings have been added to both the database and the category configuration forms to enable/disable RSS feeds, specify how long (if at all) you wish to cache the feeds, and to specify how many records to include in the feed. The category configuration form also has a setting to exclude it from the global RSS feed, as mentioned previously. Feeds are cached, if configured to do so, for performance reasons.



Duplicated Sort Form

In the ACP record management screen, we have duplicated the sort/filter form to the top of the page. If you have a lot of record management duties to perform in the ACP, this can help you to more quickly drill down to find the records you need to work on by eliminating the need to scroll to the bottom of the screen each time you wish to change the returned records.

We have also added a "Save and Reload" button to the record add/edit form. You can stop with the PMs now Ditchmonkey! :lol:



Save and Reload

We've added a button to the add/edit record form in the ACP that will allow you to "Save and Reload" the record. If you are making may small changes to a record (for instance, you want to refresh the record on the front end to verify how it's displaying), this is useful as it will save your changes, and then immediately reload the form so you can continue editing the record, instead of forcing you to save, find the record, and click edit on it again to bring the form back up.



Meta Tags

Configuration fields have been added to the database and category forms in the ACP to allow you to define your meta keyword and description tags for your databases and categories. For records, meta tags by default will be automatically determined, just the same as happens in topics in the forum. You can, however, also manually override the meta tags on a per-record basis from the ACP by editing the record, should you need to.



Display Subcategories

Similar to how the board index will list subcategories underneath their parent forums, IP.Content 2.0 will now (by default) display subcategories of a category underneath the category title when viewing categories.





And more to come!

These are just a few of the changes we've made to the databases system in IP.Content 2.0 that we believe will make your databases more useful, more configurable, and more "your own". The changes better integrate IP.Content with the forums, providing a more seamless feel to the site, while at the same time enhancing IP.Content-specific functionality to let you better control your content.

Be sure to stay tuned for our future updates on IP.Content 2.0! We have a lot of other useful changes in store you'll surely want to take advantage of.

Sign in to follow this  

Comments

Recommended Comments

Any news about the full FURL support for databases?

Ex:
- /resources/official.html?category=36 => /resources/official/getting-started/index.html
- /resources/official.html?record=278 => /resources/official/getting-started/general-ips-information/test-boards.html

Share this comment


Link to comment
Share on other sites

One question:


If I change "records" to "pets" will articles redirected through Redirect 301 automatically?

"Records" isn't exactly the clearest term in all cases to all users, so it makes sense that you might want to refer to the entries as "articles," "pets," or "recipes", for instance.

Share this comment


Link to comment
Share on other sites

[quote name='Fabien' date='04 February 2010 - 08:17 PM']Any news about the full FURL support for databases?

Ex:
- /resources/official.html?category=36 => /resources/official/getting-started/index.html
- /resources/official.html?record=278 => /resources/official/getting-started/general-ips-information/test-boards.html

I'd put the id there so there if the title changes the link still is correct:

- /resources/official.html?category=36 => /resources/official/36-getting-started/index.html
- /resources/official.html?record=278 => /resources/official/36-getting-started/278-general-ips-information/test-boards.htm

Share this comment


Link to comment
Share on other sites

[quote name='Luke' date='04 February 2010 - 11:50 PM']
Here's something I'd like to see: Stop putting the id before the title in FURL. It makes no sense. It's least important of the whole url content-wise.

Then what happens when there are two titles which are the same?

Share this comment


Link to comment
Share on other sites

[quote name='Swiftie' date='05 February 2010 - 12:41 AM']
Then what happens when there are two titles which are the same?

ID comes after title, instead of before. You retain a unique URL, and the more important info comes first.

Share this comment


Link to comment
Share on other sites

Regarding FURL, we have more information to share about FURL, which will be issued in a future blog entry. There is some discussion of FURL for databases in the next update in the IP.Content peer support forum as well, if you're wanting to read up now before the next blog entry.

Share this comment


Link to comment
Share on other sites

LOL @ DReffects2

This is great Brandon, IP.Content is turning out to be one kick ass product and the limits to what can be done with it are only measured by your imagination.

What would be a great addition is for when we make a database and templates for it to be able to download the 'Skin' and DB in a packaged file to be able to post them on the forums for others to install.

That for me would be the icing on the cake and I am sure would stimulate the community into producing addons etc for IP.C.

For instance people could develop portal databases complete with skins and blocks etc that act as a template for people to mod.

This would take some of the strain from yourself and develop the product as a community.

Anyhow less of my ranting but so far so good, I love it.

P.S. Any news on the attachments in feeds thing ?

Share this comment


Link to comment
Share on other sites

[quote name='Shack Networks' date='05 February 2010 - 04:34 PM'] LOL @ DReffects2

This is great Brandon, IP.Content is turning out to be one kick ass product and the limits to what can be done with it are only measured by your imagination.

What would be a great addition is for when we make a database and templates for it to be able to download the 'Skin' and DB in a packaged file to be able to post them on the forums for others to install.

That for me would be the icing on the cake and I am sure would stimulate the community into producing addons etc for IP.C.

For instance people could develop portal databases complete with skins and blocks etc that act as a template for people to mod.

This would take some of the strain from yourself and develop the product as a community.

Anyhow less of my ranting but so far so good, I love it.

This is actually on an internal wish list, though I'm going to hazard a guess it won't make it into 2.0. Maybe 2.1 though.

What we've revealed in the blog entries so far is only a small part of IP.Content 2, and we've got our hands quite full already with 2.0. ;)

[quote name='Shack Networks' date='05 February 2010 - 04:34 PM'] P.S. Any news on the attachments in feeds thing ?

Not sure what you're referring to specifically.

Share this comment


Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Add a comment...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...