Tag Info

Hot answers tagged

3

Excel stores a copy of the queried data in the spreadsheet. You can set an option whether you want it to refresh on load, or only upon some manual intervention or VBA-based event. You can use Excel query data the same as you would any other data in Excel. In the absolute worst case, if there is some kind of limitation, you could copy your queried data to a ...


2

If you were using Windows you could use picasa from picasa.google.com. Pictures can be tagged with whatever you want and you can search based on those tags. Option 2: galleryproject.org It is web based and has a mysql database, but the gui is simple. You can tag pictures and search on those tags. There are addons/extension for additional functionality. ...


2

I would use the Power Query Add-In for Excel to tackle this. It can handle appending results from a SQL query to an existing table. http://office.microsoft.com/en-au/excel-help/append-queries-HA104149760.aspx?CTT=5&origin=HA103993872 If you store the data in the Excel Data Model format (not in an Excel Table), the data is highly compressed - there are ...


2

My first thought is that you don't... place pictures in a directory and you can store links to the files, tags, etc in the database.


1

Since you don't mention where do you want to implement your database, I assume you're doing this for a website, the approach I've been using is as follows: Let's say that I have a directory with 100 pictures, each one named in order: 1.png 2.png 3.png … 100.png So I construct a database which stores such images information in the colums as follows: id, ...


1

Your case is exactly like I had couple months ago. I also try to build SQL query in my head every time I need to do some manipulate with data in Excel. So, I have created a little Add-In called XLTools SQL Queries. Now I have published it on our website for others like you and me! It allows to build any SQL query against tables in Excel workbook(s) using ...


1

With your model open (this is required, as the navigation menus are context-aware), choose either "Synchronize Model" or "Synchronize with Any Source" under "Database".


1

Commits will queue up and all flush when the WAL gets written. So you'll get big groups of commits writing 5 times a second.


1

When i type psql template1 and then tab, i don't get the user "myuser" and don't know why. It's bash programmable completion feature which is at play here. It appears that for psql, tab does not suggest a list of user names on the command line when the cursor is after a database name. If does produces that list however, when the cursor is after -U. ...


1

MySQL dumps are only meaningful when restored into an actual database. The only integrity you could check over a dump is SQL syntax. But there is nothing you can do about the data. Usually database administrators will restore a random backup into a database and check the restore process works fine. Of course you have to do it at least one time when you ...



Only top voted, non community-wiki answers of a minimum length are eligible