Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Here's how my setup works - this may or may not be feasible for you, but I hope it helps somehow. I no longer use FTP for anything.</p> <p>You should get a DVCS setup, and which one you choose is entirely up to you. Any of them will be better than manually copying or not having anything at all. I suggest taking a look at both Git and Mercurial and making a decision from there. In my opinion, if you're using Windows primarily, Mercurial might be a better choice. If not, I'd say go for Git. You could always try both!</p> <p>I setup a <a href="https://github.com/sitaramc/gitolite" rel="nofollow">gitolite</a> server which acts as a central repository for all of my git projects. It is great to have a remote central repository because your entire codebase is backed up in the case that your workstation should fail - and on top of that, you can use it to do some code coordination to move your files around (and stop using FTP).</p> <p>Once that is setup, I start the process of <code>pull</code>ing and <code>push</code>ing to it - you talk about your IDE here, and there are a lot of Git IDE options, but I just use the command line - I just find it faster. Again, up to you on how to incorporate that.</p> <p>In terms of web development, I setup my gitolite server to use git-hooks to propagate changes to my servers. They all have the <code>git</code> client installed, so the codebase is usually in the webroot. When a change is pushed from my workstation to the gitolite server, it fires off some commands that automatically updates the production server. Not only is it convenient, but it also puts a copy of the codebase and its versions on your servers as well. Be careful with this though; you need to make sure you aren't sharing your <code>/.git</code> directory.</p> <p>The basic idea is to improve your development ecosystem. My Git setup is perfect for that. You might need to assess your entire workflow and make adjustments based on your needs.</p> <p><a href="http://nbgit.org/" rel="nofollow">Here's the <code>git</code> plugin for NetBeans.</a> I suggest using the command line when you get started, though.</p>
    singulars
    1. This table or related slice is empty.
    1. POUnderstanding Git, working with a php ide and ftp
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USNic
    1. USNic
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POUnderstanding Git, working with a php ide and ftp
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWhere would I setup a Gitolite server?? Would I need a dedicated server?? Are there free repositories that won't share my code?
      singulars
      1. PO
      1. UShairynuggets
    2. COYou would have to set it up yourself, and ideally in either a dedicated server or VM - if that seems like overkill, I'd checkout https://github.com/ :)
      singulars
      1. PO
      1. USNic
    3. COWhat would be the chances of somebody finding my code on github if using the free version?
      singulars
      1. PO
      1. UShairynuggets
 

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