From the [fine manual][1]:

&gt; **INIT FILE**  
&gt; sqlite3 reads an initialization file to set the configuration of the interactive environment.
&gt; [...]
&gt; If the file `~/.sqliterc` exists, it is processed first.  can be found in the user&#39;s home directory, it is read and processed.  It should generally only contain meta-commands.

So just put a file called `.sqliterc` in your home directory and put this in it:

    .headers ON


  [1]: http://manpages.ubuntu.com/manpages/bionic/en/man1/sqlite3.1.html

You can pass arguments in the command line too: 

    sqlite3 db.db  -header -column  &quot;select x from y;&quot;

I have a web site (not a solution) type project in VS2010.
I also have this folder configured as a web site in IIS7.  I can browse to my site fine when I navigate to http://myproject.local

This proves IIS is serving the site ok.

Now when I try and run the project from VS2010 so I can debug, I get the following error:

**Unable to start debugging on the web server. The IIS worker process for the launched URL is not currently running.**

I have the site properties set to invoke the custom server (IIS) at the correct URL.
What is the reason for Visual Studio implying that the IIS work process for the launched URL is not running, when clearly IIS is server the site.





Unable to start debugging on the web server. The IIS worker process for the launched URL is not currently running

I have a Postgres 8.4 database on a linux server that I have dumped using the following command:

    pg_dump --format=c --exclude-table=log --file=/path/to/output my_db

I then ftp the created file to my local Windows 7 machine and attempt to restore the file to my local Postgres 8.4 instance using the following command:

    pg_restore --create --exit-on-error --verbose c:\path\to\file

The restore command generates plenty of output claiming it created my database, connected to it, and then created all the other tables as expected.  However, when I view the databases on my local machine through pgAdmin the restored database doesn&#39;t exist at all.

In an attempt to troubleshoot I tried the following command:

    pg_restore --create --exit-on-error --verbose --host=blahblah --username=no_one c:\path\to\file

When I run this command even though the host and username given are complete nonsense I still get the exact same output from the command without any errors.

Has anyone run into this before or know what could by causing this?

Why is pg_restore returning successfully but not actually restoring my database?

Is there any way to configure sqlite3 so that the headers will display by default?

I know I can use `.headers on` to turn on headers, but I have to keep typing it every time I launch the client because the setting doesn&#39;t stick between sessions.  I want the headers to be on permanently.

How to configure sqlite to display headers by default

<p>Is there any way to configure sqlite3 so that the headers will display by default?</p>
<p>I know I can use <code>.headers on</code> to turn on headers, but I have to keep typing it every time I launch the client because the setting doesn't stick between sessions.  I want the headers to be on permanently.</p>


I have a problem: I need to delete a column from my SQLite database. I wrote this query

    alter table table_name drop column column_name 

but it does not work. Please help me.

Delete column from SQLite table

All I want to do is grab the stuff in alphabetical order and ignore the capital letters.

    db.rawQuery(&quot;SELECT &quot; + catName + &quot; FROM &quot;+tableName+&quot; ORDER BY &quot;+catName+&quot; ASC COLLATE NOCASE;&quot;, null);

This is the code I&#39;m using above, but it always gives me an SQLite exception saying that COLLATE is a syntax error.

&gt;android.database.sqlite.SQLiteException: near &quot;COLLATE&quot;: syntax error: , while compiling: SELECT Artist FROM testTable COLLATE NOCASE ASC


SQLite Query in non case sensitive alphabetical order

I am using the `query` functions in order to build the SQL queries for my tables. Is there a way to see the actual query that is run? For instance log it somewhere?

So far the best I could do was to have a look at the cursor&#39;s member mQuery using a breakpoint. I&#39;d love to output the queries automatically though. This member is of course not public and does not have a getter.

---

Just for the record, here is an implementation of the accepted answer. 

    /**
     * Implement the cursor factory in order to log the queries before returning 
     * the cursor
     * 
     * @author Vincent @ MarvinLabs
     */
    public class SQLiteCursorFactory implements CursorFactory {
    
    	private boolean debugQueries = false;
    
    	public SQLiteCursorFactory() {
    		this.debugQueries = false;
    	}
    
    	public SQLiteCursorFactory(boolean debugQueries) {
    		this.debugQueries = debugQueries;
    	}
    
    	@Override
    	public Cursor newCursor(SQLiteDatabase db, SQLiteCursorDriver masterQuery, 
                                String editTable, SQLiteQuery query) {
    		if (debugQueries) {
    			Log.d(&quot;SQL&quot;, query.toString());
    		}
    		return new SQLiteCursor(db, masterQuery, editTable, query);
    	}
    }

Logging SQL queries in android

I need to implement SQLite in my application. I followed this tutorial..
[Creating and using databases in Android one][1]

Everything is working fine. I inserted 1 row with 5 columns.
Now I want to update value of 1 column only and others will be remain same.

There is one update method in tutorial but it needs all the parameters, however I want to update only one column.


  [1]: http://www.android10.org/index.php/articlesdatastorage/235-creating-and-using-databases-in-android-one

Android SQLite: Update Statement

I&#39;m new to SQLite.  Is there a way I can export the results of a query into a CSV file?

SQLite: How do I save the result of a query as a CSV file?

I&#39;ve seen both full definitions of `struct`s in headers and just declarations—is there any advantage to one method over the other?

If it makes a difference, I usually typedef a struct like so in the `.h`

    typedef struct s s_t;

----

To be clear, the options are declaration in the header file and definition in the class, or both declaration and definition in the header file. Both should result in the same usability, even if one is by linkage, shouldn&#39;t they?

---

I see many almost duplicates, e.g. [here][1] but no exact matches. Please correct me if I&#39;m wrong in this regard.


  [1]: https://stackoverflow.com/questions/4136888/declaring-a-struct-in-h-file-and-implementing-in-c-file

Should struct definitions go in .h or .c file?

Is this possible?

    xmlHttp.send({
        &quot;test&quot; : &quot;1&quot;,
        &quot;test2&quot; : &quot;2&quot;,
    });

Maybe with: a header with `content type` : `application/json`?:

    xmlHttp.setRequestHeader(&#39;Content-Type&#39;, &#39;application/json&#39;)

Otherwise I can use:

    xmlHttp.setRequestHeader(&#39;Content-Type&#39;, &#39;application/x-www-form-urlencoded&#39;)

and then `JSON.stringify` the JSON object and send it in a parameter, but it would be cool to send it in this way if it&#39;s possible.



Javascript : Send JSON Object with Ajax?

So I have a class included in another class that keeps throwing a compile error of the form &quot;error: &#39;ProblemClass&#39; has not been declared. The files are set up thusly:

    #ifndef PROBLEMCLASS_H
    #define PROBLEMCLASS_H
    
    #include &lt;iostream&gt;
    #include &lt;cmath&gt;
    
    class ProblemClass
    {
      public:
    
        virtual void Init() = 0;
    };
     
    #endif

and the class where the error occurs looks like this:

    #ifndef ACLASS_H
    #define ACLASS_H
    
    #include &quot;problemclass.h&quot;
    
    class AClass : public Base
    {
      public:
    
        void DoSomething(ProblemClass* problem);
    
    };
    
    #endif

The compile error occurs at void Dosomething();

I&#39;m aware the code here isn&#39;t enough to solve the problem. I&#39;ve been unable to create a minimal example that can reproduce it. So my question is much more general; what sort of things might cause this? Is there anything in particular I should look for, or some line of enquiry I should be following to track it down?

This code compiles fine in an almost identical version of the project.

Help of any sort would be greatly appreciated, no matter how vague. I&#39;m using codeblocks 10.05 with mingw4.4.1 in win 7 64 bit.

error: Class has not been declared despite header inclusion, and the code compiling fine elsewhere

Can anyone explain how to create a header file in C with a simple example from beginning to end.


Creating your own header file in C

I have **domain.com**. If the user is logged in, it should load automatically **domain.com/option-X** where X is a predefined choice of the user.

So, I do this at the top of index.php:

    header(&quot;Location: /option-X&quot;); 

But, if the user is not logged in, I just choose automatically the first option like this:

    header(&quot;HTTP/1.1 301 Moved Permanently&quot;); 
    header(&quot;Location: /option-a&quot;); 

So, i have two questions regarding the implications of doing so:

1. Since the search engines crawlers won&#39;t be logged in, they will always get **domain.com/option-a** - does it affect them that it has a 301 header?
2. What could be the server cpu load of doing those redirects? I don&#39;t know how to make a test out of it. The current site (which has no redirects) has about 100k daily visits.

PHP header redirect 301 - what are the implications?

Is there a config way to set this up without having to specify which branch?

How can you git pull only the current branch?

In my endless quest in over-complicating simple stuff, I am researching the most &#39;Pythonic&#39; way to provide global configuration variables inside the typical &#39;**config.py**&#39; found in Python egg packages. 

The traditional way (aah, good ol&#39; *#define*!) is as follows:
    
    MYSQL_PORT = 3306
    MYSQL_DATABASE = &#39;mydb&#39;
    MYSQL_DATABASE_TABLES = [&#39;tb_users&#39;, &#39;tb_groups&#39;]

Therefore global variables are imported in one of the following ways:

    from config import *
    dbname = MYSQL_DATABASE
    for table in MYSQL_DATABASE_TABLES:
        print table

or:

    import config
    dbname = config.MYSQL_DATABASE
    assert(isinstance(config.MYSQL_PORT, int))

It makes sense, but sometimes can be a little messy, especially when you&#39;re trying to remember the names of certain variables. Besides, providing a **&#39;configuration&#39; object**, with **variables as attributes**, might be more flexible. So, taking a lead from **bpython** config.py file, I came up with:

    class Struct(object):

        def __init__(self, *args):
            self.__header__ = str(args[0]) if args else None

        def __repr__(self):
            if self.__header__ is None:
                 return super(Struct, self).__repr__()
            return self.__header__

        def next(self):
            &quot;&quot;&quot; Fake iteration functionality.
            &quot;&quot;&quot;
            raise StopIteration

        def __iter__(self):
            &quot;&quot;&quot; Fake iteration functionality.
            We skip magic attribues and Structs, and return the rest.
            &quot;&quot;&quot;
            ks = self.__dict__.keys()
            for k in ks:
                if not k.startswith(&#39;__&#39;) and not isinstance(k, Struct):
                    yield getattr(self, k)

        def __len__(self):
            &quot;&quot;&quot; Don&#39;t count magic attributes or Structs.
            &quot;&quot;&quot;
            ks = self.__dict__.keys()
            return len([k for k in ks if not k.startswith(&#39;__&#39;)\
                        and not isinstance(k, Struct)])


and a &#39;config.py&#39; that imports the class and reads as follows:

    from _config import Struct as Section
    
    mysql = Section(&quot;MySQL specific configuration&quot;)
    mysql.user = &#39;root&#39;
    mysql.pass = &#39;secret&#39;
    mysql.host = &#39;localhost&#39;
    mysql.port = 3306
    mysql.database = &#39;mydb&#39;
    
    mysql.tables = Section(&quot;Tables for &#39;mydb&#39;&quot;)
    mysql.tables.users = &#39;tb_users&#39;
    mysql.tables.groups =  &#39;tb_groups&#39;

and is used in this way:

    from sqlalchemy import MetaData, Table
    import config as CONFIG

    assert(isinstance(CONFIG.mysql.port, int))

    mdata = MetaData(
        &quot;mysql://%s:%s@%s:%d/%s&quot; % (
             CONFIG.mysql.user,
             CONFIG.mysql.pass,
             CONFIG.mysql.host,
             CONFIG.mysql.port,
             CONFIG.mysql.database,
         )
    )
    
    tables = []
    for name in CONFIG.mysql.tables:
        tables.append(Table(name, mdata, autoload=True))
        
Which seems a more readable, expressive and flexible way of storing and fetching global variables inside a package.

Lamest idea ever? What is the best practice for coping with these situations? What is *your* way of storing and fetching global names and variables inside your package?

Most Pythonic way to provide global configuration variables in config.py?

I have a parameters.ini file, such as:

    [parameters.ini]
        database_user    = user
        database_version = 20110611142248

I want to read in and use the database version specified in the parameters.ini file from within a bash shell script so I can process it.
&lt;!-- language: lang-sh --&gt;

    #!/bin/sh    
    # Need to get database version from parameters.ini file to use in script    
    php app/console doctrine:migrations:migrate $DATABASE_VERSION

How would I do this?

How do I grab an INI value within a shell script?

I could probably setup an alias, but it seems like I should be able to set this as an option in the config file, only I don&#39;t see anyway to do it.

I only want the `--ignore-space-change` when I&#39;m doing diff, not when I&#39;m doing apply or anything else.  I&#39;m trying to make the diff easier to understand by not cluttering it with with extraneous +/- lines that have no real changes on them.

How to make git diff --ignore-space-change the default

What&#39;s the difference between `build`, `runtime`, and `compile`, in `BuildConfig.groovy` (1.3.7)


    grails.project.dependency.resolution = {
    
        plugins {
            build &quot;acme:acme-cache:latest.integration&quot;
        }
    
        dependencies {
            build &quot;com.foo.bar:foobar:1.0.5&quot;       
            runtime &quot;org.apache.httpcomponents:httpclient:4.0.3&quot;
            compile(&quot;com.thoughtworks.xstream:xstream:1.3.1&quot;)
        }
    }







Content Type	Original Author	Original Content on Stackoverflow
Question	spemmo	View Question on Stackoverflow
Solution 1 - Sqlite	mu is too short	View Answer on Stackoverflow
Solution 2 - Sqlite	MaikoID	View Answer on Stackoverflow

How to configure sqlite to display headers by default

Sqlite Problem Overview

Sqlite Solutions

Solution 1 - Sqlite

Solution 2 - Sqlite

Why is pg_restore returning successfully but not actually restoring my database?

Unable to start debugging on the web server. The IIS worker process for the launched URL is not currently running

Attributions