Tag Info

Hot answers tagged

18

@Nitrodist's answer will work, but it's over-engineering the problem. MySQL's command-line client supports the very handy -e switch, like so: mysql -uroot -e "create database 'foo'" You can of course substitute any valid SQL into there.


17

Reverse Engineering in Visio 2013 has been removed, according to the Visio blog: http://blogs.office.com/b/visio/archive/2012/10/17/uml-and-database-diagrams-in-the-new-visio.aspx Deprecations The new software and database diagramming capabilities in Visio represent a departure from the capabilities of previous versions. We place a strong ...


17

I don't think anyone really knows. The most up to date information I can find is an interview with Quentin Clark in which he says that "most of WinFS either already has shipped, or will ship" just in other forms, such as part of SQL server or the ADO.net entity framework. I personally suspect it was one of those projects that was poorly defined from the ...


15

Here are a couple of ideas: Use Replication: http://www.howtoforge.com/mysql_database_replication Use mysqldump in an import/export script to semi-automate it


15

In the Export tab for your database, there's a checkbox on the lower right that says Data. Uncheck it and you should only have the bare structure in your export file.


14

You already had PostgreSQL installed, and you deleted the data dir without stopping the running server. So you now have some orphan PostgreSQL server processes that are managing data files that've been deleted, so they're no longer accessible in the file system and will be fully deleted when the last open file handle to them is closed. You can't use pg_ctl ...


14

The output of the tree command seems to display what you're looking for: . └── photos └── beach ├── 1.jpg -> me_and_dog.jpg └── me_and_dog.jpg Newer versions of the command will even output to HTML, XML or JSON. XML Output: <?xml version="1.0" encoding="UTF-8"?> <tree> <directory name="."> <directory ...


13

DDL = Data Definition Language From the Wikipedia entry for DDL: A Data Definition Language (DDL) is a computer language for defining data structures. The term was first introduced in relation to the Codasyl database model, where the schema of the database was written in a Data Definition Language describing the records, fields, and "sets" ...


11

FileMaker Pro would be your best bet. It's powerful, easy to user and mature. Check out their website.


10

According to MySQL's documentation, the mysql can take commands from stdin shell> mysql -uroot < script.sql > output.tab You can use Process Substitution to accomplish this: shell> mysql -uroot <(echo "create database mydatabase;") or you can just pipe it to the stdin of mysql normally: shell> echo "create database mydatabase;" | ...


9

Note Because Firefox must be closed to perform this procedure, be sure to open this page in another web browser or print it out before proceeding. After hours of work trying to recover the Places database, even reading the Firefox source code, I've managed to succeed. Here's how I did it: Download the latest version of the SQLite shell and extract it ...


9

This is a huge topic. I just completed a selection process at the college where I'm IT Director for a system such as you describe, and I can tell you that they run into the hundred's of thousands of dollars or more, depending on school size. This is especially true when you tack on that billing requirement (most SIS-only systems don't do much for billing). ...


8

I use: http://www.sequelpro.com/ also, how about squirrel? http://squirrel-sql.sourceforge.net/


8

SQLyog Enterprise and Ultimate can do this. SQLyog has a free version although it cannot do the syncing operations unfortunately. The paid versions start at $69 but a 30-day trial is available. For a free solution, replication is your best bet as quickcel outlined, although it requires a bit of configuration.


8

Found this.... Aqua Data Studio Features Screenshots Download Aqua Data Studio is a complete Integrated Development Environment (IDE) for database developers. It provides four major areas of functionality: 1) Database query and administration tools; 2) a suite of compare tools for databases, source control and file systems; 3) a complete and ...


6

Picasa 'is' online... You can keep it closed for the public as well. It is as close as it gets to picasa! ;) http://gallery.menalto.com/ Good alternative


6

This is gonna sound really naive, but what about @gmail if it's for personal use ? Or a small application like CintaNotes (notes, taggable, searchable) ... maybe OneNote, although that seems overly complicated for this sort of thing. Or something like Code Warehouse. Anyways, do post if you find a better solution. I'd be interestd to hear about it, ...


6

For MySQL there is MySQL Workbench: MySQL Workbench is a cross-platform, visual database design tool developed by MySQL. It is the highly anticipated successor application of the DBDesigner4 project. MySQL Workbench will be available as a native GUI tool on Window, Linux and OS X.


6

How about using Mendeley? Mendeley Desktop is academic software that indexes and organizes all of your PDF documents and research papers into your own personal digital bibliography. It gathers document details from your PDFs allowing you to effortlessly search, organize and cite. It also looks up PubMed, CrossRef, DOIs and other related ...


6

Dump this in your classpath: http://www.h2database.com/automated/h2-latest.jar And then call Class.forName("org.h2.Driver"); That should do it.


6

Choose a nearby column and write =MOD(ROW(A1),5) on the first row. This will fill all rows in that column with numbers 0-4. Then simply autofilter out rows you want to delete:Data > Filter > AutoFilter Edit: Since it's a recurring date you could probably also just use a wildcard when filtering, ie 14-*


5

The term is : "Reporting tool" With this term you can do a search on the web, don't forget to add your DB, because reporting doesn't always work with all DBs


5

Here's one of the complicated solutions. It's probably best just to paste this in and hope for the best rather than trying to sit down and parse this. =INT(MOD(MID(B2,FIND(":",B2,FIND("-",B2))-2,2) - LEFT(B2,FIND(":",B2)-1)+(MID(B2,FIND(":",B2,FIND("-",B2))+1,2) - ...


5

SQLite Database Browser is a good example. There are also a bunch on this StackOverflow question. Sometimes it's a good idea to search there too, as using your computer often overlaps with programming it ;-).


5

Looks like your "Add Entry" button is off screen for some reason.


5

pgAdmin -> Only for PostgreSQL SQL Workbench -> For many RDBMS


5

You can absolutely do this with Tables, as well as Powerpivot and Data Explorer. The easiest, and my preferred method currently, is to create a parameterized query in Excel. To do this use the Query Wizard and at the end add constraints for each parameter you want to pass. Once this is done, you can edit the Connection Properties and assign the Parameter ...


5

When it comes to storing large amounts of data, content providers use Storage Area Networks, also known as SANs and SAN storage hardware. From Wikipedia: A storage area network (SAN) is a dedicated network that provides access to consolidated, block level data storage. SANs are primarily used to make storage devices, such as disk arrays, tape ...


5

There are plenty of opensource rdbms. PostgreSQL and MySQL are among the more common ones.



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