Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I have used Trac for several years already. First of all, the sqlite issue... You can easily switch to MySQL if You like to. We began to feel a bit of a laggy about the interface when the <code>wiki</code> table exceeded 1 million rows (a rouge script did that), so I guess You should be fine about performance with Trac. You can also use multiple nodes serving Trac, if that will be a problem (it's good to have 2 in case of a power/network failure anyway).</p> <p>If Your team has only 6 coders, You could consider putting all projects in a single Trac project and using the ticket's component or milestone fields. It should work just fine.</p> <p>It is also worth to note that Trac is extremely extensible through plugins that can be easily obtained from Web.</p> <p>I have no Trac link issues whatsoever so I can't comment on this problem. Could You be more descriptive?</p> <p>And about the <em>inability to easily setup multiple projects</em>... Our admins wrote a ~100 lines script that handles it and now it's like 5 minutes to set up a new Trac project. We have like 60 of them already. I don't know about Jira, but new projects are being set up rarely. You will want to create a report through a ticket query quite more often.</p> <p>If You consider commercial solution, take a look at <a href="http://www.fogcreek.com/FogBUGZ/" rel="nofollow noreferrer">FogBugz</a> - I've heard it's amazing... However it's not as extensible as Trac (You can't just use the rich python api to add a functionality You need - and I value this feature very high in Trac).</p> <p>Take a look on <strong>a length of</strong> <a href="http://trac-hacks.org/#Hacks" rel="nofollow noreferrer">Trac plugin list</a>. You can easily install any of them if You like to.</p> <p>EDIT: I found out later that it is easy to add projects in Jira, but Jira is harder to grasp than Trac due to the number of features it supports (and you probably won't use most of them in a 6-man team). Nowadays though, you need to consider Jira because of the <a href="https://www.atlassian.com/software/jira/agile" rel="nofollow noreferrer">Agile plugin</a>.</p>
    singulars
    1. This table or related slice is empty.
    1. POJIRA or Trac?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USPaweł Polewicz
    1. USPaweł Polewicz
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload