title: remote database creation in sql alchemy via sqlite
body: <p>I have an sqlalchemy application that currently uses a local database.The code for the application is given below.</p>
  
  <pre><code>log = core.getLogger()
  
  engine = create_engine('sqlite:///nwtopology.db', echo=False)
  Base = declarative_base()
  Session = sessionmaker(bind=engine)
  session = Session()
  
  class SourcetoPort(Base):
      """"""
      __tablename__ = 'source_to_port'
      id = Column(Integer, primary_key=True)
      port_no        = Column(Integer)
      src_address    = Column(String,index=True)
  
      #-----------------------------------------
      def __init__(self, src_address,port_no):
          """"""
          self.src_address = src_address
          self.port_no     = port_no
  </code></pre>
  
  <p>I want to create the database itself in a remote machine.I came across this document.
  <a href="http://www.sqlalchemy.org/doc_pdfs/sqlalchemy_0_6_3.pdf" rel="nofollow">http://www.sqlalchemy.org/doc_pdfs/sqlalchemy_0_6_3.pdf</a></p>
  
  <p>In the explanation they mentioned the lines given below.</p>
  
  <p>engine = create_engine(’postgresql://scott:tiger@localhost:5432/mydatabase’)</p>
  
  <p>My first question is </p>
  
  <p>1) does sqlite support remote database creation?
  2) How do I keep the connection to the remote machine open always? I don't want to initiate an ssh connection every time I have to insert an entry or make a query.</p>
  
  <p>These question may sound stupid but I am very new to python and sqlalchemy.Any help is appreciated.</p>