How to manage/edit sqlite database--some useful tools

Tuesday, October 08, 2013, 21:11

RiteCMS is based on Sqlite database, a lightweight, fast database engine. There are many free/paid softwares that you can use if you ever want to manage your database.

We mainly use mac and we use Navicat Premium Essentials, a very fast, stable software.On our only windows machine (for testing purposes), we use SqliteAdmin, a free and very fast piece of software.

The above are not necessarily the best softwares other there. It is our personal preference. We also have used the following and still use them from time to time.

  • Firefox Sqlite Plugin - cross-platform: SqliteManager
  • Many tech junkies recommend Sqlite Expert, we have not tried it but it is worthwhile to check it out. The personal version is free.
  • If you want, [http://www.sqlite.org/download.html|Sqlite]] official website offers a free command line tool, it is a tool that we also use as well.

Do you have any other Sqlite tools that you would recommend to fellow RiteCMS users? Share it below.

How to set pulldown menus

Sunday, October 06, 2013, 21:23

pulldown menu support is now built-in.

In menus, create a new menu and named it "submenu 1".

In main menu, look for the column 'submenu' and put the name of the newly create "submenu 1" to a row that you want.

That is it.

To see it in action, move your mouse to "support" in the above menu.

How to set nested menus

Friday, April 15, 2011, 09:46

Here is a quick tip on how to set up nested or pull-down menus.
You first need to define a new set of submenu in your settings and name the submenu name the same as one section name of the main menu.
Secondly, call menu_2 in appropriate pages.
Thirdly, add the submenu to the main menu by changing the following in your templae file.

How to create a seperate news template

Monday, March 21, 2011, 18:38

If you have several news page,you can use a different (sub)template for each page. For example, you have a blog page and a news page. In your news page, you want to have title and time only. In your blog page, you want to have title, time and teaser.

RiteCMS is an open source CMS (Content Management System) software released under GNU/GPL license. Securimage & TinyMCE are copyrighted of their respective developers. The project began in 2009 as a fork of PhpSqliteCMS.net. The project has been maintained by Lucas Zhuang. Version 3.X is a new released with new features and compatible with Php 7. It has been tested on Apache and NGINX.

While we try our best to make it run as smooth as possbile, we offer no explicit guarantee or warranty. Use at your risk.

The RiteCMS project is now maintained by Lucas Zhuang. We now accept service requests, such as server administration, RiteCMS installation, customization, etc. All reqeusts should be directed to ZoriaMedia.com.

RiteCMS website is designed in Rhode Island, USA with love.

© 2021 Lucas Zhuang & the RiteCMS project.