convert csv list to data in a database, assuming the mysql plugin is
correctly installed:
----
{(list "the list" template=mysqlinsert)}
/*
[[#mysqlinsert]]
[(template each)][(mysql "mysql-username" "INSERT INTO table (column
header) VALUES ({+p})")]
[[#end]]
*/
----
to get the same data out:
[(mysql "mysql-username" "SELECT column-header FROM table" join=',')]
Some knowledge of mysql syntax is of course required, but apart from
that its easy as pie.
On Dec 31 2009, 5:50 pm, Martin <[email protected]> wrote:
> Having a database can add some obstacles to keep your site online.
> It happens that you run into a site that does show a database error
> message only.
>
> Another point is how do you get your data in and get it out again.
> A plugin to convert csv data to pages and reverse would be handy.
> I do not know if there is a convienent solution for databases.
>
> Happy New Year (in a couple of hours)
> Martin
>
> On Dec 31, 1:47 am, Erlend Sogge Heggen <[email protected]> wrote:
>
> > Thanks for your answer. I was also not aware of that MySQL plugin,
> > that is very interesting. Allrighty then, I got what I wanted :)
>
> > On Dec 30, 11:18 pm, DrunkenMonk <[email protected]> wrote:
>
> > > Deploying a flat-file wiki is much simpler. The self contained
> > > structure is something of a blessing on the multi-purpose servers I
> > > use Boltwire on, where the file system and databases are otherwise
> > > quite easily cluttered.
>
> > > Since Boltwire has a perfectly usable mysql plugin if one has database-
> > > friendly information to store, I really don't see any problems with
> > > the setup. Bearing in mind, of course, that exceptionally large sites
> > > may slow down with a flat-file backend. Most wikis, however, are
> > > simply not that large.
>
> > > On Dec 30, 5:48 pm, Erlend Sogge Heggen <[email protected]> wrote:
>
> > > > So I searched around a bit more and realized that 'flat files' appears
> > > > to be the term I'm looking for for 'db-free' systems. I found a couple
> > > > half-decent debates and comparisons on the topic, but none of them put
> > > > the argument in the context of online wikis, which is what I hope to
> > > > see in stronger light here.
>
> > > >http://www.databasedev.co.uk/flatfile-vs-rdbms.htmlhttp://www.pmwiki.......
>
> > > > What have you got? ;)
>
> > > > On Dec 30, 5:26 pm, Erlend Sogge Heggen <[email protected]> wrote:
>
> > > > > I would like to raise awareness to the fact that BoltWire is a
> > > > > database-free system. Developers I've talked to about BoltWire usually
> > > > > considers it a downside. Frankly, it's one of the reasons my project
> > > > > is moving away from DokuWiki as well, because it is not quite as
> > > > > manageable.
>
> > > > > Once upon a time it was the simpler install, but these days even most
> > > > > free hosts come with free sql access.
>
> > > > > What can be said in defense of a db-free system?
--
You received this message because you are subscribed to the Google Groups
"BoltWire" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/boltwire?hl=en.
