I am looking at the man page for git ls-tree . It has an option for path.
I have a directory called db and in that directory I have a few .rb files.
Then why my command is failing
git ls-tree db/*.rb
Below is my current structure for MySQL database
id | item_name | item_files
------------------------------------------
1 | Item A | file1.zip,file2.zip,file3.zip
2 | Item B | file3.zip
Example I create simple form to fill up Item Name and Multiple upload files then store it to db.
Question :-
How to design the db structure for…
I'm a software developer troubleshooting a sticky problem on a client's production server, and I've got a bit of a problem.
They have a virtual server running Windows Server 2008, SQL Server 2008 R1 and IIS7. It was provisioned with two partitions: one that has the OS (~15 Gig), and the other has IIS' web sites (another ~15 Gig).
My…
What tools do you use / would you recommend for monitoring a Linux-based, DB-based website's servers for bottlenecks and load? The obvious goal being to know when growth has gotten to the point where it's necessary to scale up (or out) one or more of the bits and pieces because the current system won't be managing the load if an…
I am attempting to connect to a remote Oracle DB via ODBC. I am totally inexperienced and fail to connect.
What I have installed:
Oracle 'ODBC Driver for RDB'
A program I want to connect from (Altova Mapforce, an ETL)
What I do:
Under Administrative tools I open the Windows "ODBC Data Source
Administrator
I click…
I have a Win Form, Data Entry, application that uses 4 seperate Data Bases. This is an occasionally connected app that uses Merge Replication (SQL 2005) to stay in Sync. This is working just fine. The next hurdle I am trying to tackle is adding Filters to my Publications.
Right now we are replicating 70mbs,…
I need to setup a wireless IP camera (Trendnet TV-IP501W) on my network so that it is remotely visible from anywhere. Right now I successfully connected it to my home network but nothing else. My router is a Belkin N450 DB.
Any help would be much appreciated, including what this would be referred to as so I…
we've got a sql server 2005 instance that one of our guys messed up, i believe they killed the sql server service and restarted the computer, and when it came back all of our databases are "in recovery" and it times out every time we try to connect to it. it's been 'in recovery'and unable to connect to…
I'm hosting a postgresql database on a small windows azure Ubuntu 13.04 VM with a default postgresql.conf. I have a Rails application running on a medium windows azure Ubuntu 13.04 VM. When accessing the postgresql database the rails application is constantly timing out. In its database.yml I have the…
After moving some databases around (restoring, deleting, etc) we experienced an issue creating new databases. Specifically, When trying to create a new database MSSQL Server it failed because the "The database 'model' is marked RESTORING and is in a state that does not allow recovery to be run". As…
I updated my rails gem to 2.3.5 but I keep getting this error when running db:seed:
$ rake db:seed --trace
(in c:/Documents and Settings/Owner/workspace/thepatstudio)
rake aborted!
Don't know how to build task 'db:seed'
c:/Ruby/lib/ruby/gems/1.8/gems/rake-0.8.7/lib/rake.rb:1728:in `[]'…
I've created an XML file using the .Save() method of an ADODB recordset in the following manner.
dim res
dim objXML: Set objXML = Server.CreateObject("MSXML2.DOMDocument")
'This returns an ADODB recordset
set res = ExecuteReader("SELECT * from some_table)
With res …
I created user 'restriceduser' on my mysql server that is 'locked down'. The mysql.user table has a N for all priveledges for that account. The mysql.db table has Y for only Select, Insert, Update, Delete, Create, Drop; all other privileges are N for that account. I tried to create a…
I'm just starting reasearch about the best way to implement user authentication within my soon-to-be app.
This is what I have so far:
A desktop (Windows) application on a remote server. That application is accessed locally with a browser (it has a web console and MS SQL Server to…
I've designed an Access 2003 DB with 3 tables: APPLICATIONS, SERVERS, and INSTALLATIONS. Records in the APPLICATIONS and SERVERS tables are uniquely identified by a synthetic primary key (in Access, an "auto number"). The INSTALLATIONS table is essentially a mapping table between…
Hi
The situation:
In Outlook I get a message from a server.
The content of the message needs to be put into an Access db. But,
there may not exist another message with the same date. So, I need to
look into a db if there is already a message with the same date and
time. If…
Hi
I'm working with a program that accesses an MS-Access DB. The problem is that if I open the db file with Access, the values I see aren't the values I see when I'm using the program. For example, There is a table PARAMS with various program variables, one of them is the…
I am using sqlite in c++ windows, And I have a db size about 60M,
When I open the sqlite db, It takes about 13 second.
sqlite3* mpDB;
nRet = sqlite3_open16(szFile, &mpDB);
And if I closed my application and reopen it again. It takse only less then 1 second.
First,…
I am very new at admining mysql, and bad for me, something caused the db to get clobbered. There are many error messages in the log that I am not sure how to safely proceed. Can you give some tips?
Here's the log:
110107 15:07:15 mysqld started
110107 15:07:15 InnoDB:…
I have legacy DB that store dates that means no-date as 9999-21-31,
The column Till_Date is of type DateTime not-null="true".
in the application i want to build persisted class that represent no-date as null,
So i used nullable DateTime in C# //public DateTime? TillDate…
I'm using URIs to direct a function in a library:
$id = $this->CI->session->userdata('id');
$URI = $this->CI->uri->uri_string();
$new = "new";
if(strpos($URI, $new) === FALSE){
$method = "update";
}
elseif(strpos($URI,…
I found couple of discussion threads on this- but nothing which brought a comparison of all three mechanism under one thread.
So here is my question...
I need to audit DB changes- insert\updates\deletes to business objects.
I can think of three ways to do this
1)…
Has anyone found a way to make the ADO.NET Entity Framework work with OLE DB or ODBC data sources? Specifically, I need to work with an Access database that for various reasons can't be upsized to SQL.
This MSDN page says:
The .NET Framework includes ADO.NET…
I'm a starter in ROR
I' m using ruby 1.9.3 and rails 3.2.1
This is what appears on using rake db:create command
**>rake db:create
rake aborted!
Please install the mysql adapter: 'gem install activerecord-mysql-adapter' <can't activate mysql <~>…
I'm looking for suggestions as well as any benchmarks or observations people have. We are looking to rewrite our data access layer and are trying to decide between native C++ OLEDB or ADO.NET for connecting with databases. Currently we are specifically…