perldiver: A false-color multi-spectrum image of Sol. (Default)
Add MemoryShare This Entry
This is a note for my professional memory. If you aren't a Catalyst programmer, feel free to skip it, but it's public so that Google can make it available to anyone who needs it.

My preferred webapp construction sequence starts as follows:
  1. Design ERDs in SQLEditor
  2. Export to .sql file for reference and so it's easy to have a "postflight.sql" script to add data, triggers, etc
  3. Import the .sql files into a SQLite DB
  4. Use helper scripts to generate a Catalyst app
  5. Use helper scripts to generate a DBIx::Class model against the SQLite DB
There are a few important things to know about step #5. First, the magic incantation can be found in this doc.(I always have to fumble around through the whole sequence to remember which it is.)

The second thing to know is that the Catalyst / DBIC helper scripts cannot handle any of the following constructs, all of which are legal for SQLite:
  1. IF NOT EXISTS in a create statement [e.g., do: CREATE TABLE foo... , not: CREATE TABEL foo IF NOT EXISTS...]
  2. Quotes around identifiers [e.g. do: CREATE TABLE foo , not: CREATE TABLE 'foo' ; same for column names, etc
I thought for a moment that putting the table name on the index would also break it, but actually the jury is still out on that; I didn't have any indexes in my create scripts.
There are no comments on this entry. (Reply.)

December

SunMonTueWedThuFriSat
      1
 
2
 
3
 
4
 
5 6
 
7
 
8
 
9
 
10
 
11
 
12
 
13
 
14
 
15
 
16
 
17
 
18
 
19
 
20
 
21
 
22 23
 
24
 
25
 
26
 
27
 
28
 
29
 
30
 
31