Databases

macuk

I have been asked to build a site for a photography shop and so I really need to use a database, can this be done with Rapidweaver?

DavidRunsFromTheYeti

Use Kuler's SQL Stacks:

kulersolutions.com/products/rwstacks/
demo.kulersolutions.com/sqldemo/
vimeo.com/kulerkasts

I use the Kuler SQL Stacks on one of my sites and it really works well!

axeler

Hi David ,

Do you have a link for the site where you use the sql stack.
I did a simple sql stack integration into a test project but I'd like to learn the full potential of this stack. Although it's easy to set and making work the sql stacks, there is a lack of tutorial/info on how to set a sql database for picture or other files.

best
axeler

mitchellm

If you need an SQL database then the stack mentioned above is your only alternative (for a built-in solution for RW). However, I'm not quite sure what you mean by database. For example, if you database can be easily shown in MS Excel then you have some more options: stacks which display tables made up from CSV files (easy to create from Excel or other spreadsheet programs, perhaps also from a formal database program).

These CSV table stacks are very nice. There are 3 that I know of. barchard.net offers a stack that works very nicely with Google Docs (this allows for dynamic changing of the resulting table). WeaverAddOns offers a very nice CSV Grid stack that offers lots of important options for styling and displaying your table (sorting, searching, columns to leave out/in, etc. etc.)

For all the databases I've used so far (some fairly complex), I've been able to use CSVGrid stack to handle the info elegantly and quickly. Check it out:
http://weaveraddons.com/stacks/csv-grid/

I realize this may not be the best solution for you, but if interested in it direct message me and I can show you some examples (one fairly complicated).

DavidRunsFromTheYeti

Sure!

stillwaterpioneermemorial.org/database/

I agree about getting pictures into the sql database. I ended up using a thumbnail and a download link.

axeler

Thanks David,

nice looking database! Does your download link referencing to the RW resource folder?
Would mind, if you have time, to show me a screenshot of your sql table to see what kind of settings are needed to input the link in the sql table.
thanks

DavidRunsFromTheYeti

Thanks axeler.

Yes, the download link is just referencing the RW resource folder where I drop the pdf directly into Rapidweaver and let it upload it for me

The settings to input the link in the mysql table is actually a stack included in the bundle. You just put the link into the table. I have a screenshot here:

axeler

Very helpful, thanks a lot!

I forgot the stack link included in the sql stack bundle
best
have a nice day
A