Is there a database program for the Mac that makes it easy to import a CSV file into a table and then query and manipulate the data using ad-hoc SQL queries?  (A Windows example of a similar product would be Microsoft Access ... it also has forms and reports, which are not as important, but I would not mind a Mac solution that has those too.)
121154
I need a desktop database that will have a need for extensive 1-many, many-1, and many to many relationships.   I've built this kind of app with Microsoft Access, which I don't love, but does combine the database and a useful GUI.  Relational Database apps for Mac seem pretty thin. Filemaker's "relational" features are not much like anything I've used before.   Panorama is interesting, but also not really relational, no SQL, etc.   Is there a database system for Mac that functions similar to Microsoft Access?  UPDATE: While I am quite happy to use most of the tools suggested so far, I am looking for something which has an interface that non-technical types can use. It doesn't have to be as sophisticated as Access (which isn't all that sophisticated, I guess), but something more than a management tool. I should have been clearer; I thought the parallel to Access would speak for itself.  As far as I can tell, Filemaker is not an SQL database, though I guess it can speak to SQL databases in some way, so maybe I could kludge something together there. I'll try out the MySQL and SQLite tools as well, though they appear to be management tools...
59442
I feel kind of embarrassed here, I've always used the terms "column" and "field" completely interchangeably, which recently caused some confusion in a technical discussion.   I was told, though, that this wasn't correct, that it should be (translating each term into spreadsheet terminology, ignoring data types and all the other stuff that make databases useful):   Database Column: like a spreadsheet column  Database Record: like a spreadsheet row Database Field: like a spreadsheet "cell" (a specific column of a specific row)   Is this right? I could have sworn that column and field are used more interchangeably than that. I certainly have been.  So we don't add fields to a table, we add columns to a table, and fields are only relevant when talking about data within a record?  Other thoughts on column vs field?  Edit: to clarify, the current context is MS SQL Server. My background before SQL server was MS Access, which might influence my use of these terms.
8920
What SQL can be used to list the tables, and the rows within those tables in an SQLite database file - once I have attached it with the ATTACH command on the SQLite 3 command line tool?
1
What is the most efficient way to convert a MySQL query to CSV in PHP please?  It would be best to avoid temp files as this reduces portability (dir paths and setting file-system permissions required).  The CSV should also include one top line of field names.
36792
I need to insert 800000 records into an MS Access table. I am using Delphi 2007 and the TAdoXxxx components. The table contains some integer fields, one float field and one text field with only one character. There is a primary key on one of the integer fields (which is not autoinc) and two indexes on another integer and the float field.  Inserting the data using AdoTable.AppendRecord(...) takes > 10 Minutes which is not acceptable since this is done every time the user starts using a new database with the program. I cannot prefill the table because the data comes from another database (which is not accessible through ADO).  I managed to get down to around 1 minute by writing the records to a tab separated text file and using a tAdoCommand object to execute  insert into table (...) select * from [filename.txt] in "c:\somedir" "Text;HDR=Yes"   But I don't like the overhead of this.  There must be a better way, I think.  EDIT:  Some additional information:   MS Access was chosen because it does not need any additional installation on the target machine(s) and the whole database is contained in one file which can be easily copied. This is a single user application. The data will be inserted only once and will not change for the lifetime of the database. Though, the table contains one additional field that is used as a flag to indicate that the corresponding record in another database has been processed by the user. One minute is acceptable (up to 3 minutes would be too) and my solution works, but it seems too complicated to me, so I thought there should be an easier way to do this. Once the data has been inserted, the performance of the table is quite good. When I started planning/implementing the feature of the program working with the Access database the table was not required. It only became necessary later on, when another feature was requested by the customer. (Isn't that always the case?)   EDIT:  From all the answers I got so far, it seems that I already got the fastest method for inserting that much data into an Access table. Thanks to everybody, I appreciate your help.
39534
I have a co-worker who manages a large MS Access database that contains X &amp; Y fields for various locations he tracks.  We have previously exported the data to CSV and used the QGIS Delimited Text Plugin to plot the locations.  We would now like to be plot this data directly in QGIS by connecting to the MS Access db via an ODBC connection (as opposed to export to CSV).   Can QGIS consume the data from the ODBC connection to plot the X-Y locations? Can it be "live linked" to the ODBC connection so that when a project is re-opened, the layer "replots" all old and newly added locations dynamically (as opposed to exporting to shapefile, which would create a snapshot in time)? Can you create tabular ODBC connections that can be joined to spatial tables within QGIS?   You can do all of this in ArcGIS ("Add XY Data" tool), so it would be great if this capability existed in QGIS. I just cannot find anywhere that mentions its existence.  I am not planning to move to a spatial database.  As a GIS person myself, yes I know that it makes sense to move to a spatial database, and yes I have used PostGIS to manage this kind of data.  But these are not options right now.  The user is not a GIS person nor wants to be, and he manages his own database in MS Access and that will not change.  I am and am pulling him kicking and screaming into the GIS world and want to make it easy as possible.  He can live with exporting to CSV, I was just hoping there is a better solution USING ODBC FOR MS ACCESS and displaying the XY data in QGIS.
43367
How can I navigate folders and subfolders at the same time?  Like "column view" in Mac OS X.    Edit 2: I use Ubuntu 14.04 and I couldn't install Marlin, so I installed "Pantheon File Manager" instead.
50931
I've received a Microsoft Access .accdb file (version 2010 I believe) that I need to get some data from.  How can I open it in Ubuntu? Is there any tool that would allow me to do so?  PS: Read-only is fine, if it has CSV exporting capabilities, the better.
34791
This is the announcement post of the Stack Exchange Data Explorer. Its answers were meant to iron out the initial glitches 6 to 8 years ago.  If you have found a bug or need support  today with any of SEDEs features, please ask a new question and tag it with   What does it do? Allows you to run arbitrary SQL queries on the data dumps, and share those queries with your friends. Technical details It is hosted on the Stack Exchange infrastructure , the database is hosted on the same SQL Server version all other sites are hosted on. You can use most of the TSQL commands, even create temporary objects (but not User Defined Functions). The controls used are jQuery based, the grid is  . All query results are cached, so sharing a link to a query will not result in the server going in to a tailspin. The query edit control is a slightly modified  control, I also am considering bespin cause the inter iframe communication is nasty complicated. It gives up nice syntax highlighting for queries. Parameters There is support for parameterized queries, to get it to work name your params like ##this##. For example have a . Query name and description A query can have a name and description, to name it lead with a comment, to describe it continue commenting, for example: -- This is my query name  -- This is my description -- I can span multiple lines  SELECT 1  Anonymous users can initially name a query, but can not change the names of any existing queries. Tutorial There's a  which helps you getting started in writing your own SQL queries. Logging in You can use your openid provider to log in, at the moment once logged in we will track the list of queries you execute (giving you basic history support) Also if there are any params named UserId they will be populated automatically if your EmailHash matches the one on the site being queried. Magic columns If you alias an id column with as [Post Link] it will automatically create a link in the result set to the parent site. Similarly if you alias an id column with as [User Link] it will display a link to the user page. select top 10 * from Posts will show you how tags are done. (Magic columns for images is planned) example (most controversial posts:  ) So what are you waiting for, check it out at  Any feedback would be greatly appreciated. I hope to have the login section working fairly soon and allow voting on the best queries and commenting. Featured Queries At the moment, admins have permission to feature interesting queries on this page , I am looking for better ways to manage the huge query list that is building up.
50066
I've been using mac for years, but prefer to do software development on windows. I'm really used to is using the folowing shortcuts on windows very much:  &lt;CTRL&gt;  + INSERT: Copy &lt;SHIFT&gt; + INSERT: Paste &lt;SHIFT&gt; + DELETE: Cut   Of late, I've taken to doing even my development work on the Mac. However, as a matter of habit, I'm missing these shortcuts very much. Actually, I find these a lot more convenient than COMMAND + (C/V/X) combo.  Is there a way to reassign these three shortcuts at least?   I've look all over the internet and in the "Keyboards" system preferences but I did not find anything.  PS: If you're wondering where I find the INSERT keys on a mac book pro, I use a wireless keyboard.
93413
I’m in a permanent discussion with the developers of the company where I work because they say it is better to get rid of relationship enforcement (via FOREIGN KEY constraint definitions) in a relational database in order to speed up large queries and to gain better performance. The platform under consideration is MySQL 5.x, and no FOREIGN KEY has been set up, even some PRIMARY KEY constraints of the relevant tables are missing which, at least for me, is not reasonable. Maybe they’re right and I’m wrong, but I don’t have enough arguments to discuss about this situation. This has been the preferred approach for three years now. I’m new in this company (only one month) but, as the product “works”, there is hesitation to enhance the database; nevertheles, the first thing I noticed is one page taking 1 minute to load (yes, 60 seconds!). One of the claims behind the current state of affairs is that a “denormalized” database is faster than a normalized one, but I don’t believe that’s true. Most of the relevant queries include JOIN operations, which makes them run very, very, very slow with large amounts of data (the database contains millions of rows). Commonly, the handling of “CRUD” operations is implemented at the application program code level; for example, in order to DELETE some data FROM, let’s say, TableA:  it is necessary to first check on the fly if there is some relationship between the rows of TableA and TableB, in case that said relationship is “detected”, then the app program code won’t allow to DELETE the pertinent row(s), but if for some reason the app program code fails, then the DELETE operation will “succeed”, no matter if there is any relationship regarding the involved rows and tables.  Question Could you help me to elaborate a good, accurate and solid answer to enrich the debate?  Note: Maybe something like this has been asked (and answered) before, but I couldn’t find anything by means of Google.
74905
Specifically, in VS 2008, I want to connect to a data source that you can have by right-clicking on the automatically-generated App_Data folder (an .mdf "database"). Seems easy, and it is once you know how.
92565
I have a new app I'll be working on where I have to generate a Word document that contains tables, graphs, a table of contents and text.  What's a good API to use for this?  How sure are you that it supports graphs, ToCs, and tables?  What are some hidden gotcha's in using them?  Some clarifications:   I can't output a PDF, they want a Word doc. They're using MS Word 2003 (or 2007), not OpenOffice Application is running on *nix app-server   It'd be nice if I could start with a template doc and just fill in some spaces with tables, graphs, etc.  Edit: Several good answers below, each with their own faults as far as my current situation.  Hard to pick a "final answer" from them.  Think I'll leave it open, and hope for better solutions to be created.  Edit: The OpenOffice UNO project does seem to be closest to what I asked for.  While POI is certainly more mainstream, it's too immature for what I want.
79438
Can anyone explain how the LIKE operator is implemented in current database systems (e.g. MySQL or Postgres)? or point me to some references that explain it?  The naive approach would be to inspect each record, executing a regular expression or partial string match on the field of interest, but I have a feeling (hope) that these systems do something smarter.
113404
Very new to any form of code. Attempting to run a script in VBA that will pull data from an access database using SQL and put it into an excel spreadsheet. Code is similar to below. Runs clean but I don't know how to use the data it is pulling. Thanks in advance.   Sub Get_Data() Dim cn As Object Dim rs As Object Dim strFile As String Dim strCon As String Dim strSQL, strInput As String  strFile = "S:\Location.Database.accdb"  strCon = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" &amp; strFile  Set cn = CreateObject("ADODB.Connection") cn.Open strCon  strInput = InputBox("Input Desired Name")  strSQL = "SELECT NAME, Location WHERE NAME =""'strInput'"";"  cn.Execute strSQL  cn.Close Set cn = Nothing  End Sub
43896
I am using MS Access 2003. I want to run a lot of insert SQL statements in what is called 'Query' in MS Access. Is there any easy(or indeed any way) to do it?
3811
I found a feature request at  but it doesn't seem easy to get a column view with Nautilus while with Mac OS X it's a default feature.  Have I missed something or is this not currently possible?